Name AutoCorrect option, 892–893
#NAME? error, 460, 466
Name Manager button, 409
Name Manager dialog box, 410, 413
named references as arguments, 458
names
cells and cell range, 407–419
changes to worksheet-level, 411
configuring comment reviewers’, 309–310
creating list of defined, 416–417
defining and managing cell, 409
editing references to, 410
field, 859, 918
formula, 411
linked Outlook/SharePoint Services folders, 737–738
name separators in SQL, 929
naming multiple selections, 350
overwriting existing names with pasted, 416
replacing references with, 417–419
semiautomatically creating, 412–413
specifying field names in queries, 933–934
3-D, 414–415
using in formulas, 408–409, 415–416
variable, 1092
VBA requirements for, 1084
workbook-wide vs. worksheet-only, 411–412
worksheet, 364
namespaces in XML, 1153–1154
natural-language formulas, 422
Navigate Together option (Groove), 144
navigating
in Datasheet view, 940–942
Excel regions, 341–344
between open workbooks, 379–380
Navigation Options dialog box
adding categories from, 798–799
creating and modifying
custom categories, 800–801
groups in custom categories, 801–805
display order rules for, 803
hiding custom groups in category, 809–811
illustrated, 798
opening, 797–798
revealing hidden shortcuts with, 814–817
Navigation Pane
Access, 766, 787–789
displaying single category, 823
hiding group in, 811
repositioning shortcuts, 820
views in, 790–795, 818–820
adding categories to, 798–799
choosing databases from, 848
expanding and contracting width of, 789
hiding and renaming object shortcuts, 811–814
jumping to objects in, 788
Notebooks, 92, 95–96
Outlook’s use of, 631–632
query list in, 904
revealing hidden shortcuts on, 814–817
negative constants, 354
nested structures
indenting code for, 1113
nested IF functions, 473
nesting multiple loops, 1110
Network News Transfer Protocol (NNTP), 656–657
network settings for Groove, 180–181
New Alert page, 727, 728, 745, 746
New Alerts dialog box, 745
New Name dialog box, 409, 411–412, 413
New Notebook Wizard, 93–94, 121–122, 124
New Presentation dialog box, 17, 18
New Range dialog box, 376, 377
New Search Folders dialog box, 678
“New World of Work, The” (Gates), 4
newsgroups, 656
NNTP (Network News Transfer Protocol), 656–657
noncontiguous selections in Excel, 345–347
Normal template changes, 214
Normal view (PowerPoint), 533
not equal to (<>) operator, 444, 869, 1113
NOT logical function, 473
NOT operator, 869
note containers, 101–102
note tags menu, 103
notebooks.
See also notes; shared notebooks
adding
hyperlinks to, 98, 114
pages and grouping, 99–100
changing options for, 107
creating, 93–94
date and timestamp for pages, 101
drawing in, 116–117
embedding references to files in, 108
expanding and collapsing, 94
finding information in, 119–120
handwriting in, 116
inserting
images in, 115–116
screen clippings in, 113
moving content to other applications, 109
notes
adding and working with, 100–103
mobile devices for taking, 115
sharing via e-mail, 130
tagging, 103–105
OneNote window for, 94–96
opening section of, 94
organizing, 92–100
printing files to, 105–106
protecting shared sections of, 124–126
publishing, 130
searching password-protected sections of, 126
section organization for, 96–98
sending Web page to, 112–114
sharing
during Live Session, 127–130
existing, 122, 127
on multiple computers, 120–122
sound and video recordings in, 109–111
types of, 92
working with shared, 123–124
Notebooks navigation pane, 96
Notepad
Groove, 160–162
XML, 1147–1148, 1163
notes.
See also notebooks
adding headers and footers to Outlook, 558
adding to received Outlook messages, 679
printing slide show, 624–626
publishing, 130
tagging notebook, 103–105
taking in Groove, 160–162
text notebook, 100–103
Notes folder for Outlook, 649
Notes Page view (PowerPoint), 533
Notes pane
cutting and pasting comments into, 588
scanning presentation for notes in, 595
NOW function, 457
Null fields, 866
Null values
concatenating, 920
using ampersand with Null fields, 920
Number data type, 858, 859
number sign (#)
input mask character, 870
single-digit wildcard character, 869
truncated cell data indicated with multiple, 356
numbers
changing format of PivotTable data, 496
concatenated date becomes serial, 471
conversion to scientific notation, 355–356
entering in Excel, 354
functions for rounding, 464–465
including text with numeric entries, 358–359
MROUND function for rounding, 465
numbering document lines, 231–233
numeric precision in Excel calculations, 433
numeric text in formulas, 402
numeric values
arguments as, 457
errors when typed as text, 476