Errata

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."

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."

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."

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."

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.

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."

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."

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."

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.