Part VII: Appendixes
936
l (^) text alignment.xlsx: A workbook that demonstrates different types of horizontal text
alignment.
l (^) theme examples.xlsx: A workbook that contains a table, SmartArt, and a chart to demon-
strate the effect of applying different document themes.
Chapter 10
l (^) cell references.xlsx: A workbook used to demonstrate the effect of using different types of
cell references when copying formulas.
l (^) circular reference.xlsx: A workbook that demonstrates an intentional circular reference.
When you open this workbook, you see a message informing you of the circular reference.
l (^) table formulas.xlsx: A workbook used to demonstrate the use of formulas within a table.
Chapter 11
l character set.xlsm: A workbook that displays the characters available in any font installed
on your system.
l extract names.xlsx: A workbook that contains formulas to extract first, middle, and last
names.
l text formula examples.xlsx: A workbook that contains examples of advanced text
formulas.
l text histogram.xlsx: A workbook that contains two examples of creating a histogram
directly in a range.
Chapter 12
l holidays.xlsx: A workbook that demonstrates how to calculate the date for 10 U.S. holidays.
l (^) jogging log.xlsx: A workbook that tracks time and distanced jogged. Demonstrates the use
of times not associated with a time of day.
l (^) time sheet.xlsm: A workbook that tracks hours worked during a week.
l work days.xlsx: A workbook that demonstrates how to calculate the number of work days
between two dates (excluding weekends and holidays).
l XDATE demo.xlsm: A workbook that contains custom functions that allow you to work with
dates prior to 1900.
Chapter 13
l basic counting.xlsx: A workbook that demonstrates basic counting formulas.
l (^) conditional sum.xlsx: A workbook that demonstrates how to calculate conditional sums,
using single and multiple criteria.
l (^) count unique.xlsx: A workbook that demonstrates how to count unique (nonduplicated)
items in a range.
57_474877-bapp02.indd 93657_474877-bapp02.indd 936 3/29/10 11:47 PM3/29/10 11:47 PM