Errata
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.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question
| Version | Location | Description | Submitted By |
|---|---|---|---|
| Printed | Page 5 1st paragraph |
3rd sentence: the phrase "the way" is repeated. (Another nice detail is the way the way you can jump . . .) |
Dennis Taylor |
| Printed | Page 205 To Simulate a Watermark step 1 |
Should read "switch to Insert view" instead of Page Layout view. |
Anonymous |
| Printed | Page 244 To count empty cells |
This doesn't count empty cells, but does count text cells. Totally empty cells are excluded from the count. |
Anonymous |
| 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)" |
Anonymous |
| 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)" |
Anonymous |
| 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)" |
Anonymous |
| Printed | Page 286 Table 9-3 Advanced Statistical Functions (continued) has |
the exact same descriptions for VAR() and VARA() Functions. This |
Anonymous |
| 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. |
Richard Razo |
| 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. |
Anonymous |
| Printed | Page 598 Figure 21-3 |
One of the values in the graphic on p. 598 is incorrect. The graphic depicts a section of the practice file named DifferentSummaries.xlsx. In that file on Sheet1, there is a summary table comparing purchases made by Males and Females from different cities. The value in cell E17 should be 3,566, not $5,155.67. |
Anonymous |
| Printed | Page 598 Figure 21-3 |
One of the values in the graphic on p. 598 is incorrect. The graphic depicts a section of the practice file named DifferentSummaries.xlsx. In that file on Sheet1, there is a summary table comparing purchases made by Males and Females from different cities. The value in cell E17 should be 3,566, not $5,155.67. |
Anonymous |
| Printed | Page 598 Figure 21-3 |
One of the values in the graphic on p. 598 is incorrect. The graphic depicts a section of the practice file named DifferentSummaries.xlsx. In that file on Sheet1, there is a summary table comparing purchases made by Males and Females from different cities. The value in cell E17 should be 3,566, not $5,155.67. |
Anonymous |
| Printed | Page 630 End of the "Settings" section |
You omitted an explanation of the "Apply these changes to all other cells with the same settings" box on the Data Validation Settings screen. What does this box mean? I'm a newbie and I wish you had explained it.... |
Anonymous |
| Printed | Page 630 End of the "Settings" section |
You omitted an explanation of the "Apply these changes to all other cells with the same settings" box on the Data Validation Settings screen. What does this box mean? I'm a newbie and I wish you had explained it.... |
Anonymous |
