i (information) icons, 35, 71, 74
icon sets in conditional formatting, 285
icons
conditional formatting, 285
displaying objects as, 368
linked or embedded data, 881–882, 886
IF function
array formula example, 472
Conditional Sum Wizard, 480–483
logical values and, 492
nested IFs, 509
overview, 508, 966
If statements, 850
If ... End If statements, 854
IFERROR function, 966
ignoring
cell references, 452
error flags, 242, 582
IIS (Internet Information Services), 803
IMABS function, 966
images. See graphics
IMAGINARY function, 966
IMARGUMENT function, 966
IMCONJUGATE function, 966
IMCOS function, 966
IMDIV function, 966
IMEXP function, 966
MEN function, 966
IMEOG2 function, 967
IMEOG10 function, 966
Immediate window, 866
implicit intersection, 452, 700–701, 702–703
importing. See also embedding; linking objects
Access tables, 749–750
custom lists, 219
data from external sources. See external data
data from Internet Explorer, 785
data from Web queries, 779–785
dBase files, 754
files, 68–69, 71–72
mail merge data into Word, 901–904
pictures, 365–366
Query data, 763–764, 778–779
text files, 750–755
worksheet design for, 121–122
XML files, 755–759
IMPOWER function, 967
IMPRODUCT function, 967
IMREAL function, 967
IMSIN function, 967
IMSQRT function, 967
IMSUB function, 967
IMSUM function, 967
in-place editing, 883, 886
increasing
decimals, 301
indents, 317
indents
code, 848
increasing, 317
index calculations in PivotTables, 733
INDEX function
lookup formulas, 483–485
multiple forms for, 493
overview, 517–519, 967
index values in collections, 838
INDIRECT function, 519, 968
INFO function, 968
information functions, 510–512
Information Rights Management (IRM), 19, 803–806
inner-field subtotaling, 727
input cells, 584
input ranges in data tables, 583
InputBox statement, 851
Insert Function dialog box, 487, 488
Insert menu commands and options, 194, 196, 913–914
Insert tab commands and options, 912, 913, 914, 919, 923
inserting
calculated fields and items, 735–738
cells, 193–194, 197–198, 203–204
charts in Word, 899–901
columns, 182, 194–196
diagrams. See SmartArt feature
embedded or linked objects, 886–888
expanding cell ranges for inserted material, 498
functions, 440, 492–495, 856–857
functions into Visual Basic Editor, 856–857
graphics, 362–368
hyperlinks, 874–879
keyboard shortcuts, 182, 941
names into formulas, 449–450
objects, 366–368
organization charts. See SmartArt feature
by pasting, 193–194
PivotTables, 716
rows, 182, 194–196, 272
rows or columns with shapes, 390
table rows or columns, 272, 667, 671–672
worksheets, 147–148
insertion point, 136
installed templates, 47
installing
add-ins, 479
Analysis Toolpak add-in, 567–568
Euro Currency Tools add-in, 549
IRM, 803
Solver add-in, 601–602
instant messaging, 812
INT function, 502, 968
integers
displayed and stored values, 467
rounding to, 502
Solver add-in, 605–606
INTERCEPT function, 968
interest rates
in data tables, 583
fully invested securities, 546
guess argument, 536
INTRATE function, 546
IPMT function, 538
modified internal rate of return, 541
multiple input variables, 586–587
securities, 545
internal rates of return, 540–541
International Standardization Organization, 550
Internet connections, disabling, 75
Internet Explorer
History bar, 876
importing from, 785
most recently used list (MRU), 875–876
opening SharePoint Services sites, 807
trusted sites, 816
Internet Information Services (IIS), 803
Internet sites. See Web sites
intersection
chart axes, 644–645, 647–648
current row and, 702–703
implicit, 700–701
intersection operators, 453, 458
intranets, 779–785, 815
INTRATE function, 546, 968
inverting chart axes, 645
investments, 535–541, 544
invitations to workspaces, 817
IPMT function, 538, 968
IQY files (Web queries), 782
IRM (Information Rights Management), 19, 803–806
IRM Viewer, 803
IRR function, 540–541, 968
Is Between relationship, 762
IS functions, 511, 969
Is Not Between relationship, 762
Is Not One Of relationship, 762
Is One Of relationship, 762
ISBLANK function, 511, 969
ISERR function, 511, 969
ISERROR function, 969
ISEVEN function, 511, 969
ISLOGICAL function, 511, 969
ISNA function, 511, 969
ISNONTEXT function, 511, 969
ISNUMBER function, 511, 969
ISO (International Standardization Organization), 550
ISODD function, 511, 969
ISPMT function, 969
ISREF function, 511, 969
issue dates of securities, 544, 547
ISTEXT function, 511, 969
italic formatting, 940
iterative calculations
displaying, in Solver, 609
formulas and, 466
Goal Seek command, 600
limiting, in Solver, 608, 611
RATE function, 540