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.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| 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 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, Its 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 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 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 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 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 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 |
