Errata

Excel 2007: The Missing Manual

Errata for Excel 2007: The Missing Manual

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page 291
3rd Paragraph

The beginning of the 3rd paragraph states "If you don't have 25 years to wait..." but the example is based on if you don't have $82K to invest. The code snippet the occampanies the text has 25 years set as the npre.

Note from the Author or Editor:
"If you don't have 25 years to wait" should read "If you don't have that much cash on hand"

 Richard Razo  Nov 17, 2009  Feb 01, 2010
Printed
Page 5
1st paragraph

3rd sentence: the phrase "the way" is repeated. (Another nice detail is the way the way you can jump . . .)

Note from the Author or Editor:
"the way the way" should be "the way"

 Dennis Taylor  Sep 16, 2009  Feb 01, 2010
Printed
Page 302
Figure 10-5

Hello, I think that there is an error in cells D12, E12, F12 and G12. The formula should include DB instead of DDB.

Note from the Author or Editor:
Picture updated in second edition only.

 Anonymous  Jun 22, 2009 
Printed
Page 257
4th paragraph

Book states "Whereas ROUNDDOWN() always rounds a number towards its smallest value (so that =ROUNDDOWN(-3.4,0) gives you -4)"

This is incorrect; =ROUNDDOWN(-3.4,0) returns a result of -3 instead. =TRUNC(-3.4,0) and =ROUNDDOWN(-3.4,0) return the same value

Note from the Author or Editor:
Delete the paragraph "For the most part, TRUNC()..." and the following single line example "=TRUNC(-3.4, 0)"

 Anonymous  Jun 19, 2008 
Printed
Page 30
language change/formatting problem

in "The Tabs of the Ribbon" section, 1st graf, last sentence. change
comma between "ribbon" and "However" to a period

 Anonymous    Feb 01, 2010
Printed
Page 33
language change/formatting problem (top of page)

"The Formula Bar" section, 2nd graf. change "tying" to "typing"

 Anonymous    Feb 01, 2010
Printed
Page 59
language change/formatting problem

1st graf. Change "You assume that when..." to "You might assume that
when.."

 Anonymous    Feb 01, 2010
Printed
Page 60
minor technical mistake

graf beginning "Occasionally...". change "January 2, 2007" to
"January 2, 2003"

 Anonymous    Feb 01, 2010
Printed
Page 89
language change/formatting problem

last sentence, change "Chapter 7" to "Chapter 8".

 Anonymous    Feb 01, 2010
Printed
Page 110
language change/formatting problem

very end of step 2: delete "[[ch5]]"

 Anonymous   
Printed
Page 110
language change/formatting problem

fig 4-13 caption. Revise text so it now says:

In the Find Format dialog box, Excel won?t use any
formatting option that?s blank or grayed out as
part of it?s search criteria. For example, here, Excel
won?t search based on alignment. Checkboxes are
a little trickier. In some versions of Windows, it
looks like the checkbox is filled with a solid square (as with the ?Merge
cells? setting in this example). In other versions of Windows, it looks like
the checkbox is dimmed and checked at the same time.
Either way, this visual cue indicates that Excel
won?t use the setting as part of its search.

 Anonymous    Feb 01, 2010
Printed
Page 112
First sentence of Note is missing the word ?cell?.

It should read, ?It?s possible for a single cell to contain...?

 Anonymous    Feb 01, 2010
Printed
Page 189
minor technical mistake

Step 2, ListNumber continue grafs. 1st graf: change "drag the
vertical" to "drag the horizontal"

 Anonymous    Feb 01, 2010
Printed
Page 189
minor technical mistake

2nd graf: change "drag the horizontal" to "drag the vertical"

 Anonymous    Feb 01, 2010
Printed
Page 230
language change/formatting problem

Xref in Tip box at top of page. Change to 236.

 Anonymous    Feb 01, 2010
Printed
Page 242
language change/formatting problem

fig 8-10. change last sentence to read: "The help page shown here shows
the reference for the COMBIN() function."

 Anonymous    Feb 01, 2010
Printed
Page 268
First instruction, 2nd paragraph. The text shows that "B2

through B12 are the student scores being analyzed." This should be
B2 through B13. Also, it continues "(E6 covers scores between 0
and 49, E7 covers 50 to 59, and so on)" This should say "(E6
covers scores between 0 and 59, E7 covers 60 to 69, and so on)"

 Anonymous    Feb 01, 2010
Printed
Page 283
Table 9-3 Advanced Statistical Functions (continued) has

the exact same descriptions for VAR() and VARA() Functions. This
is incorrect.

Note from the Author or Editor:
VAR() description, third column, should read "Excel ignores blank and text cells." instead of "Excel uses text cells as values, but ignores blank cells."
VARA() description, third column, should read "Excel uses text cells as 0 values, but ignores blank cells." instead of "Excel uses text cells as values, but ignores blank cells."

 Anonymous    Feb 01, 2010
Printed
Page 398
language change/formatting problem

graf starting "Table styles work in like cell styles". Delete the
"in" in that phrase.

 Anonymous    Feb 01, 2010
Printed
Page 400
language change/formatting problem

"Banded columns" bullet point. 2nd sentence should read: "Folks use
banded columns less than..."

 Anonymous    Feb 01, 2010