N


N function, 974

#N/A error, 438, 581, 682

NA function, 974

Name box, 442

#NAML? errors

editing named references and, 444

errors in function syntax, 490

overview, 438

sorting and, 682

troubleshooting, 494

workbooks not open and, 854

Name Manager feature, 12–13, 443–444

named references. See also cell references

as arguments, 492

circular, 464–466

editing, 444

in functions, 495

jumping to named cells, 452

linking to, 897

named cell ranges, 441–452, 897

Scenario Manager and, 590

Solver add-in and, 604

names

cell ranges, 441–452, 897

cells, 441–452, 604

constants, 448

creating automatically, 446–447

criteria ranges, 693

deleting, 444

document workspaces, 817

drawn shapes, 346

duplicates, 446

editing, 444–445

extracted rows, 698

fields in Query, 768

files, 52–53

formulas, 448, 699–700

functions and, 495

jumping to named cells, 452

linking to named ranges, 897

listing for worksheets, 450–451

macros, 831, 852

in mail merge data, 901

meaningful, in formulas, 699–700

order of components in, 452

PivotTable fields, 724

replacing references with, 451–452

rules for, 445

scenarios, 590, 594

series, 623

shapes or graphics, 388

tables, 455, 457, 671, 702

three-dimensional, 448–449

users, 791

windows, 172

workbook-only, 445–446

worksheet-only, 445–446

worksheets, 946

natural language formulas, 17, 456. See also structured references

navigating. See also scrolling

cells and worksheets, 931–932, 946

to end of cell, 145

to first cell in current window, 128

to first cell in row, 128

to first cell in worksheet, 128

Go To commands, 129, 132–136, 145, 452

Help topics, 940–941

keyboard shortcuts, 126–128, 145, 930–932, 942–943, 946

to last cell in active area, 128

to last cell in current window, 128

menus and commands, 942

with mouse, 126

multipage embedded or linked documents, 882

one word at a time, 145

over multiple selections, 134

Print Preview window, 421, 943

Ribbon and buttons, 942

task panes, 945

through text, 938

between workbooks, 165–166

within workbooks, 27–29

negative numbers, 138

NEGBINOMDIST function, 974

nested IF functions, 509

nesting formulas, 9, 243

.NET Passports, 803, 806

net present values, 537

network addresses, 228. See also Web sites

NETWORKDAYS functions, 534, 974

networks

hyperlinks to server locations, 874

linking vs. embedding data from, 882

sharing workbooks on, 790–798

working with files on, 789–790

Neutral cell styles, 279

new and changed features

Analysis Toolpak, 13

arguments, 9

arrays, 10

Auto Complete, 11–12

AutoFilter items, 9

capacity, 9–10

categories of functions, 10

cell formats, 9

Chart Tools, 13–14

collaboration, 15, 19

colors, 9

conditional formatting, 7–8, 9

creation tools, 12

database connectivity, 11

dual processor support, 10

file formats, 14, 17

filtering, 15

Find results, 9

formatting tools, 6

formulas, 9, 10, 11–12

functions, 9, 10

graphics, 5–6

Help, 18

IRM (Information Rights Management), 19

lists, 17, 19

Lotus 1-2-3 support, 17–18

memory usage, 9

Microsoft Office Button, 4

multithreading support, 10

Name Manager, 12–13

natural-language formulas, 17

nesting levels, 9

Office Assistant, 17

output tools, 6

Page Layout features, 6, 8

PDF files, 15

PivotCharts, 10–11

PivotTables, 9, 10–11

range names, 12–13

Research task pane, 18

results-oriented user interface, 4–5

retired features, 16–18

rows and columns, 9

security, 16

sharing files, 15

side-by-side comparison, 18, 169, 170–171

size, 9

SmartArt, 5–6

sorting, 9, 15

speed, 9–10

statistical functions, 18

tables, 10

task panes, 18

templates, 7

themes, 6

XLSX file format, 14

XML support, 14–15

XPS (XML Paper Specification), 15

new cell styles, 280

new comments, 251–252

new formatting rules, 290–291

new tables, 273

new workbooks, 46–48

Next Year filtering, 688

NLFs (natural-language formulas), 17, 456

NOMINAL function, 974

nonadjacent cells and ranges, 349, 518, 655–658

nonprinting objects, 390

nonlinear problems, 609

nonrandom numbers, 575–576, 578–579

Normal cell style, 706

Normal distribution, 575, 577

NORMDIST function, 974

NORMINV function, 974

NORMSDIST function, 974

NORMSINV function, 975

not equal to operator (< >), 478

NOT function, 508–509, 975

notes and comments

adding to cells, 251–252

charts, 628–629

checked-in documents, 810

clearing, 203

deleting, 252

displaying, 252, 415

documenting macros and custom functions, 851–852

editing, 252

Excel Web Access and, 821

finding, 131–132

hiding, 252

keyboard shortcuts, 944

links to, 252

pasting, 187

printing, 252, 415–416

red triangle indicator, 251

on scenarios, 593

selecting, 131–132

text boxes, 352–353

in Visual Basic Editor, 835

notifications

for busy files, 790

macros, 828

SharePoint tasks, 814

NOW function, 491, 531–532, 833, 851, 975

NPER function, 539–540, 975

NPV function, 537, 975

#NULL! error, 438, 682

null format, 315

#NUM! error

numeric value limits, 467

overview, 438

RATE function, 540

in security functions, 545

sorting and, 682

Num Lock mode, 127

number filters, 687–688

Number property, 868

number signs (###), 140, 458, 531

numbering pages, 405, 408, 410

numbers. See also numeric text; numeric values

data entry, 138

decimal fractions, 467, 545

decimal points, 138, 209, 211, 301, 502, 503

formatting. See numeric formats

fractions, 139, 304–305, 467, 534, 545, 605–606

hiding, 315

integers, 502, 605

negative, 138

nonrandom, 575–576, 578–579

random, 500, 575, 576–579

separators, specifying, 210

numeric formats. See also numeric text; numeric values

accounting, 301–304

axis labels, 643

billings, 313

cell styles, 279

codes, 311–312

color, 313–314

conditional operators, 314–315

creating, 307–312

currency, 299–301

custom formats, 309–315

dates and times, 526–530

decimal points, 138, 209, 211, 301, 502, 503

exponential notation, 305–306

four-part, 312

fractions, 139, 304–305, 467, 534, 545, 605–606

hiding numbers, 315

keyboard shortcuts, 940

locale and, 306–307

null, 315

Number format, 298–299

overview, 298–299

part numbers, 313

pasted tables in Word, 891–893, 895

percentages, 304

phone numbers, 306–307

PivotTables, 722

ranges, conditional formatting, 287

scientific notation, 305–306

social security numbers, 306–307

special formats, 306–307

symbols, 309–311

text, 306

underlining, 303

ZIP codes, 306–307

numeric keys, 932–933

numeric text

behavior, 306

formulas, 436

IS functions and, 512

text functions and, 503

numeric values

as arguments, 491

averaging, 502

decimal fractions, 467, 545

decimal points, 138, 209, 211, 301, 502, 503

fractions, 139, 304–305, 467, 534, 545, 605–606

generating random numbers, 500

in imported text files, 753

integers, 502, 605

negative numbers, 138

PivotTable field assignments and, 717

precision in, 467

rounding, 500–501

sorting and, 682

truncating, 502



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net