Appendix B: What’s on the CD-ROM
937
l counting text in a range.xlsx: A workbook that demonstrates various ways to count text
in a range.
l cumulative sum.xlsx: A workbook that demonstrates how to display a cumulative sum.l (^) frequency distribution.xlsx: A workbook that demonstrates four methods to create a
frequency distribution.
l (^) multiple criteria counting.xlsx: A workbook that demonstrates counting formulas that
use multiple criteria.
Chapter 14
l (^) basic lookup examples.xlsx: A workbook that demonstrates a variety of common lookup
techniques.
l (^) specialized lookup examples.xlsx: A workbook that demonstrates a variety of special-
ized lookup techniques.
Chapter 15
l (^) annuity calculator.xlsx: A workbook that calculates interest on annuities.
l credit card payments.xlsx: A workbook that contains formulas to calculate credit card
payments.
l depreciation calculations.xlsx: A workbook that demonstrates methods to calculate
depreciation of an asset.
l investment calculations.xlsx: A workbook that demonstrates formulas to calculate
interest on investments.
l irregular payments.xlsx: A workbook that calculates a loan with irregular payments.
l (^) loan amortization schedule.xlsx: A workbook that calculates a loan amortization schedule.
l loan data tables.xlsx: A workbook that demonstrates how to use 1-way and 2-way data
tables to calculate loan information.
l loan payment.xlsx: A workbook that contains formulas to calculate loan payments.
Chapter 16
l (^) array examples.xlsx: A workbook that contains examples of array formulas.
Chapter 17
l array formula calendar.xlsx: A workbook that displays a calendar for any month by
using a complex array formula.
l multi-cell array formulas.xlsx: A workbook that demonstrates a variety of multicell
array formulas.
l single-cell array formulas.xlsx: A workbook that demonstrates a variety of single-cell
array formulas.
l yearly calendar.xlsx: A workbook that displays monthly calendars for any year by using a
complex array formula.
57_474877-bapp02.indd 93757_474877-bapp02.indd 937 3/29/10 11:47 PM3/29/10 11:47 PM