Datasheet
387387
Index
text box, 301
window, 239
Size button (Page Setup group), 182
Skip Blanks option (Paste Special dialog
box), 167
SkyDrive le storage, 360–361
slicer, 275–276
SmartArt, 310, 312–314
Social Security Number number format,
121
Sort Ascending command, 19
Sort Descending command, 19
sorting
ascending sort order, 330
data list record, 329–332
descending sort order, 330
down, 330
pivot table, 275–276
sorting key, 330
up, 330
spaced series, AutoFill feature, 75
sparkline, 298–299
Speak Cells button, 172–173
special character, 78
Special number format, 121
spell checking, 170–171
Spelling command (Customize Quick
Access Toolbar), 19
spillover text, 54–55
split bar, 205, 232–233
splitting
horizontal split bar, 206
tab split, 206, 232
window, 204–206
Standard toolbar, 39–42
Start Searching button (Research task
pane), 223
starting Excel
from desktop, 30–31
as permanent part of Windows Start
menu, 29–30
from Quick Launch toolbar, 31
from Start menu, 28–29
from Windows 7, 369
from Windows Vista, 369
from Windows XP Start menu, 29
Status bar
AutoCalculate indicator, 27
basic description of, 13
Layout selector, 28
mode indicator, 27
Num Lock indicator, 28
zoom slider, 28, 202
StdDev function, 279
StdDevp function, 279
Step button (Goal Seek dialog box), 261
sticky note, 209–210
Stop button (Goal Seek dialog box), 261
Stop Recording button, 354
strikethrough, 126
style. See also cell style
borderline, 135–136
font, 126
picture, 307
pivot table, 271–272
SmartArt, 311
subscript, 126
subtotal, 271
Subtract option (Paste Special dialog
box), 166
subtraction (-) operator, 62
SUM function, 83–85, 278
summary report, 265–266, 278–279
summary worksheet, 248–251
superscript, 126
symbol, 78
synchronous scrolling, 244
• T •
tab
Ribbon interface, 15
worksheet tab color, 236
Tab scrolling button, 231
tab split, 206, 232
table. See also data table; pivot table
Access database, 340–342
cell selection in, 100–102
Format As Table feature, 105, 366
organized structure of, 50
scenario, 263–266
Table gallery
cell range address, 105
opening, 105
25_489536-bindex.indd 38725_489536-bindex.indd 387 3/23/10 7:56 PM3/23/10 7:56 PM