MOS 2013 Study Guide for Microsoft Excel Expert

Errata for MOS 2013 Study Guide for Microsoft Excel Expert




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 pg. 69 - 70
pg. 69 - Tip box; pg. 70 - 1st paragraph

The Tip box on pg. 69 states that you cannot edit a saved (Custom) theme; however, there are instructions at the top of pg. 70 about how to edit a theme. What am I missing?

Note from the Author or Editor:
>Chapter 2 >Under the heading "Creating Themes" >The TIP after the graphic >DELETE ALL BUT THE LAST SENTENCE (What's left starts with "You an remove unwanted saved themes ...")

Lisa Osipowicz  Nov 08, 2013 
Printed
Page Pg. 75
Practice tasks text box - last item

Do you mean "create a new group box" instead of "create a new combo box"?

Note from the Author or Editor:
>Chapter 2 >Practice Tasks at the end of section 2.3 >Last task >Change the word "combo" to "group" >New sentence begins: "On the Form Controls worksheet, create a new group box that ..."

Lisa Osipowicz  Nov 08, 2013 
Printed
Page Index
all of the Index

The Index does not reference the correct page numbers. For instance, when looking up "form controls" in the Index, it references pages in the 30s when in fact the information is on pages in the 70s.

Note from the Author or Editor:
This is true. The index has errors. Another example: "top/bottom rules" are nowhere to be found on page 15.

Lisa Osipowicz  Nov 14, 2013 
Printed, PDF
Page 52
last sentence of 2nd paragraph

In order to select a Growth Trend option, you must drag the fill handle with the right mouse button.

Note from the Author or Editor:
>Chapter 2 >Under the heading "Using Advanced Fill Series Options" >Third paragraph ("For example, if you select ...") >Last sentence ("If you select the same ...") >Add "using the mouse button on the right" just before the second comma >So, the first part of sentence should read: If you select the same three values alone, and then drag the fill handle using the mouse button on the right, a menu appears ...

Lisa Osipowicz  Nov 07, 2013 
Printed
Page 62
Second tab "To manage conditional formatting rules"

Tab says "Add a new rule by clicking the ADD RULE button" Should say, "Add a new rule by clicking the NEW RULE button". There is no ADD RULE button.

Note from the Author or Editor:
>Chapter 2 >Under the heading "Creating Advanced Filters" >The second procedure at the end "To manage conditional formatting rules" >Add Rule button s/b New Rule button >Change the last line to read: "Add a new rule by clicking the New Rule button."

Richard Arcas  Jan 26, 2014 
Printed
Page 148
2nd Practice Task, Last Item

There is no State field in the ExcelExpert_4-2b workbook.

Note from the Author or Editor:
>Chapter 4 >Practice tasks at the end of section 4.2 >DELETE THE LAST PRACTICE TASK ("Create a hierarchy by using ...")

Lisa Osipowicz  Nov 13, 2013