MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint®

Errata for MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint®

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 vi
First paragraph

There are a number error review. The number of the Excel 2010 expert review is 77-888, not 77-887(exam Word 2010 Expert)

Note from the Author or Editor:
I don't have access to this page, but the errata is correct. If the Excel exam on page vi is listed as 77-887, it should be changed to 77-888.

Anonymous  Aug 12, 2011  Oct 14, 2011
Printed
Page 13
1st paragraph, 1st line

"... to a workbook, ..."; probably should be "... to a document, ..."

Note from the Author or Editor:
On page 13, under the heading 1.2 Apply Protection to a Document, the reference to "workbook" should be "document." The text should read as follows: "To apply permissions and protection to a document, ..."

Anonymous  Oct 21, 2011 
Printed
Page 276
first paragraph

Page states that relative cell references are displayed using $$ dollar signs, while absolute references are displayed without dollar signs. This is reversed.

Note from the Author or Editor:
The first paragraph on the page should be changed as follows: Before you record a macro, you should also determine whether to use absolute or relative cell references . (You can use a combination of the two as necessary) . If you keep absolute references, the macro operates only in the specific cells you use when you record the macro . For example, with absolute references, if you insert a series of dates or names in the cell range A1:G1 as a step in recording a macro, that macro works only in that cell range when you run it . If you use relative references (by clicking Use Relative References in the Code group), the macro will insert the data in any comparable range of cells.

Michael Styles  Oct 05, 2011  Oct 14, 2011
Printed
Page 283
2nd Paragraph after 'See Also' Box

At the end of the second line, 'This Worksheet' should read 'This Workbook'.

Note from the Author or Editor:
The reference to This Worksheet at the end of the second line of the second paragraph after the See Also reference on page 283 should be ThisWorkbook. Change the second sentence in this paragraph to read as follows: In the Project Explorer (the pane at the left), right-click This Workbook and choose View Code.

Anonymous  Oct 14, 2011 
Printed
Page 308
last line

"... enter a custom record ..."; should be "... enter a customer record ..."

Note from the Author or Editor:
In the last line on page 308, the text refers to a "custom" record, but the text should refer to a "customer" record. Change the last sentence on this page to read as follows: "This prevents you from having to enter a customer record for each separate order."

Anonymous  Oct 21, 2011 
Printed
Page 331
1st paragraph, 2nd sentence

1st paragraph, 2nd sentence refers to the arrow button in the top-right corner of the Navigation Pane. This section mentions the possibility that the Navigation Pane is closed. The arrow button that opens it is located to the far LEFT in this situation, and there is no visible navigation pane for the button to be in the "top-right corner of". Also, I believe I saw that button referred to as a "double-arrow" elsewhere -- probably need more consistent terminology.

Note from the Author or Editor:
On page 331, the second sentence on the page (in the first paragraph after the heading 1.2 Configure the Navigation Pane) should read as follows: "To show or hide the navigation pane, click the arrow button that appears at the top of the pane."

Anonymous  Oct 21, 2011 
Printed
Page 358
econd line, 1st paragraph

Page 358; second line, 1st paragraph; "...then select After Update. Access Opens the macro..." I suspect that "Opens" should be "opens".

Note from the Author or Editor:
In the second line of the first paragraph on page 358, the word Opens should be lowercase. Please change as follows: "...then selects After Update. Access opens the macro designer...

Anonymous  Oct 21, 2011 
Printed
Page 695, back cover
Offer page and back cover page

We apologize, but early printings of this book included information about a free Learning Plan Assessment which is not available.

Microsoft Press  Jan 12, 2012