Microsoft® Office Specialist Study Guide Office 2003 Edition

Errata for Microsoft® Office Specialist Study Guide Office 2003 Edition




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 31 & 32

Autoformat instructions should be moved to the end of the practice On page 31, the Autoformat instruction section titled "To quickly format an organization chart:" needs to be positioned after the section "To position an organization chart:" 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: "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." To: "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."

Microsoft Press  May 06, 2010 
Printed
Page 39

Incorrect information regarding the behavior of the Enter key On page 39, the last full sentence reads: "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." It should read: "You press the TAB key to move the insertion point from cell to cell across a row."

Microsoft Press  Jul 13, 2010 
Printed
Page 86

Errors in creating a different header and footer for odd and even pages exercise The steps under the exercise "To create a different header and footer for the first page" reads: "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." It should read: "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."

Microsoft Press  May 06, 2010 
Printed
Page 87

Errors in creating a different header and footer for odd and even pages exercise On page 87, the steps under the exercise "To create a different header and footer for odd and even pages" currently reads:"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." They should read: "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."

Microsoft Press  Jul 13, 2010 
Printed
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: "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." To: "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%."

Microsoft Press  May 06, 2010 
Printed
Page 353

Practice Exercise description is incorrect On page 353, under Practice Exercise, the current exercise description reads: "In this exercise, you will use the DMIN function to find the smallest sale with a profit margin over $100."It should read: "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."

Microsoft Press  Jul 13, 2010 
Printed
Page 355

Data menu referenced in place of Tools menu On page 355, step 3 of the "To trace an error:" process reads: "On the Data menu, click Formula Auditing and then Remove All Arrows to turn off the arrows." It should read: "On the Tools menu, click Formula Auditing and then Remove All Arrows to turn off the arrows."

Microsoft Press  May 06, 2010 
Printed
Page 356

Data menu referenced in place of Tools menu On page 356, step 4 at the top of the page reads: "On the Data menu, click Formula Auditing and then Remove All Arrows to turn off the arrows." It should read: "On the Tools menu, click Formula Auditing and then Remove All Arrows to turn off the arrows."

Microsoft Press  Jul 13, 2010 
Printed
Page 408

Incorrect description of practice purpose On page 408, the first sentence of the Practice Exercise section reads: "In this exercise, you will export a worksheet’s information as an XML data file." This is incorrect and should be disregarded.

Microsoft Press  May 06, 2010 
Printed
Page 413

PivotChart referred to as PicotChart On page 413, the third sentence of the second paragraph of the Practice Exercise section reads: "Then display the PivotTable and PicotChart Report button." It should read: "Then display the PivotTable and PivotChart Report button." 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  Jul 13, 2010