Errata

Excel 2000 in a Nutshell

Errata for Excel 2000 in a Nutshell

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 "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 xi
Changed the first URL from "http://www.oreilly.com/catalog/excel/" to

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

 Anonymous    Oct 01, 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 01, 2000
Printed
Page 127
In the 3rd paragraph, the reference to Figure 6-24 was changed to

Figure 6-22.

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

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

"ODDLYIELD."

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

Anonymous    Oct 01, 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 01, 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 01, 2000
Printed
Page 352
The references to Figure 13-13 under "Holidays" and "Example" were

changed to Figure 13-14.

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

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

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

"cumulative."

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

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

"SEARCH."

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

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

Anonymous    Oct 01, 2000