Errata

Microsoft® Office Excel® 2007 Inside Out

Errata for Microsoft® Office Excel® 2007 Inside Out

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, PDF, ePub, Other Digital Version
Page 714
last paragraph

You have an incorrect cell reference where it says: "The data has been filtered to show the numbers of a single category, Mystery, but by using the filter control at the right edge of cell B2, we could switch the table to a different category (or combination of categories).

B2 should be B1, B2 is an empty cell.

Note from the Author or Editor:
Thanks for the careful review.

 Ronald Black  Nov 08, 2012 
Printed
Page 509
1st paragraph and Figure 14-1

The references to OR and AND in the first paragraph are reversed. The formula on line three should read:
=IF(AND(G4<5,F4>75), ?Pass?, ?Fail?). The formula appears to work in Figure 14-1 because the formulas in cells H5 through H8 in the
And Or Not.xlsx Sample File, which is the source for Figure 14-1, correctly use AND instead of OR. (The formula in cell H4 should also use AND.) The last sentence in the paragraph should read: ?If you use OR instead of AND in the formula shown in Figure 14-1, all students would pass.?

Note from the Author or Editor:
Yes, this was a mistake in the Excel Inside Out 2007 edition. It was fixed, and is correct in the 2010 edition.

 G Nix  Aug 13, 2011 
Printed
Page 63
Figure 2-34

All references in this section refer to 'Open' dialog box which is implimented in Vista only. This is icorreect and misleading for users using Excel 2007 in Windows XP. Functions refered to in this section are not available to XP and earlier implimentations.

 R H Bailin  Sep 02, 2010 
Printed
Page 63
Figure 2-34

All references in this section refer to 'Open' dialog box which is implimented in Vista only. This is icorreect and misleading for users using Excel 2007 in Windows XP. Functions refered to in this section are not available to XP and earlier implimentations.

Note from the Author or Editor:
(previous edition of the book) True, although these issues were discussed in detail at the beginning of this same chapter. To have added XP information at every juncture would have swelled the book considerably.

 R H Bailin  Sep 02, 2010 
Printed
Page 50

Incorrect information about template files
On page 50, the last paragraph is incorrect and should be removed.



The paragraph to remove reads:

"Note that in previous versions of Excel, you could put any type of Excel file into the Templates folder or any of its subfolders, and Excel would treat them all as templates. Office Excel 2007 no longer allows this—only template files show up in the New dialog box."

 Microsoft Press  Jul 13, 2010 
Printed
Page 966

"seven" should be "64"
On page 966, the second sentence in the description of the "IF" function contains an incorrect number of additional functions.



Change:

"You can nest up to seven additional functions within an IF function."



To:

"You can nest up to 64 additional functions within an IF function."

Microsoft Press is committed to providing informative and accurate

books. All comments and corrections listed above are ready for

inclusion in future printings of this book. If you have a later printing

of this book, it may already contain most or all of the above corrections.

 Microsoft Press  Jul 13, 2010 
Printed
Page 42

"Personalize" should be "Popular" On page 42, the 3rd sentence in the box at the top of the page titled "Belly Up to the Mini-Bar" contains an incorrect menu option choice. Change: "Click the Microsoft Office Button, click Excel Options, and in the Personalize category, select or clear the Show Mini Toolbar On Selection check box." To: "Click the Microsoft Office Button, click Excel Options, and in the Popular category, select or clear the Show Mini Toolbar On Selection check box."

 Microsoft Press  May 06, 2010 
Printed
Page 57

XLTXM should be XLTM On page 57, the first bullet point references the wrong file extension. Change: "Excel Macro-Enabled Template (XLTXM)" To: "Excel Macro-Enabled Template (XLTM)"

 Microsoft Press  May 06, 2010 
Printed

**NOTE**

If for any reason you are unable to install the practice files from the CD, the files can also be downloaded from the web at http://examples.oreilly.com/9780735623217-files/.

 Microsoft Press  Nov 11, 2005