Page 365 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 348
348 Excel Workbook For Dummies
paging a report with Page Break Preview, 38–39 Planning Templates Free Sampler (Planning
parameters (Solver), 242 Templates, Inc.), 327. See also installing CD
password files
assigning for opening and editing a workbook, plot area, 173
222–223 plus sign operator (+)
removing from a file, 223 precedence of, 82
Save Options dialog box and, 222 used in formulas, 74
password–protecting the workbook, 221–223 PMT function (payment)
Paste Name dialog box, 132, 311 building formulas with the, 117–118
Paste Special dialog box, 62 computing monthly payments with the, 93–96
Patterns tab on the Format Cells dialog box, 28 as a financial function, 115
payment periods (Nper), 115 as an investment function, 116
payment (Pmt), 115 portrait. See orientation
PCs For Dummies (Gookin), 325 pound sign (###) displayed in cells, 24
percent POWER function
button, 26 building formulas with the, 127–128
as a number format, 28 as a math function, 127
percent operator (%) Power Utility Pak (JWalk and Associates), 327. See
precedence of, 82 also installing CD files
used in formulas, 74 practice files
period for depreciation calculation, 121 on the CD, 327–328
Personal Macro Workbook viewing, 295 copying from the CD, 327–328
Picture toolbar, 193 precedence of operators, 82
pivot chart Present value. See PV (present value)
changing the type of, 255 primary sort key, 207–208
creating a, 254–257 print area, 37, 44
overview, 254–255 Print dialog box
pivot table opening, 38, 311
adding a calculated field to a, 252–254 printing a cell range from the, 44–45
areas of a, 248–249 printing a workbook from the, 45–46
changing the default summary functions in a, print preview, 37–38
252 Print Preview toolbar Setup button, 38
creating a new, 247–250 Print Preview window, 38
creating a Web page with an interactive, 267–268 print settings
flexibility of a, 245 default, 42
hiding a calculated field in a, 252–253 modifying, 42–44
modifying a, 250–254 print titles, 41–42
modifying an existing, 245–247 printing
modifying the formatting in a, 250–251 active worksheet, 44
modifying the structure of a, 251–252 chart default, 45
modifying the summary function and adding a a chart in a report, 46
calculated field to a, 253–254 entire workbook, 45–46
overview, 245 multiple worksheet data, 45
removing fields from a, 252 a range of cells, 44–45
versus Subtotals feature, 245 spreadsheet formulas, 46–47
PivotTable Field List dialog box, 246–247, PRODUCT function
249–250, 252–254, 256, 268 building formulas with the, 127–128
PivotTable and PivotChart Wizard, 247, 254–257 as a math function, 127
PivotTable and PivotTable Chart, 249–250 pivot tables and the, 253
PivotTable toolbar subtotaling in data lists with the, 211–212
changing the table summary functions with the, programs
252–254 Analysis ToolPak add-in, 109–111
creating a new pivot table with the, 249–250 on the CD, 326–327
viewing the, 246–247