Page 361 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 344
344 Excel Workbook For Dummies
formulas (financial/investment) NA, 158
building with the FV, PV, PMT, RATE, and NPER PRODUCT, 211–212
functions, 117–118 rounding off values with a, 125–126
building with the IRR and NPV functions, statistical, 139–140
118–121 SUM, 128, 211–212
building with the SLN, SYD, DB, and DDB SUMIF, 131–133
depreciation functions, 121–123 summary, 252–253
formulas (logical), building by using the IF func- SUMPRODUCT, 128–129
tion that will select alternate values, 151–153 TABLE, 235, 237
formulas (math) UPPER/LOWER/PROPER, 164–167
ABS function and, 127–128 use of parentheses with a, 79
building with the PRODUCT, POWER, and SQRT user-defined, 300–305
functions, 127–128 VLOOKUP, 141–142
building with the ROUND, ROUNDUP, and Function Arguments dialog box, 79, 94, 95, 132
ROUNDDOWN functions, 125–126 function names and case sensitivity, 78–79
building with the SUMPRODUCT, SUMSQ, and Future value. See FV (future value)
SUMX2PY2 functions, 129–131 FV (future value)
formulas (statistical) building formulas with, 117–118
building with the COUNT, COUNTBLANK, as a financial function, 115–116
COUNTA, and COUNTIF functions, 138–139 as an investment function, 116
building with the MAX and MIN functions, 137
building using the AVERAGE and MEDIAN func-
tions, 136 • G •
formulas (trig). See formulas (math)
fraction number format, 28 GNU software, 326. See also installing CD files
Freeware programs, 326. See also installing CD Go To feature for printing, 44
files Goal Seek dialog box, 240–241
Freeze Panes, 54–55 goal seeking, 240–241
freezing column/row headings, 312 Gookin, Dan (PCs For Dummies), 325
function graphic objects
AVERAGE, 135–136, 211–212 drawing/adding with Drawing toolbar, 194–196
CONCATENATE, 164–167 grouping/ungrouping, 186–187
COUNT, 211–212 moving/nudging, 186
COUNTIF, 138–139 overview, 185–189
counting, 137–139 resizing and grouping, 187–189
custom, 302–303, 303–305 selecting, 185
date and time, 107–109 graphics files
depreciation, 121–123 importing, 192–194
financial, 115–116 importing images from into a spreadsheet,
finding product, power, and square roots with a, 193–194
127–129 manipulating, 192
HLOOKUP, 141–142 greater than or equal to operator (>=)
InputBox, 297–299 precedence of, 82
investment, 116–121 used on data forms, 206
ISERR, 157 used in formulas, 74
ISERROR, 157–159 greater than operator (>)
logical (overview), 149–150 precedence of, 82
lookup and reference, 141 used on data forms, 206
math, 125–134 used in formulas, 74
MAX/MIN, 136–137 gridlines
MAXIMUM, 211–212 definition of, 173
MEDIAN, 136 turning on, 43
MINIMUM, 211–212