Online Traning Solutions - Quick Course in Microsoft Office XP
A
absolute references 142
accepting task requests 341
Access. See Microsoft Access
action queries 257
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
address cards
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
all-day events 317
Allow Zero Length property 229
AND operator 264
animation effects 203 “4
anniversaries, entering for Outlook contacts 301
Answer Wizard 32
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
Arrow button 200
arrows, adding to graphs 200
assigning tasks 340
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
auto-hiding taskbar 3
AutoComplete 39
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
autoformats 114
autolayouts 164
Clip Art 182
Title and Text 164
Title, Text, and Content 190
automatic formatting 78
Automatic Layout button 185
automatic spelling/grammar checking 58
automatically starting programs 282
AutoNumber data type 224
autopicking meeting time slots 327
AutoRecover, saving info 32
AutoReports, creating 271
AutoShapes, adding to slides 184
AutoShapes button 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
AVERAGE function 126
averages, calculating, in spreadsheets 126
axes, graph, adding titles 197