Microsoft® Office Excel® 2003 Step by Step

Errata for Microsoft® Office Excel® 2003 Step by Step




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" On page 20, Change: "18. Type 47.95 and press ENTER" .... 19. On the Standard toolbar, click the Undo button. The contents of cell C12 revert to 44.95" To: "18. Type 44.95 and press ENTER" .... 19. On the Standard toolbar, click the Undo button. The contents of cell C12 revert to 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" On page 35, in step 3, Change: "3. If necessary, navigate to the SettingUpWorkbook folder and then double-click tgc_logo.gif." To: "3. If necessary, navigate to the ChangingDocAppearance folder and then double-click tgc_logo.gif."

Microsoft Press  Jul 13, 2010 
Printed
Page 37

"SettingUpWorkbook folder" should be "ChangingDocAppearance folder" On page 37, in step 16, Change: "3. If necessary, navigate to the SettingUpWorkbook folder and then double-click tgc_logo.gif." To: "3. If necessary, navigate to the ChangingDocAppearance folder and then double-click tgc_logo.gif."

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 On page 49, Change: "4. The value $18.95 appears in cell D8, and =SUM(D5:D6) appears in the formula bar." To: "4. The value $63.90 appears in cell D8, and =SUM(OrderItems) appears in the formula bar."

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 On page 85, Change: "Open: Filter from the SBSAccessUsingFilters folder." To: "Open: Filter from the SBSExcelUsingFilters folder."

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 On page 93, Change: "Open: Validate from the SBSAccessUsingFilters folder." To: "Open: Validate from the SBSExcelUsingFilters folder."

Microsoft Press  Jul 13, 2010 
Printed
Page 103

Clarification to step 2 On page 103, step 2 does not specify from which folder to open the specified files. Change: "2. Hold down the Ctrl key while you click January.xls, Febraruy.xls, and March.xls, and then click Open." To: "2. Naviate to the SBSExcelMultiple Sources folder, and hold down the Ctrl key while you click January.xls, Febraruy.xls, and March.xls, and then click Open."

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 On page 112, step 2 does not specify from which folder to open the specified files. Change: "Hold down the Ctrl key while you click Consolidate.xls and Y2001ByMonth.xls, and then click Open." To: "Navigate to the SBSExcelMultiple Sources folder, and hold down the Ctrl key while you click Consolidate.xls and Y2001ByMonth.xls, and then click Open."

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 On page 159, there is an inaccuracy in the screenshot for step 13. The cell named "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