Datasheet

399
chart layout, 202
chart style, 201
chart type, 200
font, 144
number formats, 146
page setup options, 164–165
copying worksheets, 166
creating
charts, 196–197
formulas, 182–183
decreasing decimals, 148–149
deleting
data and cells, 160–161
worksheets, 167
entering cell data, 134–135
Error Checking feature, 192
filtering data, 172–173
finding and replacing data, 168–169
formatting
chart objects, 204–205
data with styles, 150–151
formulas, 180–181
freezing columns and rows, 157
functions, 186–187
increasing decimals, 147
inserting
comments, 178–179
spreadsheets in Word documents, 99
moving
charts, 199
worksheets, 166
naming
ranges, 158–159
worksheets, 163
Quick Borders feature, 148
resizing
charts, 198
columns and rows, 156
reviewing worksheet changes, 176–177
selecting cells, 136–137
Share Workbook feature, 175
sorting data, 170–171
Sparklines feature, 208–209
text wrapping, 140
Trace Errors feature, 193
tracking worksheet changes, 174–175
viewing data trends, 208–209
F
features
Audio Search (OneNote), 395
AutoComplete (Excel), 135
AutoCorrect (Word), 120–121
AutoFill (Excel), 138–139
AutoFit (Publisher), 365
AutoSum (Excel), 190–191
Error Checking (Excel), 192
Quick Borders (Excel), 148
Quick Columns (Word), 94
Quick Parts (Word), 64–65
Quick Styles (Word), 86–87
Quick Table (Word), 97
Share Workbook (Excel), 175
SmartArt (Office), 44–45
Sparklines (Excel), 208–209
Trace Errors (Excel), 193
Zoom (Publisher), 350–351
Field Properties Design view (Access), 275
finding and replacing, 168–169
formatting with styles, 150–151
indenting, 143
orientation of, 143
selecting, 22–23
sorting, 170–171
viewing trends with Sparklines, 208–209
data labels, 205
databases (Access). See also Access
applying themes, 285
basics, 266–267
creating
blank, 270–271
with templates, 268–269
opening, 271
planning, 267
decimals, increasing/decreasing, 147
diagrams, resizing and moving, 45
dictionary (Word), 123
documents (Word)
comparing, 128–129
reviewing changes, 126–127
scanning content, 116–117
tracking changes, 126–127
window controls, 7
E
effects
artistic, 41
picture, 38
text, 360
e-mails
carbon-copying, 329
composing, 328–329
creating rules, 342–343
forwarding, 333
reading incoming, 331
removing
from junk e-mail folder, 341
overview, 335
rules, 343
replying to, 332
screening junk, 340–341
sending, 319, 328–329
endnotes (Word), 102–103
Error Checking feature (Excel), 192
events, scheduling, 316–317
Excel
adding
axis titles, 203
columns, 154
gridlines, 206
rows, 155
watch windows, 194–195
worksheets, 162
applying
absolute cell reference, 184–185
conditional formatting, 152–153
functions, 188–189
relative cell references, 184–185
auditing worksheets for errors, 192–193
AutoComplete feature, 135
AutoFill feature, 138–139
AutoSum feature, 190–191
centering data across columns, 141
changing
cell alignment, 142–143
chart data, 207
34_571941-bindex.indd 39934_571941-bindex.indd 399 4/9/10 7:47 PM4/9/10 7:47 PM