Errata

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

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

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

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

Access should be Excel
On page 85,



Change:

"Open: Filter from the SBSAccessUsingFilters folder."



To:

"Open: Filter from the SBSExcelUsingFilters folder."

Access should be Excel
On page 93,



Change:

"Open: Validate from the SBSAccessUsingFilters folder."



To:

"Open: Validate from the SBSExcelUsingFilters folder."

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

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

Day should be Hour
On page 159, there is an inaccuracy in the screenshot for step 13. The cell named "Day" should be "Hour".

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

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.

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

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

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

Access should be Excel On page 89, Change: "Open: Filter from the SBSAccessUsingFilters folder." To: "Open: Filter from the SBSExcelUsingFilters folder."

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

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

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

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.