Errata
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 17 and 18 |
"Cushy" should be "Comfy", "Comfy" should be "Cushy" On pages 17 and 18, the exercise instructs to replace all instances of the word "Comfy" with the word "Cushy" in the file Replace.xls. This is incorrect. It instead should instruct to replace all instances of of the word "Cushy" with the word "Comfy". Please transpose all references of the two words on the two pages. |
Microsoft Press | May 06, 2010 | |
Printed | Page 20 |
"47.95" should be "44.95", "44.95" should be "47.95" |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 30 |
Cells are already Merged and Centered in Easier.xls On page 30, steps 16 and 17 instruct to "Merge and Center" cells E2 through G2 in the file Easier.xls. However, those cells are already merged and centered in the file. Please click "Merge and Center" to unmerge them first, then follow steps 16 and 17 to merge the cells as described. |
Microsoft Press | May 06, 2010 | |
Printed | Page 35 |
"SettingUpWorkbook folder" should be "ChangingDocAppearance folder" |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 37 |
"SettingUpWorkbook folder" should be "ChangingDocAppearance folder" |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 37 |
"tab page" should be "Size tab" On page 37, in step 6, Change: "6. In the Scale section of the tab page..."To: "6. In the Scale section of the Size tab..." |
Microsoft Press | May 06, 2010 | |
Printed | Page 48 |
"=SUM" should be "=SUM(" On page 48,Change: "2. In the formula bar, type = SUM, drag from cell D4 to D5, and press ENTER." To: "2. In the formula bar, type = SUM(, drag from cell D4 to D5, and press ENTER." |
Microsoft Press | May 06, 2010 | |
Printed | Page 49 |
Correction To Step 4 |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 63 |
Normal should be Emphasis On page 63, in step 3, Change: "The Style dialog box appears, with Normal in the Style name box." To: "The Style dialog box appears, with Emphasis in the Style name box." |
Microsoft Press | May 06, 2010 | |
Printed | Page 85 |
Access should be Excel |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 89 |
Access should be Excel On page 89, Change: "Open: Filter from the SBSAccessUsingFilters folder." To: "Open: Filter from the SBSExcelUsingFilters folder." |
Microsoft Press | May 06, 2010 | |
Printed | Page 93 |
Access should be Excel |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 103 |
Clarification to step 2 |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 108 |
Clarification to step 2 On page 108, step 2 does not specify from which folder to open the specified files. Change: "2. Hold down the Ctrl key while you click Linking.xls and 2001Q1.xls files, and then click Open." To: "2. Naviate to the SBSExcelMultiple Sources folder, and hold down the Ctrl key while you click Linking.xls and 2001Q1.xls files, and then click Open." |
Microsoft Press | May 06, 2010 | |
Printed | Page 109 |
Update should be Edit Links On page 109, in step 16, Change: "16. In the alert box, click Update." To: "16. In the alert box, click Edit Links." |
Microsoft Press | May 06, 2010 | |
Printed | Page 112 |
Clarification to step 2 |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 114 |
Clarification to step 2 On page 114, step 2 does not specify from which folder to open the specified files. Change: "2. Hold down the Ctrl key while you click the Y2001ByMonth.xls and TotalByHour2001.xls files, and then click Open." To: "2. Navigate to the SBSExcelMultiple Sources folder, and hold down the Ctrl key while you click the Y2001ByMonth.xls and TotalByHour2001.xls files, and then click Open." |
Microsoft Press | May 06, 2010 | |
Printed | Page 159 |
Day should be Hour |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 284 |
Incorrect description of Excel behavior On page 284, step 13 contains incorrect information. Change: "In the XML Source task pane, right-click the productName element, and click Remove Element. Click OK to acknowledge that the deletion will cause data to be lost. Excel removes the XML field in cell B3 and the data that was read into it, but the field’s label remains in cell A3." To: "In the XML Source task pane, right-click the productName element, and click Remove Element. Excel removes the XML field in cell B3, but the data remains and the field’s label remains in cell A3." Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.The print number of the book is located on the copyright page in the form of a string of numbers. For example: "2 3 4 5 6 7 8 0 QWT 9 8 76 5 4". The first number in the string is the the print number. In this example, the print number is 2. |
Microsoft Press | May 06, 2010 |