Index_C


C

calculation areas in worksheets 123
calculations, spreadsheet 126
named cells /ranges in 128
calculations, in tables 92
Calendar (Outlook) 310
appointment pane 310
appointments. See appointments
Date Navigator. See Date Navigator
deleting holidays from 312
displaying 310
events. See events
holidays, adding 312
networking options 327
PDAs and 311
printing 311
sharing 327
switching views in 311
time interval, changing 310
work day, changing default 312
work week, changing default 312
canceling
appointments 322
events 322
meetings 329
capital letters , small 73
Caption property 227
captions 227
categories
assigning Outlook contacts to 299
assigning tasks to 337
AutoText, displaying 39
creating 303
deleting 304
master category list 304
putting contacts into 304
sorting tasks by 339
cell references 101
in formulas 120
inserting in formulas 116
cells, addresses/references 99
cells, datasheet 192
cells, table 91
deleting contents of 92
moving among 91
totaling values to the left 93
cells, worksheet 99
absolute references 142
active 99
active, changing 101
aligning text in 101
applying borders to 124
attaching comments to 110
checking spelling in 101
clearing 110
clearing formatting 146
deleting 112
fill handles 140
formatting 113
formatting as currency 114, 125
formatting as numbers 139
highlighting with certain criteria 128
identifying active in range 106
inserting 112
named, in calculations 128
naming 120, 128
naming conventions 122
naming, in formulas 121
overwriting contents of 119
references. See cell references
relative references 142
selecting 101
selecting all in column/row 106
Center button (Formatting toolbar) 26, 72
centering
graphs 156
table entries 93
text 26, 72
worksheet entries 124
worksheet headings 113
worksheets, on page 131
changing bullet symbols 171
character formats 24
character styles vs. paragraph styles 84
characters
formatting 72, 112
formatting, displaying 73
hidden. See nonprinting characters
nonprinting. See nonprinting characters
Chart Options command (Graph) 197, 198
chart sheets, creating graphs on 151
Chart Type button 194
Chart Wizard 148
charts . See graphs
checking spelling 58
adding words to dictionary 61
automatically 58
changing all occurrences of misspelling 61
creating custom dictionaries 63
of entire documents 59
ignoring misspellings 61
of single words 59
smart checking 59
spelling alerts 58
in worksheets 101
without checking grammar 60
writing style, changing 60
clearing
Office Clipboard 32
worksheet cells 110
worksheet formatting 146
Click and Type 32
clicking 2
double-clicking 2
right-clicking 2
shift-clicking 6
clip art 182 “87
Clipboard. See Office Clipboard
closing
databases 218
Document Map 49
documents 21, 33
files 21
floating toolbars 151
Print Preview 27
subdatasheets 257
Word 33
Collapse All button 173
Collapse button 174
Collapse button (Outlining toolbar) 50
collapsing
outlines 48, 50
worksheet outlines 144
column graphs, creating 149
Column Width command, Best Fit button 223
Column Width command (Graph) 194
columns
applying 76
formatting 75
selecting 237
unfreezing 238
Columns button (Standard toolbar) 76
columns, table
deleting 92
inserting 95
moving 92
resizing 194
selecting 93, 94
totaling values in 93
width, changing 90
columns, worksheet 99
copying, with original widths 135
default width, changing 115
deleting 112
filling, with AutoFill 140
inserting 111
resizing 114
selecting 110
selecting all cells in 106
width, adjusting 114
combination graphs 155, 195
combining
documents 71
presentations. See merging
commands
choosing from menus 8
choosing from shortcut menus 12
redoing. See redoing
toggle. See toggle commands
undoing. See undoing
comments
attaching to worksheet
cells 110
displaying, in worksheets 110
editing, in worksheets 110
completing
tasks 335
worksheet entries 100, 101
composing e-mail messages 284
conditional formatting in worksheets 128
consolidating data in Microsoft Excel. See data consolidation in Microsoft Excel
contacts (Outlook)
activities, tracking 307
adding, from other components 297
adding new 297
adding to meetings 325
address cards 296, 299
addresses, entering 298
anniversaries, entering 301
assigning to categories 299, 304
birthdays, entering 301
creating 296, 297
custom forms for 306
deleting 302
deleting custom forms 306
e-mail messages to 306
editing 300
entering details about 301
error checking 299
list of 280
managing 302
organizing 302
Phone List view, displaying in 305
phone numbers, entering 298
printing list of 300
sorting 306
switching views 304
tracking 307
controls, form 246
handles 247
input order, setting 248
moving 247
converting
appointments, into recurring appointments 316
documents, into Web pages 361
fields, to normal text 68
paragraphs, into bulleted lists 77
recurring appointments to regular appointments 322
tables, into data access pages 275
text, into lists 79
Copy button (Standard toolbar) 70
copying. See also cutting and pasting
between applications 353
between documents 70
custom lists, in worksheets 141
to different document 23
entries. See copying, worksheet entries formatting 74.
See also Format Painter formulas, with AutoFill 140
records, between tables 243
selected text 46
styles, to new documents 88
tables 268
tables, structure of 242
tables, to create new tables 268
text 22, 174
text, in slide view 174
text, with drag-and-drop 44
worksheets 136
worksheet columns, with original widths 135
worksheet entries 107, 109
worksheet entries, between workbooks 135
worksheet entries, between worksheets 109
worksheet entries, by dragging 109
worksheet entries, into range of cells 142
in worksheets, finalizing 135
copying formatting 74
correcting
mistakes 32
mistakes in worksheets 101
spelling. See checking spelling
correcting text automatically. See AutoCorrect
courtesy copies 285
criteria, specifying in queries 261
Crop button 187
cropping graphics 186 “87
currency, formatting worksheet cells as 114, 125
cursor 5. See also insertion point
custom forms
editing 306
for Outlook contacts 306
custom lists
defining 141
in worksheets, copying 141
customizing
animation effects 204
appointment time slots 313
dictionaries 63
forms 246
graph types 154
graphs 197
Office shortcut bar 348
Outlook bar 283
presentations 179
reports 274
screen display 9
styles 85
templates 66
toolbars 11
toolbars, for Office shortcut bar 349
Cut button (Standard toolbar) 22
cutting worksheet entries 123
cutting and pasting 22, 23. See also copying
between applications 353
pasting 70
ranges 135
reformatting when 23
smart cut and paste, turning on/off 45
table structure 242



Online Traning Solutions - Quick Course in Microsoft Office XP
Online Traning Solutions - Quick Course in Microsoft Office XP
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 116

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net