Page 362 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 345
Index 345
Group Edit mode, 68 IF function
group editing, 68–69 building formulas with nested, 155–156
grouping graphic objects, 187–189 building formulas that perform alternate
calculations with the, 154–155
building formulas that select alternate values
• H • with the, 151–153
suppressing error values with the, 156–157
handmade formulas and built-in functions, 80 Import Data dialog box, 271
hardware requirements for this book, 2 importing
Harvey, Greg graphics files, 192–194
contact information for, 278, 280–281 images from graphics files into a spreadsheet,
Excel All-In-One Desk Reference For Dummies, 6 193–194
Excel For Dummies, 6 Web data into Excel with a Web query, 271–272
Header dialog box indent buttons, 26
for creating custom headers/footers, 40–41 ink text entry, 16
sections of the, 39–40 InputBox function
headers/footers arguments of, 297–298
adding custom, 39–41 using to add interactivity to macros, 297–299
inserting codes in, 40–41 Insert Calculated Field dialog box, 254
Helpfile optional argument (InputBox), 297 Insert Cells command, 60
hiding columns and rows, 34–35 Insert Function dialog box, 79
HINT icon, 6 Insert Hyperlink dialog box, 274, 279
HLOOKUP function (horizontal lookup). See also Insert Picture dialog box, 192, 276, 277
horizontal lookup Insert Worksheet command, 14
arguments of, 142 inserting
overview, 141–142 callouts, 195
Home cell, 12 clip art, 189–191
horizontal lookup. See also HLOOKUP function codes in a custom header/footer, 40
(horizontal lookup) data and cells, 60–61
building formulas that perform, 143–144 a scanned image/digital photo, 193
performing a, 142–144 WordArt, 198–200
horizontal scroll bar and the Shift key, 12–13 Insertion point (F2), 57
hyperlinks installing CD files, 325–327
adding to other documents, 275–277, 276–277 interactive chart. See chart
adding to other sheets in a workbook, 274–275 interactive data list. See data list
adding to Web pages and e-mail addresses, interactive data table. See data table
277–278 interactive pivot table. See pivot table
assigning to custom menus and toolbars, interactive toolbar restoration, 266
279–281 interactive Web pages. See Web page
creating, 273–278 interest rate (Rate), 115
deleting, 279 internet query (.iqy) file extension, 272
destinations for, 273–274 internet requirement for this book, 2
editing, 279 investment functions, 116–121
overview, 273 .iqy (internet query) file extension, 272
hypertext, 279 IRR function (Internal Rate of Return)
building formulas with the, 118–121
overview, 118
• I • ISERR function, 157
ISERROR function, 157–159, 313
I-beam cursor, 57 italic button, 26
icons
listed, 5–6
Microsoft Excel, 9