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.

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 Note Update

Version Location Description Submitted by Date submitted
Printed Page 11
2nd paragraph

The last sentence of the paragraph should say "charts and graphics" instead of "chapters and graphics".

 Troy Hopkins  Aug 15, 2010 
Printed Page 123
1st paragraph

In description of date-format, "backward slashes" should be "forward slashes," or just "slashes."

 gerry.fifer  Oct 21, 2015 
Printed Page 261
United States

Says: "When you want to get a little fancier, use COUNT( ) on the Customer Name column to find out how many rows are in the table."

The book had just explained that COUNT( ) only looks at cells with numbers in them, where COUNTA( ) can be any kind of content. So should that sentence say COUNTA( ) instead?

 Russell Bither-Terry  Dec 26, 2014 
Printed Page 334
Figure 12-1

Cell C10 value should be $700.00, not $910.00

 Leigh Hughes  Jun 27, 2016 
Printed Page 335
Paragraph starting "Once you've retrieved"

"For example, the formula in cell C9" should read "For example, the formula in cell C10".

"=C6*C7" should read "=C5*C7".

 Leigh Hughes  Jun 27, 2016 
Printed Page 415
Figure 14-19

Page 414 describes how to highlight duplicates using conditional formatting, and explains that you should "select the table column to check for duplicate values."

However, Figure 14-19 shows an image of highlighting duplicate values based on several columns yet does not explain how to do so.

I have tried selecting the entire table, or multiple columns (using Ctrl) yet the result is having the duplicates per column be highlighted.

Anonymous  Jan 24, 2012 
Printed Page 525
8th paragraph

"If there's more than one series in your chart, Access asks you which one you want to use in the trendline."

I think you meant to say "...Excel asks you..."

Anonymous  Jul 18, 2010 
Printed Page 598
Figure 21-3

The average for New York, Male is incorrect. It is listed as $5,155.67. But the average should be $3,566.00.

 Anonymous  Apr 08, 2011 
Printed Page 616
Sum of revenues exercise

In order to calculate Sum of Revenues you first add "Unit Price" column, then add "Quantity", and then you multiply the sum of Unit Price by the sum of Quantity.
I think that the calculation that should be performed is multiply EACH Unit Price by its CORRESPONDING Quantity per each PRODUCT, then sum the results of all the products in order to arrive at total revenues. Please try my approach, you will see that the amounts are SIGNIFICANTLY different!

Anonymous  Dec 07, 2010 
Printed Page 619
line 2

'Multiple Fields checkbox' should read 'Multiple Items checkbox'.

 Leigh Hughes  Jun 26, 2016