I

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