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. 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, Safari Books Online, Other Digital Version
Page xxv
second and third paragraphs

URL should read: http://go.microsoft.com/FWLink/?Linkid=206095 Third paragraph should read: Go to the detail page in your web browser and follow the instructions for downloading the files.

Note from the Author or Editor:
Error corrected. Will be fixed in next printing.

Rosemary Caperton  Mar 31, 2011  Jul 15, 2011
Printed
Page offer page and 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 13, 2012 
Printed, PDF
Page 10
line 2

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."

Note from the Author or Editor:
On page 10, in the first single-step procedure, please change "Next Screen or Previous Screen" to "Next Page or Previous Page" and retain the bold formatting of the button names.

Paul Hamel  Feb 15, 2013  Sep 06, 2013
Printed, PDF
Page 18
Tip box

Tip box mentions that you can select up to 5 pages down and 11 pages across. It's actually 4 pages down and 14 across.

Note from the Author or Editor:
In the Tip on page 18, replace the second sentence with "You can select many more pages by dragging through the grid. The number of pages you can select is dependent on your screen resolution."

Mixologism  Jun 13, 2012  Feb 01, 2013
PDF
Page 29
Practice task

On the Practice Task where it reads "In the MyVersions document, change the title to Business Office Procedures. Then save the document." it should read "In the MyVersions document, change the title to Business Office Procedures. Wait at least 1 minute, then save the document." If there's no activity (i.e. typing, any format change, etc.) the software will not make any auto save. Therefore, even if there has been more than 1 minute before the title is changed, there will be no auto saved copy of the original MyVersions file (with the title Office Procedures). Also, once the title is changed to Business Office Procedures, if the file is saved immediately (before 1 minute), no auto saved copy will be created. Regards,

Note from the Author or Editor:
On page 29, in the Practice Tasks box, in the second bullet point, change "Then save the document." to "Wait one minute, and then save the document."

David Iriarte  Sep 29, 2013 
Printed
Page 59
Last paragraph

Change "0,27 centimeters" to "1,27 centimeters".

Note from the Author or Editor:
On page 59, in the first para under the Setting Tab Stops heading, please change "0.27 centimeters" to "1.27 centimeters"

Jan jelínek  Aug 02, 2012  Feb 01, 2013
Printed
Page 112
Practice Tasks - 3rd & 4th

It is impossible to perform the 3th & 4th tasks on page 112 using Word 2010. The instructions apply to formatting WordArt in Word 2007!! I discovered this fact after searching Google for an answer as to why I couldn't manage these feats. There is no WordArt style 16 or 21 or shadow style 7 in Word 2010; and, it is impossible to set WordArt spacing to "Very Loose." I notice these two practice tasks are almost word for word the same as those on page 92 of the MOS 2007 Study Guide (bought but never used since I decided to jump to Office 2010). It seems Microsoft made changes to WordArt in Word 2010 and didn't inform the authors.

Note from the Author or Editor:
Location (1): Page 112 Practice Tasks 3rd bullet point Change: WordArt style 16 To: a Gradient Fill WordArt style Location (2): Page 112 Practice Tasks 4th bullet point Change (1): WordArt style 21 To: a Fill WordArt style Change (2): Then set the spacing to Very Loose. To: *Delete this sentence entirely. Change (3): Shadow style 7 To: the Perspective Diagonal Lower Left shadow style

Anita Horovenko  Dec 29, 2011  Feb 03, 2012
Printed, PDF, Safari Books Online
Page 116
4th procedure

Location: Page 116 ->To link text boxes so that text flows from one text box to another Step 2 Change: On the Text Box Tools <bold>Format</bold> contextual tab... To: On the Drawing Tools <bold>Format</bold> contextual tab...

Joan Lambert
Joan Lambert
O'Reilly Author 
Jan 31, 2012  Feb 03, 2012
Printed
Page 117
Point 1 under second instruction arrow.

I believe point 1 under "To save a selected text box as a building block" should read... 1. On the Insert tab, in the Text group, click the Text Box button, and then click Save Selection to Text Box Gallery. (Substitute "Insert tab" for "Format contextual tab")

Note from the Author or Editor:
Location: Page 117 ->To save a selected text box as a building block Step 1 Change: On the <bold>Format</bold> contextual tab... To: On the <bold>Insert</bold> tab...

Anita Horovenko  Dec 29, 2011  Feb 03, 2012
Printed
Page 117
Practice Tasks - 3rd task

This is another issue of applying the language of Word 2007 to Word 2010 - when you shouldn't; or, not correcting moved data from one study guide to the next. The issue is with the last task under Practice Tasks on page 117. The shadow effects in Word 2010 are not referred to as "Style" as they are in Word 2007. I am getting very confused hunting for things that aren't there as I move between the Step-by-Step books and this 2010 MOS Study Guide

Note from the Author or Editor:
Location: Page 117 Practice Tasks 3rd bullet point Change: Then apply Shadow Style 1 to both boxes. To: Then apply an Offset Diagonal Top Right shadow to both boxes.

Anita Horovenko  Dec 29, 2011  Feb 03, 2012
Printed
Page 166
2nd paragraph - "To move by one cell"

Press the Left Arrow key or the Tab key to move one cell to the right. Should state: Press the Right Arrow key or the Tab key to move one cell to the right. *** Press the Right Arrow key or the Shift+Tab to move one cell to the left. Should state: Press the Left Arrow key or the Shift+Tab to move one cell to the left.

Note from the Author or Editor:
On page 166, in the procedure titled "To move by one cell" make the following two changes: - In the 3rd list item, change "Left" to "Right" - In the 4th list item, change "Right" to "Left"

Anonymous  Apr 28, 2011  Jul 15, 2011
Printed
Page 179
"To add a command to a custom group"

The instructions in step 3 are to double-click the command. When I do this nothing happens - the command is not added to the custom group. It is added, however, when I click the command to select it and then click the ADD button.

Note from the Author or Editor:
On page 179, in the procedure "To add a command to a custom group," change step 3 to "In the <bold>Choose commands</bold> pane, click the command. Then click the <bold>Add</bold> button.

Peter Robbins  Jun 22, 2011  Jul 15, 2011
Printed
Page 184
"To display properties in a browsing dialog box"

I am confused by this and by the following tip in the box. I tried using the help function but....no help.

Note from the Author or Editor:
On page 184, in the procedure "To display properties in a browsing dialog box," change step 2 to "Right-click any column heading, and then click the property you want to display."

Peter Robbins  Jun 22, 2011  Jul 15, 2011
Printed
Page 192
Last practice task

"Move the Cost Per Ad data to the left of the Total Cost cells." - it is already to the left.

Note from the Author or Editor:
Location (1): Page 192 Practice Tasks 2nd bullet Change: on the Ad Buy Constraints worksheet. To: on the Ad Buy Constraints worksheet into the new worksheet. Location (2): Page 192 Practice Tasks 3rd bullet Change: Move the Cost Per Ad data to the left of the Total Cost cells. To: Move the Cost Per Ad data so that it is immediately to the left of the Total Cost cells.

Peter Robbins  Jun 24, 2011  Feb 03, 2012
Printed
Page 216
Practice task

There is no hyperlink in cell A12 (or in B13 or C13.)

Note from the Author or Editor:
I have emailed a replacement for this practice file (Excel\Chapter03\Hyperlink.xlsx) to Adam Zaremba and Nellie McKesson.

Peter Robbins  Jun 25, 2011  Feb 07, 2012
Printed
Page 218
Practice task

There are no row titles in the HeightWidth workbook.

Note from the Author or Editor:
Location: Page 218 Practice Tasks (at very top of page) Bulleted item Change: row and column titles To: row and column headings

Peter Robbins  Jun 25, 2011  Feb 03, 2012
Printed
Page 222
First practice task

If I specify the worksheet scaling to fit on 1 page wide by 2 pages tall the entire worksheet prints on one page only. If I specify 2 pages wide by 1 page tall it prints vertically on 2 pages. Is the correct solution to first create a manual page break between the January and February data and then specify printing each month on a separate page?

Note from the Author or Editor:
Page 222 Practice Tasks (at top of page) 1st bullet Change: ...contents will print horizontally on two pages of letter-size paper. To: ...contents will print in a landscape orientation on two pieces of letter-size paper.

Peter Robbins  Jun 25, 2011  Feb 03, 2012
Printed, PDF
Page 227
Practice Tasks box, task 1, line 1

Delete the word "and" after the comma. (Now reads, "In the SalesReport workbook, and make a copy of the By Product worksheet.")

Note from the Author or Editor:
On page 227, in the Practice Tasks section, in the first bullet point, delete the word "and"

Paul Hamel  Feb 15, 2013  Sep 06, 2013
Printed, PDF
Page 248
1st arrow bullet in lower half of page

Change, "In the Name box at the right end of the Formula Bar,..." to "In the Name box at the left end of the Formula Bar,..."

Note from the Author or Editor:
On page 248, in the single-step procedure, please change "right end" to "left end"

Paul Hamel  Feb 15, 2013  Sep 06, 2013
Printed, PDF
Page 254
Mid page, "See Also" box insert, line 3

Delete the words "or delete" from beginning of line 3. The Excel Help topic is named "Create a cutom number format"

Note from the Author or Editor:
Note that this change is on page 212, not page 254. On page 212, in the See Also reference, change: "Create or delete a custom number format" to "Create a custom number format"

Paul Hamel  Feb 15, 2013  Sep 06, 2013
Printed, PDF
Page 259
Item #2, line 1

Delete "and Properties". The 'Size' dialog has both the 'Size and rotate' and the 'Scale' areas. 'Properties' is a separate dialog and doesn't contain either areas described here.

Note from the Author or Editor:
On page 259, in step 2, please change "In the Size and Properties dialog box" to "On the Size page of the Format Chart Area dialog box" Please format all the capitalized words as Interface Object.

Paul Hamel  Feb 16, 2013  Sep 06, 2013
Printed
Page 266
To delete a shape from a SmartArt diagram

I can not delete a shape by clicking the shape and then pressing the Delete button. I can remove a shape, however, by right clicking on the shape and then clicking the Cut command in the dialog box.

Note from the Author or Editor:
On page 266, in the procedure "To delete a shape from a SmartArt diagram," change "Click the shape" to "Click the shape's border".

Peter Robbins  Jun 26, 2011  Jul 15, 2011
Printed
Page 270
Practice task 1

I was unable to locate any "stylized budget clip art."

Note from the Author or Editor:
Page 270 Practice Tasks 1st bullet Change: On the Budget worksheet...insert a stylize budget clip art image... To: On the My Monthly Budget worksheet...insert a clip art image that has a budget-related keyword...

Peter Robbins  Jun 26, 2011  Feb 03, 2012
Printed
Page 270
Practice task 2

I was not able to locate any "Powdered" styles.

Note from the Author or Editor:
On page 270, in the Practice Tasks section, in the second list item, change "Powdered" to "Powder".

Peter Robbins  Jun 26, 2011  Jul 15, 2011
Printed
Page 272
Tip box

"Word" should be "Excel".

Note from the Author or Editor:
On page 272, in the Tip readeraid, change "Word" to "Excel".

Peter Robbins  Jun 26, 2011  Jul 15, 2011
Printed
Page 295
Practice task 2

There is no Price category on the worksheet - I assume this should be the Sales category instead.

Note from the Author or Editor:
Location: Page 295 Practice Tasks In 1st bullet, change: by Category. To: by Category only. In 2nd bullet, change: by Category and then Price. To: by Category and then by Sales.

Peter Robbins  Jun 27, 2011  Feb 03, 2012
Printed
Page 312
In TIP box

...left-pointing arrows... should be ...right-pointing arrows...

Note from the Author or Editor:
In the Tip on page 312, please change "left-pointing arrows" to "right-pointing arrows".

Anonymous  Jun 16, 2011  Jul 15, 2011
Printed, PDF
Page 324
mid page, Ledger Paper

Replace the word 'legal' with 'ledger'. This line should read, "Ledger Paper For a presentation printed on 11-by-17-inch ledger size paper"

Note from the Author or Editor:
On page 324, in the 3rd bullet, please change "legal-size paper" to "ledger-size paper"

Paul Hamel  Feb 16, 2013  Sep 06, 2013
Printed
Page 343
Below the bold sentence " To switch to Slide Master view"

Under the bold sentence " To switch to Slide Master view", I believe it should be "On the View tab, in the Master Views group,..."

Note from the Author or Editor:
On page 343, in the single-step exercise following "To switch to Slide Master view," please change "Presentation Views" to "Master Views"

XU Zhe  Aug 30, 2012  Feb 01, 2013
Printed
Page 348
Under sentence "To change the case of selected text"

Under sentence "To change the case of selected text", I believe it should be "On the Home tab, in the Font group, click the Change Case button..."

Note from the Author or Editor:
On page 348, in the procedure titled "To change the case of selected text," change <bold>Case</bold> to <bold>Change Case</bold>

XU Zhe  Aug 31, 2012  Feb 01, 2013
Printed
Page 353
Number "4" of the first numbered list in this page

In number "4" of the first numbered list in this page, "in the Insert Picture dialog box" should be "in the Picture Bullet dialog box".

Note from the Author or Editor:
On page 353, in step 4, change "Insert Picture" to "Picture Bullet"

XU Zhe  Aug 31, 2012  Feb 01, 2013
Printed, PDF
Page 424
Item #2

Correct "In the Change <Animation> Effect..." to "In the More <Animation> Effect...". The Animation options available are: More Entrance Effects... More Emphasis Effects... More Exit Effects... None reference 'Change...Effect'.

Note from the Author or Editor:
On page 424, change steps 1 and 2 to the following: 1. On the <b>Animations</b> tab, in the <b>Animation</b> group, click the <b>More</b> button. At the bottom of the <b>Animation</b> menu, click <b>More <Animation Category></b> to display a list of animations in that category. 2. In the <b>Change <Animation Category></b> dialog box, click the animation effect you want. Please note that commands bracketed by <b></b> should be bold.

Paul Hamel  Feb 16, 2013  Sep 06, 2013