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