Microsoft KB Archive/912893

= Microsoft Office Excel 2003 Step By Step Comments and Corrections =

Article ID: 912893

Article Last Modified on 6/29/2006

-

APPLIES TO


 * Microsoft Office Excel 2003 Step By Step, ISBN 0-7356-1518-7

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft Office Excel 2003 Step By Step, 0-7356-1518-7.

The following topics are covered:


 * Pages 17 and 18: &quot;Cushy&quot; should be &quot;Comfy&quot;, &quot;Comfy&quot; should be &quot;Cushy&quot;
 * Page 20: &quot;47.95&quot; should be &quot;44.95&quot;, &quot;44.95&quot; should be &quot;47.95&quot;
 * Page 30: Cells are already Merged and Centered in Easier.xls
 * Page 35: &quot;SettingUpWorkbook folder&quot; should be &quot;ChangingDocAppearance folder&quot;
 * Page 37: &quot;tab page&quot; should be &quot;Size tab&quot;
 * Page 37: &quot;SettingUpWorkbook folder&quot; should be &quot;ChangingDocAppearance folder&quot;
 * Page 48: &quot;=SUM&quot; should be &quot;=SUM(&quot;
 * Page 49: Correction to step 4
 * Page 63: Normal should be Emphasis
 * Page 85: Access should be Excel
 * Page 89: Access should be Excel
 * Page 93: Access should be Excel
 * Page 109: Update should be Edit Links
 * Page 103: Clarification to step 2
 * Page 108: Clarification to step 2
 * Page 112: Clarification to step 2
 * Page 114: Clarification to step 2
 * Page 159: Day should be Hour



Pages 17 and 18: &quot;Cushy&quot; should be &quot;Comfy&quot;, &quot;Comfy&quot; should be &quot;Cushy&quot;
On pages 17 and 18, the exercise instructs to replace all instances of the word &quot;Comfy&quot; with the word &quot;Cushy&quot; in the file Replace.xls. This is incorrect. It instead should instruct to replace all instances of of the word &quot;Cushy&quot; with the word &quot;Comfy&quot;.

Please transpose all references of the two words on the two pages.

Page 20: &quot;47.95&quot; should be &quot;44.95&quot;, &quot;44.95&quot; should be &quot;47.95&quot;
On page 20,

Change:

&quot;18. Type 47.95 and press ENTER&quot; ....

19. On the Standard toolbar, click the Undo button. The contents of cell C12 revert to 44.95&quot;

To:

&quot;18. Type 44.95 and press ENTER&quot; ....

19. On the Standard toolbar, click the Undo button. The contents of cell C12 revert to 47.95&quot;

Page 30: Cells are already Merged and Centered in Easier.xls
On page 30, steps 16 and 17 instruct to &quot;Merge and Center&quot; cells E2 through G2 in the file Easier.xls. However, those cells are already merged and centered in the file.

Please click &quot;Merge and Center&quot; to unmerge them first, then follow steps 16 and 17 to merge the cells as described.

Page 35: &quot;SettingUpWorkbook folder&quot; should be &quot;ChangingDocAppearance folder&quot;
On page 35, in step 3,

Change:

&quot;3. If necessary, navigate to the SettingUpWorkbook folder and then double-click tgc_logo.gif.&quot;

To:

&quot;3. If necessary, navigate to the ChangingDocAppearance folder and then double-click tgc_logo.gif.&quot;

Page 37: &quot;tab page&quot; should be &quot;Size tab&quot;
On page 37, in step 6,

Change:

&quot;6. In the Scale section of the tab page...&quot;

To:

&quot;6. In the Scale section of the Size tab...&quot;

Page 37: &quot;SettingUpWorkbook folder&quot; should be &quot;ChangingDocAppearance folder&quot;
On page 37, in step 16,

Change:

&quot;3. If necessary, navigate to the SettingUpWorkbook folder and then double-click tgc_logo.gif.&quot;

To:

&quot;3. If necessary, navigate to the ChangingDocAppearance folder and then double-click tgc_logo.gif.&quot;

Page 48: &quot;=SUM&quot; should be &quot;=SUM(&quot;
On page 48,

Change:

&quot;2. In the formula bar, type = SUM, drag from cell D4 to D5, and press ENTER.&quot;

To:

&quot;2. In the formula bar, type = SUM(, drag from cell D4 to D5, and press ENTER.&quot;

Page 49: Correction To Step 4
On page 49,

Change:

&quot;4. The value $18.95 appears in cell D8, and =SUM(D5:D6) appears in the formula bar.&quot;

To:

&quot;4. The value $63.90 appears in cell D8, and =SUM(OrderItems) appears in the formula bar.&quot;

Page 63: Normal should be Emphasis
On page 63, in step 3,

Change:

&quot;The Style dialog box appears, with Normal in the Style name box.&quot;

To:

&quot;The Style dialog box appears, with Emphasis in the Style name box.&quot;

Page 85: Access should be Excel
On page 85,

Change:

&quot;Open: Filter from the SBS\Access\UsingFilters folder.&quot;

To:

&quot;Open: Filter from the SBS\Excel\UsingFilters folder.&quot;

Page 89: Access should be Excel
On page 89,

Change:

&quot;Open: Filter from the SBS\Access\UsingFilters folder.&quot;

To:

&quot;Open: Filter from the SBS\Excel\UsingFilters folder.&quot;

Page 93: Access should be Excel
On page 93,

Change:

&quot;Open: Validate from the SBS\Access\UsingFilters folder.&quot;

To:

&quot;Open: Validate from the SBS\Excel\UsingFilters folder.&quot;

Page 109: Update should be Edit Links
On page 109, in step 16,

Change:

&quot;16. In the alert box, click Update.&quot;

To:

&quot;16. In the alert box, click Edit Links.&quot;

Page 103: Clarification to step 2
On page 103, step 2 does not specify from which folder to open the specified files.

Change:

&quot;2. Hold down the Ctrl key while you click January.xls, Febraruy.xls, and March.xls, and then click Open.&quot;

To:

&quot;2. Naviate to the SBS\Excel\Multiple Sources folder, and hold down the Ctrl key while you click January.xls, Febraruy.xls, and March.xls, and then click Open.&quot;

Page 108: Clarification to step 2
On page 108, step 2 does not specify from which folder to open the specified files.

Change:

&quot;2. Hold down the Ctrl key while you click Linking.xls and 2001Q1.xls files, and then click Open.&quot;

To:

&quot;2. Naviate to the SBS\Excel\Multiple Sources folder, and hold down the Ctrl key while you click Linking.xls and 2001Q1.xls files, and then click Open.&quot;

Page 112: Clarification to step 2
On page 112, step 2 does not specify from which folder to open the specified files.

Change:

&quot;Hold down the Ctrl key while you click Consolidate.xls and Y2001ByMonth.xls, and then click Open.&quot;

To: &quot;Navigate to the SBS\Excel\Multiple Sources folder, and hold down the Ctrl key while you click Consolidate.xls and Y2001ByMonth.xls, and then click Open.&quot;

Page 114: Clarification to step 2
On page 114, step 2 does not specify from which folder to open the specified files.

Change:

&quot;2. Hold down the Ctrl key while you click the Y2001ByMonth.xls and TotalByHour2001.xls files, and then click Open.&quot;

To:

&quot;2. Navigate to the SBS\Excel\Multiple Sources folder, and hold down the Ctrl key while you click the Y2001ByMonth.xls and TotalByHour2001.xls files, and then click Open.&quot;

Page 159: Day should be Hour
On page 159, there is an inaccuracy in the screenshot for step 13. The cell named &quot;Day&quot; should be &quot;Hour&quot;.

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: &quot;2 3 4 5 6 7 8 0 QWT 9 8 76 5 4&quot;. The first number in the string is the the print number. In this example, the print number is 2.

Additional query words: 0-7356-1518-7 978-0-7356-1518-2 0-7356-1520-9 978-0-7356-1520-5

Keywords: kbdocfix kbdocerr KB912893

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.