Page 368 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 351
Index 351
special number format, 28 in the Visual Basic Editor window, 295
Spell-Checking, 66–68 zoom drop-down list on the, 38
spreadsheet. See also worksheet Standard Width dialog box, 24
adding clip art to a, 190–191 Start menu
adding a text box to a, 196–198 adding Excel to the, 10
building formulas with a custom function in, Microsoft Excel icon on the, 9
302–303 starting Excel, 9–10
constructing scenarios for a, 238–240 static Web pages. See Web page
constructing WordArt in a, 198–200 statistical functions on the Analysis ToolPak
creating a one-variable data table in a, 233–235 add-in, 139–140
creating a two-variable data table in a, 236–237 STDDEVP function, 253
deleting/inserting cells in a, 60–61 structure modification in a pivot table, 251–252
finding the source of error values in formulas in Style dialog box, 279
a, 102–104 subtotal
goal seeking in a, 240–241 feature and data lists, 211–212
importing images from graphics files into a, feature versus pivot tables, 245
193–194 the records in a data list, 211–212
modifying column widths in a, 24–25 subtraction/negation operator (–)
modifying row height using AutoFit in a, 25–26 in formulas, 74, 76
moving/copying data and cells in a, 61–64 precedence of, 82
organization of data on different worksheets, SUM function
310 importance of, 128
organizing data on different worksheets in a, 310 overview, 78
printing formulas from a, 46–47 pivot tables and the, 252
saving as a static Web page, 262–263 subtotaling in data lists with the, 211–212
saving in a workbook file, 20–21 versus the AVERAGE function, 135
setting up protection on templates, 224–226 SUMIF function
using a custom function in a, 302–303 problems with the, 133
using Solver to modify multiple input values in using the, 131–133
a, 242–243 summary
viewing in HTML file format, 261 functions, 252–253
Spreadsheet Assistant, 327. See also installing CD information added to workbooks, 49–51
files tab on the Properties dialog box, 50
Spreadsheet Solutions templates, 309 SUMPRODUCT function
SQRT function building formulas with the, 129–131
building formulas with the, 127–128 overview, 128–129
as a math function, 127 SUMSQ function
square brackets, 116 building formulas with the, 129–131
Standard toolbar as a summing function, 129–131
AutoSum button on the, 128 SUMX2MY2 function, 129
displaying the, 27 SUMX2PY2 function
Format painter button on the, 31 building formulas with the, 129–131
New button on the, 10 overview, 129
print preview button on the, 37–38 SUMXMY2 function, 129
printing active worksheet with the, 44 super-cell, 31
saving from the, 25 SYD function (sum-of-years-digits)
Undo button on for editing, 57 building formulas with the, 121–123
using the Save button on the, 20 as a depreciation function, 121
system requirements (CD), 325