Page 348 - Excel Workbook for Dummies

41_798452 appb.qxp 3/13/06 7:33 PM Page 331
Appendix B: Table of Exercises 331

Exercise Name Page Number

Chapter 6: Copying and Correcting Formulas
Exercise 6-1: Copying Formulas in the R1C1 Reference Style 90
Exercise 6-2: Copying a Formula with Absolute Cell References 91
Exercise 6-3: Creating a Loan Table with Mixed Cell References 93

Exercise 6-4: Creating Range Names for Formulas 96
Exercise 6-5: Constructing Array Formulas 100
Exercise 6-6: Finding the Source of Error Values in a Spreadsheet 102
Exercise 6-7: Solving a Circular Reference in a Formula 104

Chapter 7: Creating Date and Time Formulas
Exercise 7-1: Building Formulas that Calculate Elapsed Dates and Times 108
Exercise 7-2: Building Formulas with Common Date Functions 109
Exercise 7-3: Building Formulas with Date Functions in the Analysis ToolPak 111

Exercise 7-4: Building Formulas with Common Time Functions 112
Chapter 8: Financial Formulas and Functions
Exercise 8-1: Building Formulas with the FV, PV, PMT, RATE, and
NPER Functions 117

Exercise 8-2: Building Formulas with the IRR and NPV Functions 118
Exercise 8-3: Building Formulas with the SLN, SYD, DB, and DDB
Depreciation Functions 121

Chapter 9: Using Math Functions
Exercise 9-1: Building Formulas the ROUND, ROUNDUP, and
ROUNDDOWN Functions 125
Exercise 9-2: Building Formulas with the PRODUCT, POWER, and
SQRT Functions 127
Exercise 9-3: Building Formulas with the SUMPRODUCT, SUMSQ, and
SUMX2PY2 Functions 129
Exercise 9-4: Using the SUMIF Function 131
Exercise 9-5: Using the Conditional Sum Wizard 133
Chapter 10: Using Statistical Functions
Exercise 10-1: Building Formulas with the AVERAGE and MEDIAN Functions 136

Exercise 10-2: Building Formulas with the MAX and MIN Functions 137
Exercise 10-3: Building Formulas with the COUNT, COUNTBLANK, COUNTA,
and COUNTIF Functions 138

Chapter 11: Using the Lookup Functions
Exercise 11-1: Building Formulas that Perform Horizontal Lookups in a Table 143
(continued)