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

760 Excel 2013 All-In-One For Dummies
investments future value of,
calculating, 378–379 net present value,
calculating, 377–378 present value of,
calculating, 376–377 inviting others to view
workbooks on
SkyDrive, 490–492 iPad, SkyDrive app for
Apple, 499
IRAs (Individual Retirement
Accounts), 379
IS functions, 423–424 ISBLANK function, 423–424 ISERR function, 424 ISERROR function, 345, 424 ISEVEN function, 424 ISLOGICAL function, 424 ISNA function, 424 ISNONTEXT function,
403–404, 424 ISNUMBER function, 424 ISODD function, 424 ISREF function, 424 ISTEXT function,
403–404, 424
italic formatting, 144, 563 iterations, in Solver
add-in, 664
iterative calculations, 49,
336, 338
Justify alignmJent option, 158, 159
K
key fields, 623 keyboards
AutoSelect feature, 131–132 cell selection with, 129–130
data entry with, 93–94 selecting Ribbon
commands with, 24–25 keystroke shortcuts
for moving cell cursor, 29–30
for moving within selections, 99
for navigating Worksheet area, 29–31
L
labels. See also range names AutoComplete feature,
96–97
AutoCorrect feature, 97–98 on columns, 28 consolidating worksheets
by, 267
Flash Fill feature, 109–111 general discussion, 86–87 overview, 85
Lagrange multiplier, 666 landscape orientation, 281 languages, dictionary,
52, 224
launching Excel, 36–39, 48 layers, moving graphics to
new, 548–550 Layout & Format tab,
PivotTable Options
dialog box, 692 Layout group, Design
tab, 676, 677 layout of pivot tables,
676–678
Layout selector, Status
bar, 34
left alignment, 157, 286 Left arrow, Touch
keyboard, 95 legend, 517
Limits reports, 666 line charts, 520, 542
LinkedIn, posting SkyDrive workbook links on, 493
linking
consolidated data, 267–268 formulas, 333–334 overview, 500
to PowerPoint, 506–507
to Word, 501–504, 505–506
List option, Data Validation dialog box, 112
lists, custom, 106–109. See also AutoFill feature; Outline feature
Live Preview feature enabling, 46
formatting, previewing, 126 overview, 13
Quick Analysis tool table option, viewing
with, 143
table styles, viewing with, 142
Load/Save Model dialog box, 665
loan payments, 379–382 local file location
changing, 120–121 opening workbooks saved
in, 184
setting default, 54
local pictures, inserting, 557–558
Locked protection format, 440, 441–442
Logarithmic Scale option for chart axes, 539
logical AND conditions, setting up, 615–617, 637
logical functions, 341–342 logical OR conditions,
setting up, 615–617, 637 Look In list box, Open
dialog box, 187–188 lookup columns, 623 LOOKUP function, 417