Errata

Errata for MOS 2013 Study Guide for Microsoft Excel

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 28 Last paragraph in Practice Exercises	We are asked to apply the Austin theme to the worksheet group. The Austin theme was not one of the options available under Themes.	Julie Lofquist	Feb 23, 2014
Printed	Page 32 2nd paragraph	On page 32, in the step 2 of the procedure "To display multiple views of a workbook in the same progam window" instead of "click the cell above and to the left of where you want to split the panes" i think it should write "click the cell below and to the right of where you want to split the panes"	Anonymous	Feb 05, 2014
Printed	Page 43 Part of the Excel_1-4b exercises	author wrote "attach the keywords spending and saving" to the workbook. the above statement does not make any sense. The word Attach is associated with attaching files and perhaps should not be used when teaching MOS apps so as not to confuse the student.	Anonymous	Mar 19, 2014
Printed, PDF	Page 50 In the task "To set browser view options when saving a workbook to a SharePoint site"	the author asks the student to go to save as dialog box in order to browse the document library. this is an error. In MS Excel 2013, the browser view options is accessed via the info page accessed via the backview.	Anonymous	Mar 19, 2014
PDF	Page 84 bottom of pp 84 and top of pp 85 in practice exercises	Hello: Hope you are perfectly healthy today. Thanks for teaching me with you terrific training materials! However, the Book directs the user to insert a row below the Times and summarize the data for each day of January by using a column Sparkline for that row? How about insert a row below the Times to summarize the data for each hour of Time by using a column Sparkline for that column. Then on top of the next page pp85: Have the user insert a column to summarize the data for each day of January by using a column Sparkline for that row? Good day-David	Anonymous	Sep 28, 2013
PDF	Page 85 Last paragraph near the bottom of the practice page	Hello: Hope all is fine with you. Thanks for all your great educational tools. The practice exercise states to create subtotals of sales amounts first by Period and then by Region. Please clarify if you want two separate reports or just ONE report using a multi-level sort like Regional Sales within Period. Good day- David	Anonymous	Sep 28, 2013