Microsoft KB Archive/917621

= Microsoft Office Specialist Study Guide Office 2003 Edition comments and corrections =

Article ID: 917621

Article Last Modified on 7/25/2007

-

APPLIES TO


 * Microsoft Office Specialist Study Guide Office 2003 Edition, ISBN 0-7356-2110-1

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft Office Specialist Study Guide Office 2003 Edition, 0-7356-2110-1.

The following topics are covered:


 * Pages 31 & 32: Autoformat instructions should be moved to the end of the practice
 * Page 39: Incorrect information regarding the behavior of the Enter key
 * Page 86: Errors in creating a different header and footer for odd and even pages exercise
 * Page 87: Errors in creating a different header and footer for odd and even pages exercise
 * Page 343: =PMT(B5/12,B6,B4) should be =PMT(D8/12,E8,B4) and several % symbols are missing
 * Page 353: Practice Exercise description is incorrect
 * Page 355: Data menu referenced in place of Tools menu
 * Page 356: Data menu referenced in place of Tools menu
 * Page 408: Incorrect description of practice purpose
 * Page 413: PivotChart referred to as PicotChart



Pages 31 & 32: Autoformat instructions should be moved to the end of the practice
On page 31, the Autoformat instruction section titled &quot;To quickly format an organization chart:&quot; needs to be positioned after the section &quot;To position an organization chart:&quot; on page 32.

On page 32, in the Practice Exercise instructions at the bottom of the page the Autoformat instructions need to be moved to the end of the paragraph.

Change:

&quot;Open the InsertOrgChart document. Move to the end of the document, and use the Insert Diagram or Organization Chart button on the Drawing toolbar to add an organization chart to the document. Then type Karen Berg in the top box and Kim Akers, David Ortiz, and Gordon Hee in the boxes in the second row. On the Organization Chart toolbar, click the Autoformat button, and select the Beveled style. Select all the connecting lines, display the Format AutoShape dialog box, and change the color of the lines to red. Then attach arrows to the lines. Deselect the organization chart, and then close the InsertOrgChart document without saving it.&quot;

To:

&quot;Open the InsertOrgChart document. Move to the end of the document, and use the Insert Diagram or Organization Chart button on the Drawing toolbar to add an organization chart to the document. Then type Karen Berg in the top box and Kim Akers, David Ortiz, and Gordon Hee in the boxes in the second row. Select all the connecting lines, display the Format AutoShape dialog box, and change the color of the lines to red. Then attach arrows to the lines. On the Organization Chart toolbar, click the Autoformat button, and select the Beveled style. Deselect the organization chart, and then close the InsertOrgChart document without saving it.&quot;

Page 39: Incorrect information regarding the behavior of the Enter key
On page 39, the last full sentence reads:

&quot;You press the ENTER key to move the insertion point from cell to cell down a column and the TAB key to move across a row.&quot;

It should read:

&quot;You press the TAB key to move the insertion point from cell to cell across a row.&quot;

Page 86: Errors in creating a different header and footer for odd and even pages exercise
The steps under the exercise &quot;To create a different header and footer for the first page&quot; reads:

&quot;1. With the insertion point to the beginning of the document, click Header and Footer on the View menu.

2. On the Header and Footer toolbar, click the Page Setup button, and in the Page Setup dialog box, click the Layout tab.

3. In the Headers and footers area, select the Different first page check box, and click OK.

4. Enter and format the header and footer, or leave them blank if you don’t want a header or footer on the first page.

5. On the Header and Footer toolbar, click the Show Next button. Word moves to the header or footer for the second page of the document. By default, this header or footer is the same as the previous one.

6. On the Header and Footer toolbar, click the Link to Previous button to toggle it off.

7. Enter and format a different header and footer for subsequent pages of the document.

8. On the Header and Footer toolbar, click Close to return to the document.&quot;

It should read:

&quot;1. With the insertion point at the beginning of the document, click Header and Footer on the View menu.

2. On the Header and Footer toolbar, click the Page Setup button, and in the Page Setup dialog box, click the Layout tab.

3. In the Headers and footers area, select the Different first page check box, and click OK.

4. Enter and format the header and footer, or leave them blank if you don’t want a header or footer on the first page.

5. On the Header and Footer toolbar, click the Show Next button. Word moves to the header or footer for the second page of the document.

6. Enter and format a different header and footer for subsequent pages of the document.

7. On the Header and Footer toolbar, click Close to return to the document.&quot;

Page 87: Errors in creating a different header and footer for odd and even pages exercise
On page 87, the steps under the exercise &quot;To create a different header and footer for odd and even pages&quot; currently reads:

&quot;1. With the insertion point at the beginning of the document, click Header and Footer on the View menu.

2. On the Header and Footer toolbar, click the Page Setup button, and in the Page Setup dialog box, click the Layout tab.

3. In the Headers and footers area, select the Different odd and even check box, and click OK.

4. Enter and format the header and footer for the first (odd-numbered) page.

5. On the Header and Footer toolbar, click the Show Next button. Word moves to the header or footer for the second (even-numbered) page of the document. By default, this header or footer is the same as the previous one.

6. On the Header and Footer toolbar, click the Link to Previous button to toggle it off.

7. Enter and format a different header and footer for the even-numbered pages of the document.

8. On the Header and Footer toolbar, click Close to return to the document.&quot;

They should read:

&quot;1. With the insertion point at the beginning of the document, click Header and Footer on the View menu.

2. On the Header and Footer toolbar, click the Page Setup button, and in the Page Setup dialog box, click the Layout tab.

3. In the Headers and footers area, select the Different odd and even check box, and click OK.

4. Enter and format the header and footer for the first (odd-numbered) page.

5. On the Header and Footer toolbar, click the Show Next button. Word moves to the header or footer for the second (even-numbered) page of the document.

6. Enter and format a different header and footer for the even-numbered pages of the document.

7. On the Header and Footer toolbar, click Close to return to the document.&quot;

Page 343: =PMT(B5/12,B6,B4) should be =PMT(D8/12,E8,B4) and several % symbols are missing
On page 343, some of the instructions in the Practice Exercise section are incorrect.

Change:

&quot;In cell D9, enter the following formula: =PMT(B5/12,B6,B4). Then enter the following loan terms in cells E9:H9: 36, 48, 60, 72. In cells D10:D15, enter the following interest rates: 6.0, 6.5, 7.0, 7.5, 8.0, 8.5.&quot;

To:

&quot;In cell D9, enter the following formula: =PMT(D8/12,E8,B4). Then enter the following loan terms in cells E9:H9: 36, 48, 60, 72. In cells D10:D15, enter the following interest rates: 6.0%, 6.5%, 7.0%, 7.5%, 8.0%, 8.5%.&quot;

Page 353: Practice Exercise description is incorrect
On page 353, under Practice Exercise, the current exercise description reads:

&quot;In this exercise, you will use the DMIN function to find the smallest sale with a profit margin over $100.&quot;

It should read:

&quot;In this exercise, you will use the DSUM Database function to report the total amount of sales resulting in a profit of more than $1000 per sale.&quot;

Page 355: Data menu referenced in place of Tools menu
On page 355, step 3 of the &quot;To trace an error:&quot; process reads:

&quot;On the Data menu, click Formula Auditing and then Remove All Arrows to turn off the arrows.&quot;

It should read:

&quot;On the Tools menu, click Formula Auditing and then Remove All Arrows to turn off the arrows.&quot;

Page 356: Data menu referenced in place of Tools menu
On page 356, step 4 at the top of the page reads:

&quot;On the Data menu, click Formula Auditing and then Remove All Arrows to turn off the arrows.&quot;

It should read:

&quot;On the Tools menu, click Formula Auditing and then Remove All Arrows to turn off the arrows.&quot;

Page 408: Incorrect description of practice purpose
On page 408, the first sentence of the Practice Exercise section reads:

&quot;In this exercise, you will export a worksheet’s information as an XML data file.&quot;

This is incorrect and should be disregarded.

Page 413: PivotChart referred to as PicotChart
On page 413, the third sentence of the second paragraph of the Practice Exercise section reads:

&quot;Then display the PivotTable and PicotChart Report button.&quot;

It should read:

&quot;Then display the PivotTable and PivotChart Report button.&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-2110-1

Keywords: KB917621

-

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

© Microsoft Corporation. All rights reserved.