Errata for Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition
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 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 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 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 |
|
| 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 |
|
|
| |