Page 364 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 347
Index 347
between sheets in workbook, 14 • O •
a text box, 65
multi-sheet layout, 310 ON THE CD icon, 6
multiplication operator (*) one-dimensional arrays, 99
in formulas, 74, 76 one-variable data table, 233–235
precedence of, 82 Open dialog box, 11, 51
MZ Tools VBA Add–Ins (MZ Tools Software), 326. opening
See also installing CD files Excel, 9–10
a new workbook, 10–11
operands, 74
• N • operators
comparative, 206
#N/A error value, 74
in Custom AutoFilter, 214
NA function, 158
precedence of in formulas, 82
Name Box, 12
type of used in formulas, 74–75
#NAME? error value, 74, 77, 162
optional range_lookup argument, 142
negation/subtraction operator(–)
Options dialog box
precedence of, 82
circular references and the, 105
used in formulas, 74
Comment & Indicator option button on the, 65
nested IF function and formula building, 155–156
controlling when formulas are calculated with
NETWORKDAYS function, 111
the, 86
New button on Standard toolbar, 10
creating custom lists with the, 311
New dialog box, 10
displaying formulas with the, 47
New Web Query dialog box, 270–272
moving to a different sheet using the, 14
New Workbook task pane, 10
OR function, 149
not equal to operator (<>)
orientation
precedence of, 82
of column headings, 30–31
used on data forms, 206
default print setting of, 42
used in formulas, 74
outlining, 314
NOT function, 149
overriding formulas with the $ sign, 19
note attachment to a spreadsheet, 64–66
NOW function, 79, 112–113
NPER function (number of periods) • P •
building formulas with the, 117–118
as a financial function, 115 Page Break Preview dialog box, 38–39
as an investment function, 116 page breaks adjustment, 38–39
NPV function (net present value) Page Down
assumptions of the, 118 entering data with the, 16
building formulas with the, 118–121 scrolling through a worksheet with the, 12
overview, 116 Page Settings dialog box, 42
#NULL! error value, 73 Page Setup dialog box
#NUM! error value, 74 centering printing with the, 39
number format Chart tab on the, 46
applying the, 28–30 Fit To Scaling/Adjust To options on, 43
default, 28 header/footer tab on the, 40–41
overriding the, 16 print preview and the, 38
Number tab print titles and the, 41–42
on the Format Cells dialog box, 27–28 Page Up
formatting cells with the, 29–30 entering data with the, 16
importance of the, 28 scrolling through worksheet with the, 12
numeric cell entries, 15–16