Page 366 - Excel Workbook for Dummies
P. 366
43_798452 bindex.qxp 3/13/06 7:42 PM Page 349
Index 349
Project Explorer Window, 295 Rathbone, Andy
Prompt (InputBox), 297 Microsoft Windows ME Millennium Edition
PROPER function, 164–167 For Dummies, 325
Properties dialog box, 49–50, 304 Windows 98 For Dummies, 325
Protect Sheet dialog box, 224–226 Windows 2000 Professional For Dummies, 325
Protect Workbook dialog box, 228–230 Read-Only workbooks, 53
protecting recalculation mode
entire workbook, 228–230 changing the, 86–87
a worksheet, 224–226 saving changes in the, 87
protection Record Macro dialog box, 286–287, 288–289
enabling/disabling workbook, 229 records
format in a worksheet, 224 filtering in a data list, 214–216
Protection tab on the Format Cells dialog box, 28 sorting in a data list, 208–209
Publish As Web Page dialog box, 265–266, 267, sorting on more than three keys, 209
268–269 subtotaling in a data list, 211–212
PV (present value) redo button, 34
building formulas with, 117–118 #REF! error value, 73
as a financial function, 115 reference
as an investment function, 116 functions, 141
operators, 74–75
relative cell addresses, 89
• Q • relative cell references
copying formulas with, 90–91
query recording a macro using, 288–290
saving a, 219 REMEMBER icon, 6
Web, 270 renaming
Query Wizard, 218–219 a module in the Visual Basic Editor, 295
querying sheets, 14
the database, 213 Repairing workbooks, 53
an external data table, 216–220 Replace All button, 68
question mark (?) report
used in AutoFilter, 214 adding print titles to a, 41–42
used with Find and Replace, 67 creating custom headers/footers for a, 39–41
Quick Launch toolbar modifying print settings of a, 42–44
adding Excel to the, 10 paging with Page Break Preview on a, 38–39
Microsoft Excel icon on the, 9 print previewing a, 37–38
quotation marks (double) used in logical printing a chart in a, 46
functions, 150 resizing
columns and rows, 23–26
graphic objects, 187–189
• R • a text box, 65
Reviewing toolbar, 64–66
R1C1 Reference Style, 90–91 ROUND function
range name building formulas with the, 125–126
creating in formulas, 96–99 as a rounding function, 125
as a destination for a hyperlink, 273 ROUNDDOWN function
using a, 311 building formulas with the, 125–126
range operator (:), 74 as a rounding function, 125
RATE function rounding
building formulas with, 117–118 functions versus controlling decimal places, 125
as a financial function, 115 off values, 125–126
as an investment function, 116
