Errata

MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®

Errata for MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page xxv
4th line

The listed URL, if typed into the address bar, results in a 404 error. In various help forums, employees of O'Reilly have provided a "correct" link, which also results in a 404 error. This is listed as a typo on the errata listing, and was allegedly fixed in 2011, but it clearly remains as an epic mistake.

 Tim Mathews  Jan 19, 2014 
Printed

I cannot find the answers (solutions) for the exercices done with the practice files downloaded at http://go.microsoft.com/FWLink/?Linkid=206095.

I am presently doing the Excel exercises.

Could you please tell me where and how I can have access to these?

Thank you

 Marlene Horth  Jan 21, 2014 
Printed, PDF Page 10
2nd line

Change "Click the Next Screen or Previous Screen button in the center of the title bar." to "Click the Next Page or Previous Page button in the center of the title bar."

 Paul Hamel  Feb 15, 2013 
Printed, PDF Page 20
2nd para, lines 4-5

Remove sentence, "When more than two windows are stacked, the ribbon is hidden automatically." This doesn't appear to be correct. I stacked multiple windows and the ribbon remained visible.

 Paul Hamel  Feb 15, 2013 
Printed, PDF Page 89
Under "To create a new font set", step 3, 2nd bullet

Change ...heading styles to ...body styles. Bullet should read, "In the Body font list, click the font you want to use for all body styles."

 Paul Hamel  Feb 15, 2013 
Printed, PDF Page 114
Lines 5-7

The 2 bullets under "To store a clip art object in the Clip Organizer" are not accurate as worded. Suggest:
Bullet 1: Delete end of sentence, "and then click Make Available Offline."
Bullet 2: Replace first word "In" with the word "Click".

 Paul Hamel  Feb 15, 2013 
PDF Page 219
Under the subheading "To unhide the first row or column of a worksheet"

Under the subheading "To unhide the first row or column of a worksheet" in page 219, step 1 says "In the Name box to the left of the Formula Bar, enter , and then press Enter."
This sentence should say "In the Name box to the left of the Formula Bar, enter A1, and then press Enter." In other words, the sentence is missing A1.

 Xavier Paredes  Aug 25, 2013 
PDF Page 227
"Practice Tasks" box

In bullet-point #2 the "Practice Tasks" box on page 227, the reader is instructed to do the following: "Group the By Product and Sales By Product worksheets, and then apply the Austin theme to the worksheet group."
The issue is that the method of applying a Theme wasn't properly covered in the Excel section of the book up to & including this page. I didn't realize until I did some external research that, to apply the Austin theme, I had to go to the Page Layout tab, then find the Theme group, which is to the left of the Page Setup group, and use the drop-down on the Theme icon in that group to find & apply the Austin Theme.

 Xavier Paredes  Aug 25, 2013 
Printed, PDF Page 251
Practice Tasks box, task 1, line 1

The only worksheet in the named workbook is named "Sheet1".
Change "On the Product Sales worksheet..."
to "On the Sheet1 worksheet..." (Note: This same entry for page 293 should have been for page 251)

 Paul Hamel  Feb 16, 2013 
Printed Page 348
5th major bullet, first (only) sub-bullet

I don't think there is a "Character Spacing button" on Home/Font. Must use technique of opening dialog box.

 John Kauffman  Jul 25, 2013 
Printed, PDF Page 382
Tip box

The tip is incomplete. Suggest something like, "To maintain the original aspect ratio of any shape while inserting, select the desired shape from the Shapes gallery, and while holding down the Shift key, click and drag to insert the shape."

 Paul Hamel  Feb 16, 2013 
Printed, PDF Page 521
Line 11

Suggest rewording to impove clarity. Suggest:
At the bottom of the Navigation Pane and above the navigation button area, drag the move handle up or down.

 Paul Hamel  Mar 10, 2013 
Printed, PDF Page 548
Last line

Change the word 'modify' to 'delete'.

Paul Hamel  Mar 10, 2013 
Printed, PDF Page 554
1st Step 1

Change the word 'picture' to 'chart'.
1. Position the cursor in the pane where you want the chart to appear.

 Paul Hamel  Mar 10, 2013 
Printed, PDF Page 609
line 12, 2nd step 3

Suggest rewording to improve clarity. Current wording results in all occurences being deleted, past and future, which means occurrences that may still be wanted for historical purposes are also deleted. Suggest:
3. In the Appointment Recurrence dialob box, click the Remove Recurrence button to remove all past and future recurring items from the calendar, or, set the End After or End by options to end an items recurrence while retaining a specific range of recurring items on the calendar (i.e., for past events that are no longer continuing).

 Paul Hamel  Mar 10, 2013 
Printed, PDF Page 622
6th line from bottom

Correct typo by changing ppointments to appointments

 Paul Hamel  Mar 10, 2013