Errata

Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition

Errata for Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition

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 174
First sentence under "To complete a data entry"

It should read "Click on the Enter button to complete the entry and stay in the same cell." It currently reads "Press the Enter key to complete the entry and stay in the same cell." which would complete the entry, but would move to the next cell in the same column rather than stay in the same cell.

Note from the Author or Editor:
Please change the first arrow bullet point under "To complete a data entry" from "Press the Enter key to complete..." to "Click the Enter button (the check mark) on the Formula bar to complete..."

Please apply the Interface Object character style to the words "Enter" and "Formula."

 Anonymous  Oct 27, 2010 
Printed
Page 237

Graphic shows incorrect labels
On page 237, the labels in the image are incorrect.Change:"Relative reference"To:"Absolute reference"Change:"Absolute reference"To:"Relative reference"

 Microsoft Press  Jul 13, 2010 
Printed
Page 244

COUNTA should be COUNTBLANK
On page 244, step 2 of the "To count empty cells" section refers to the wrong function.



Change:

"On the Formulas tab, in the Function Library group, click the More Functions button, point to Statistical, and then in the list, click COUNTA."



To:

"On the Formulas tab, in the Function Library group, click the More Functions button, point to Statistical, and then in the list, click COUNTBLANK."

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 134

Reference to Envelope sample file should be removed On page 134, the last bullet point reads: "Open the Envelope document, and then use the name and address at the top of the letter as the basis for an evelope with a pre-printed return address." The Envelope document is not available, so this bullet point should be removed.

 Microsoft Press  May 06, 2010 
Printed
Page 240

right should be left On page 240, the first sentence under "To define a selected cell or range of cells as a named range" is incorrect.Change:"In the Name Box at the right end of the Formula Bar, type the range name, and then press Enter."To:"In the Name Box at the left end of the Formula Bar, type the range name, and then press Enter."

 Microsoft Press  May 06, 2010