A
accepting task requests 341
Access. See Microsoft Access
activating
object area 168
title area 169
windows 20
windows, from taskbar 20
worksheets, hidden 100
activating windows from taskbar 70
active cells 99
changing 101
identifying in range 106
activities, tracking, for Outlook contacts 307
assigning to categories 304
categories, creating 303
creating, for Outlook contacts 296
deleting 302
displaying in detailed
view 305
editing 300
organizing 302
saving 299
addresses, entering, for Outlook contacts 298
addressing e-mail messages 284
Align Left button (Formatting toolbar) 26
Align Right button (Formatting toolbar) 25
aligning
edges, evenly. See justifying paragraphs 25
tables 92
text, with Click and Type 32
worksheet entries 101
All Entries button (AutoText toolbar) 40
Allow Zero Length property 229
anniversaries, entering for Outlook contacts 301
append queries, moving records with 268
applications
copying between 353
importing/exporting files between 350
starting, with Office shortcut bar 347
applying
borders 74
styles 88
appointments. See also events
attaching files to 316
canceling 322
changing scheduled time 314
converting into recurring appointments 316
creating 313
creating, from e-mail messages 313
creating tasks from 331
deleted, restoring 322
deleting 322
editing 314, 320
finding 323
increasing length of 321
locations, selecting 314
moving 320
private, creating 315
recurring, canceling 322
recurring, converting to regular appointments 322
recurring, creating 316
recurring, editing 321
recurring, scheduling 315
reminders, setting 314
rescheduling 320
saving 315
scheduling 312
scheduling, at nonstandard times 313
status, changing 314
arguments in functions. See functions
arguments, text values as, in formulas 138
arranging windows 20, 134
arrows, adding to graphs 200
attaching
files, to appointments 316
signatures, to e-mail messages 288
attachments, e-mail 287
icon indicating 289
inserting 287
opening 290
saving 291
virus scanning 291
AutoContent Wizard 160
bypassing sections of 161
graphs, customizing 190
AutoCorrect 36
vs. AutoText 36
bypassing 42
entries 40 “41
exceptions, setting 42
inserting entry 36
options, turning on/off 42
paragraph formatting, retaining 38
turning off 42
AutoFill
copying formulas with 140
custom lists 141
AutoFit Options button 166
AutoFormat As You Type, turning on/off 78
autolayouts 164
Clip Art 182
Title and Text 164
Title, Text, and Content 190
Automatic Layout button 185
automatic spelling/grammar checking 58
automatically starting programs 282
autopicking meeting time slots 327
AutoRecover, saving info 32
AutoReports, creating 271
AutoShapes, adding to slides 184
AutoSum, creating formulas with 118
AutoSum button (Tables and Borders toolbar) 93
AutoText 36
vs. AutoCorrect 36
categories, displaying 39
entries, creating 36, 38
entries, deleting 41
entries, inserting 38, 39
entries, previewing 39, 40
entries, reviewing 39, 40
inserting 36
paragraph formatting, retaining 38
toolbar, displaying 38
AutoText button (AutoText toolbar) 39
averages, calculating, in spreadsheets 126
axes, graph, adding titles 197