N

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