Microsoft Office Professional 2010 Step by Step eBook

985

Symbols &

Numbers

$ (dollar sign) in absolute references, 294

= (equal sign) in formulas, 286

##### error code, 301

#DIV/0! error code, 301

#NAME? error code, 301

#REF! error code, 301

#VALUE! error code, 301

[ ] (square brackets) in formulas, 289, 299

3-D borders, 128

35mm slides, 486

100% button (Publisher), 904, 978

A

A3 Paper slide size, 486

A4 Paper slide size, 486

absolute references in formulas, 307

changing to relative references, 294

dollar sign ($) in, 294

.accdb file extension, 753, 791

accent colors, 426

Accept button (Outlook), 733

accepting meeting requests, 698

accepting tasks, 733

Access 2010

closing, 757

starting, 748

Access Help button, 751

Access icon, 750

Access Options dialog box, 792

Access Services, 795

accessibility, checking, 219, 503

accounts. See e-mail accounts

active cells, 260

in cell group, 261

in filtering, 349

active document, closing, 48

Active view (Calendar), 701

ActiveSync icon (OneNote), 550

Add Holidays to Calendar dialog box, 686

add-ins (Word), 24

adding values together, 286

Address Block button (Publisher), 970

address blocks, 970

Address Book button, 648, 658-659

address books

accessing, 647

adding contacts to, 621

adding to default search list, 602

Contacts, 646

contacts, adding, 664

creating, 647

custom, 647

Global Address List (GAL), 648

Mobile Address Book, 646

organizing, 647

overview of, 646

printing, 667-668

search order, changing, 602

Suggested Contacts, 646

viewing, 659

views, selecting, 660

addressing e-mail messages, 605, 658

AutoComplete, 601, 615

comma-separating addresses, 601

adjusting columns to fit contents, 805

adjusting shapes, 470

Advanced Filter dialog box, 358-359

Advanced Filter Options button, 857, 860

Advanced Filter/Sort command, 859

Advanced View Settings dialog box, 661

advanced options (Word), 22

advertisement building blocks, 945

Advertisements button (Publisher), 945

AGGREGATE function, 357-359

Align button (Publisher), 926

Align Center button (Word), 155

Align Center Right button (Word), 156, 163

Align Text Left button (PowerPoint), 438

Align Text Right button (PowerPoint), 438

aligning borders, 943

aligning labels in forms, 838

aligning pictures, 926, 928

aligning WordArt, 911

aligning text, 121-122, 125-126, 438

around pictures, 169

with tab stops, 121

in tables, 155-156, 163

Index.

    Contents

Index......................

985