padding numbers, 125-126
Page Break between Groups option, Subtotal dialog box, 275
Page Layout tab, Ribbon component, 10-11
Panko, Raymond, 582
Parent property, 673-674
parentheses, 42-44, 583-584
passwords, protecting workbooks with, 32
Paste Function dialog box, 111
Paste List button, 71
Paste Name dialog box, 34, 71-72
Paste Picture Link command, 23
Paste Special dialog box, 114, 542
Paste tool, Clipboard group, 11
Paste Values command, 47-48, 125
pasting
named ranges, 80
names into formulas, 36
path specifications, extracting filenames from, 133
pattern, whether text matches, 697-698
pattern-matched cells, counting, 701
payday loan rates, 307-308
payments
future value of, 302-303
and interest tables, 354-356
loan payments, 305-306
retirement payments, 305-306
smoothing, 331-332
Pearson, Chip, 772
PEARSON function, 741
Pearson Software Consulting web site, 772
Peltier, Jon, 772
Percent Style button, 747
Percentage number format, Options dialog box, 749
PERCENTILE function, 741
PERCENTRANK function, 741
perimeter, 282-283
Period argument, 344
periodic effective rate, 315
periods
early loan payoff, 310-311
years until retirement, 309-310
PERMUT function, 741
phantom link errors, 593-594
PI function, 737
pivot charts, 28, 179, 192, 512
Pivot Table Field List, 492-493, 496, 526
Pivot Table Options dialog box, 493, 495-496
Pivot Table Styles option, 493, 505, 526
pivot tables
calculated field, creating, 514-516
calculated item, inserting, 516-519
creating, 493-498
data appropriate for, 488-491
examples, 486-488, 498-503, 521-524
frequency distribution, 510-512
grouping, 504-510
overview, 29-30, 485-486
producing report with, 524-526
referencing cells within, 519-521
plus sign (+), 33
Pmt argument, 299, 305-306, 311, 331
PMT function, 109, 349-350, 733
POISSON function, 741
polynomial trendlines, 479, 482-483
POWER function, 737
power trendlines, 479-481
Power Utility Pak, 68
PPMT function, 312-313, 733
pre-1900 dates, 148
precedents, identifying, 599-600
Precision as Displayed option, Calculation tab, 745
predicted values, calculating, 477
present value, of annuity with lump sum, 301-302
Presidents' Day, 163
PRICE function, 319-320, 733
PRICEDISC function, 733
PRICEMAT function, 733
principal, 312-314
PROB function, 741
PRODUCT function, 737
profitability ratios, 369
Project window, Visual Basic (VB) editor, 612-616
PROPER function, 98, 125-126, 743
Properties window, Visual Basic (VB) editor, 613
Protect Sheet dialog box, 28-29, 50
Protect Structure and Windows dialog box, 29
protection options, 30-32
Protection tab, 29, 49-50
Pv argument, 299, 310
PV function, 298, 317-318, 733
pyramids, volume of, 284