Page 788 - Excel 2013 All-in-One For Dummies

770 Excel 2013 All-In-One For Dummies
Skip Blanks option, Paste Special dialog box, 214
SkyDrive. See also sharing workbooks
editing workbooks in Excel web app, 496–499
general discussion, 117 opening workbooks saved
in, 184
sharing workbooks
on, 490–493 SkyDrive button, Open
dialog box, 188
slicers, 641, 683–685
SLN function, 383
SmartArt graphics, 553, 554,
568–571
Snap to Grid feature, 547–548 social networks, posting
SkyDrive workbook
links on, 493 Solver add-in
defining problems, 660–662 general discussion, 659–660 options for, 663–665 overview, 69, 70, 646 reports, 665–666
saving and loading model problems, 665
solving problems, 662–663 Solver Parameters dialog
box, 661–662 Solver Results dialog box, 663, 666
Sort & Filter Data button, 588
Sort dialog box, 589, 597 Sort Options dialog box,
590–592, 594, 596 sorting
ascending sort order, 588 on cell icons, 596–597 columns, 592–596 descending sort order, 588
enabling in protected sheets, 443
on fill color, 596–597
on font, 596–597
with Microsoft Query, 638 overview, 588
pivot tables, 686
records on multiple fields,
589–592
records on single fields,
588–589
source area, 263, 267 source worksheets, 263 sources of data for charts,
editing, 526–528 space operator, 306 Spanish mode, 52, 224 sparklines, 542–543 Special button, Go To
dialog box, 352 specialized statistical
functions, 407 Spell Check feature
AutoCorrect feature, 97–98 custom dictionaries, adding
words to, 224–225 default settings for, 52 overview, 222–223
spelling options, changing,
223–224
text in text boxes, 565
Spelling dialog box, 222 split-keyboard
arrangement, Touch
keyboard, 95 splitting worksheets into
panes, 234–237
SQL Server, importing data
from, 632
SQRT function, 394–395 square roots of numbers,
calculating, 395–396 Stamp Signature Line
option, 470 stamps, digital, 470
Standard toolbar, Visual Basic Editor, 723
Standard Width dialog box, 137
Start Inking command, 483, 486
Start menu, Windows 7 launching Excel from, 37–38 pinning Excel to, 38
Start screen, 14–15, 36–37 Start Up Options, 48 statistical functions
AVERAGE, 400
for counting cells, 401–407 MAX, 400
MIN, 400
overview, 389, 399–400 specialized, 407
Status bar, 16, 33–34
stock charts, inserting, 519 straight-line depreciation,
calculating, 383–385 Structure check box, 452 Style dialog box, 171, 172 styles
applying to outlines, 240–241
of pivot tables, 676–678 subproblems setting, in
Solver add-in, 664 Subtotals feature, 597–599 Subtotals option, Layout
group, Design tab, 677 Subtract option, Paste
Special dialog box, 214 Suggestions list box,
Spelling dialog box, 222 Sum button, 302–303
Sum feature on Quick
Analysis tool, 305
SUM function, 303, 304, 309,
395–396
SUMIF function, 396–398 SUMIFS function, 396–399