Errata

In the third sentence, the reference to Figure 9-12 is incorrect. The correct figure
is in the Gem in the Rough box on page 344.

"See figure 10-13" is misplaced. It shows the screen on which you can import
information, and so should be placed in the first paragraph on this page.

The caption to figure 10-13 refers to selecting from a list of different holidays.
However, the figure does not show this list.
The paragraph and the caption both say to check the holidays you want to enter and
then click OK. In fact, you check the holidays and then click the right arrow

The second sentence says that you can tell what is happening by looking "in the
status area at the bottom left", where you can see which cell is being edited. This
is incorrect. It is the formula bar, at the top left, that shows this information.

The caption is confusing. It says that you should use the Formula bar to enter a cell
location, but in the figure the Formula bar is not shown

The first sentence is very confusing. Perhaps there was originally a sentence before
it that got deleted. Change the box to read something like "Some people do not like
to edit cell contents directly in the cell, but only in the Edit box on the Formula
bar. If you are one of them, choose Excel-->Preferences-->Edit panel, turn off "Edit
directly in cell", and click OK."

The text says that Figure 13-15 shows the error-checking button. But it does not.
Therefore, the last sentence in this paragraph does not make any sense.

Note that the contents of Figure 13-15 are correctly referred to on the next page,
and that there is no reference in the text to Figure 13-14. It thus appears that the
author intended to show the error-checking button in Figure 13-14.

Amazingly, this figure is not referenced anywhere in the text. That is too bad,
because it covers one of the most important, and sometimes frustrating, aspects of
Excel. There should have been a whole section on how to use the Rangefinder,
including the various ways to select cells in a formula, and how to escape from the
Rangefinder when you are done with it. Instead, the Rangefinder is only covered in
this unreferenced figure. In fact, the Rangefinder is not even llisted in the index!
A major, major mistake.

This figure is not referenced in the text. It should be referenced in the first
paragraph on page 487.

The last two sentences discuss how to display R-squared values and assert that the
value of the trend line shown in the bottom figure is 0.9166. There are two problems:
the figure does not show the R-squared information, and I sincerely doubt that the
value of the line shown is as high as the caption indicates.