Errata

Print Print Icon

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 "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



Version Location Description Submitted By Corrected
Printed Page xi
Changed the first URL from "http://www.oreilly.com/catalog/excel/" to

"http://www.oreilly.com/catalog/9781565927148/."

 Anonymous  Oct 2000
Printed Page 3
The first sentence under "Extensive File Compatibility" now reads:

"...Excel has the ability to open files from several different sources
including all Microsoft Office products..."

Should read:

"...Excel has the ability to open files from several different sources
including all Microsoft Office products (with the exception of
PowerPoint)..."

Anonymous 
Printed Page 11
2nd Paragraph of the Format section, 2nd sentence

If you want to apply a specify format...
should be:
If you want to apply a specific format...

 Anonymous 
Printed Page 14
under "Keyboard Shortcuts"

Shirt+F6
should be
Shift+F6

 Anonymous 
Printed Page 55
In item 1, "Items to publish," the reference to Figure 3-6 was

changed to Figure 3-5.

 Anonymous  Oct 2000
Printed Page 127
In the 3rd paragraph, the reference to Figure 6-24 was changed to

Figure 6-22.

 Anonymous  Oct 2000
Printed Page 205
Inserted a period at the end of the sentence right above the figure.

Anonymous  Oct 2000
Printed Page 273
In center column of list of functions, changed "ODDLYIELA" to

"ODDLYIELD."

 Anonymous  Oct 2000
Printed Page 329
In third column of list of functions, deleted "SECOND."

Anonymous  Oct 2000
Printed Page 350
In the 1st paragraph under the heading "Example," the reference to

Figure 13-11 was changed to Figure 13-12.

 Anonymous  Oct 2000
Printed Page 351
In the 1st paragraph under the heading "Example," the reference to

Figure 13-12 was changed to Figure 13-13.

 Anonymous  Oct 2000
Printed Page 352
The references to Figure 13-13 under "Holidays" and "Example" were

changed to Figure 13-14.

 Anonymous  Oct 2000
Printed Page 405
In center column of list of functions, changed "GAMMALIN" to "GAMMALN."

Anonymous  Oct 2000
Printed Page 405
In third column of list of functions, added "STDEVP."

Anonymous  Oct 2000
Printed Page 448
In the code line under "To Calculate," changed "cummulative" to

"cumulative."

 Anonymous  Oct 2000
Printed Page 494
In third column of list of functions, changed "DSTDEVA" to "DSTDEVP."

Anonymous  Oct 2000
Printed Page 502
At the bottom of the third column of the list of functions, deleted

"SEARCH."

 Anonymous  Oct 2000
Printed Page 526
Under "address" and "contents," changed "Refererence" to "Reference."

Anonymous  Oct 2000
Printed Page 544-547
Changed "ch02" to "Chapter 2," "ch03" to "Chapter 3," etc.

Anonymous  Oct 2000