Page 363 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 346
346 Excel Workbook For Dummies
• K • • M •

key combinations Macro dialog box, 287–288
Alt, 317, 319, 323 macro recorder, 285–286
for array formulas, 101 macros
Ctrl, 78, 317, 319, 321, 323. See also Ctrl key adding an input dialog box to, 297–299
data entry, 317 assigning to custom menus and toolbars,
editing, 321 290–291
formatting, 319 creating, 285–290
miscellaneous, 323 editing a recorded in the visual Basic Editor,
using to enter data, 16 295–297
recording a new, 286–288
recording using relative cell references, 288–290
• L • magnification. See zoom
margins in print preview window, 38
landscape. See orientation math functions, 125–134
launching Excel, 9–10 Max summary function, 253
legend, 173 MAXIMUM function
less than or equal to operator (<=) building formulas with the, 136–137
precedence of, 82 subtotaling in data lists with the, 211–212
used on data forms, 206 MEDIAN function, 136
used in formulas, 74 memory and array formulas, 313–314
less than operator (<) menu. See also custom menu
precedence of, 82 assigning hyperlinks to a, 279–281
used on data forms, 206 assigning macros to a, 290–291
used in formulas, 74 commands, 1
license agreement for CD, 326 Menu bar, 20
life as a depreciation calculation, 121 Microsoft Office Templates Home Page, 309
links. See hyperlinks Microsoft Office Web Components installation,
list 263
filtering a, 213–216 Microsoft Templates
sort order, 207 file, 5
sorting, 207–211 folder, 10
subtotaling a, 211–212 Microsoft Windows ME Millennium Edition
loan table with mixed cell references, 93–96 For Dummies (Rathbone), 325
logical functions Microsoft Windows requirement for this book, 2
overview, 149 Min summary function, 253
working with, 149–150 Mind Over Media Web site, 278, 280–281
Lookup functions, 141 MINIMUM function
lookup table building formulas with the, 136–137
horizontal lookup on, 142–144 using when subtotaling in data lists, 211–212
searching, 141–146 minus sign (-)
vertical lookup on, 144–146 precedence of, 82
Lookup Wizard used in formulas, 74
reasons for using the, 146–148 mixed cell references
using to build formulas that perform two–way copying formulas with, 92–96
lookups in a table, 147–148 creating a loan table with, 93–96
lookups (two-way), 146–148 module renaming in the Visual Basic Editor, 295
lookup_value argument, 142, 151 mouse scrolling through a worksheet, 13
LOWER function, 164–167 moving
data and cells, 61–64
between ranges of data, 13