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

Index 759
Ignore Relative/Absolute check box, Apply Names dialog box, 331
ignoring errors, 355 IM (Instant Message),
sharing workbooks
with, 494–495
images. See also graphics,
default settings for, 55 in headers and
footers, 289
Import Data dialog box,
624–625, 627–628,
631–632, 639–640 importing, with PowerPivot
add-in, 698. See also
external data queries Inconsistent Calculated Column Formula in
Tables check box, 355 Increase Decimal button, 147 Increase Font Size
button, 144
Increase Indent button, 146 increment settings, for
AutoFill feature, 105–106 indents, for text boxes, 563 Indicate Errors Using This
Color drop-down
button, 355
indirect dependents, 347 INDIRECT function, 417 Individual Retirement
Accounts (IRAs), 379 Info screen
general discussion, 18–19 setting passwords on,
436–437
workbook properties,
checking before
distribution, 463–465 information functions
CELL, 420–422 IS, 423–424
overview, 420
TYPE, 423
Ink group, Ribbon, 23 Input dialog box, for
macros, 729–733 InputBox function, 729–733 inputting numbers, 88–89 Inquire add-in, 71
Insert Calculated Field
dialog box, 690–691 Insert Chart dialog box,
519, 520, 542 Insert dialog box, 196,
197–198, 251 Insert Function dialog
box, 309–311 Insert Hyperlink dialog
box, 456–459
Insert Pictures dialog box,
250, 554–557, 559 Insert Shapes group, 529 Insert Slicer option, 641 Insert Slicers dialog box,
683–684
Insert tab, Ribbon, 23 Insert Timelines dialog
box, 685 inserting
cell contents, 191 cells, 196–198 charts from Ribbon,
519–520
charts with Quick
Analysis tool, 521–522 clip art, 554–556 columns and rows, 232,
233–234
copied cells, 212
local pictures, 557–558 Office apps into
worksheet, 67–68 page breaks, 294
in protected worksheets, enabling, 443
recommended charts, 518–519
screenshots, 571–572 slicers, 641, 683–685 SmartArt graphics,
568–571
UDFs, 738–740
web images, 556–557 WordArt, 567–568
Inspect Document option, 464
Inspect Workbook button, Info screen, 18
installations of Office 2013, viewing information on, 21
Instant Message (IM), sharing workbooks with, 494–495
INT function, 392–393 integer optimality, 664 IntelliMouse technology,
56, 200
Internet. See also SkyDrive
Bing search engine, downloading images with, 556–557
downloading graphics from, 556–557
downloading templates, 77–79
Excel web app, editing in, 492, 496–499
web page queries, 623, 626–628
Internet Fax, sending workbooks as, 494
intersection operator, 306, 333
INTRATE function, 387 invalid data, marking,
226–228