Errata
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 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: |
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 |
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 |
Anonymous | Feb 01, 2010 | |
Printed | Page 60 minor technical mistake |
graf beginning "Occasionally...". change "January 2, 2007" to |
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: |
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 |
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 |
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)" Note from the Author or Editor: |
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 |
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 Note from the Author or Editor: |
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: |
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: |
Anonymous | Jun 22, 2009 | |
Printed | Page 398 language change/formatting problem |
graf starting "Table styles work in like cell styles". Delete the |
Anonymous | Feb 01, 2010 | |
Printed | Page 400 language change/formatting problem |
"Banded columns" bullet point. 2nd sentence should read: "Folks use |
Anonymous | Feb 01, 2010 |