Page 347 - Excel Workbook for Dummies

41_798452 appb.qxp 3/13/06 7:33 PM Page 330
330 Excel Workbook For Dummies

Table B-1 (continued)

Exercise Name Page Number
Chapter 3: Printing Spreadsheet Reports
Exercise 3-1: Previewing a Printed Report 37
Exercise 3-2: Paging a Report with Page Break Preview 38
Exercise 3-3: Creating a Custom Header and Footer for a Report 40

Exercise 3-4: Adding Print Titles to a Report 41
Exercise 3-5: Changing the Print Settings for a Report 43
Exercise 3-6: Printing a Particular Range of Worksheet Data 44

Exercise 3-7: Printing the Entire Workbook 45
Exercise 3-8: Printing a Chart in a Report 46
Exercise 3-9: Printing the Formulas in a Spreadsheet 47
Chapter 4: Modifying the Spreadsheet
Exercise 4-1: Adding Summary Information to a Workbook 50

Exercise 4-2: Searching for the Workbook to Edit 52
Exercise 4-3: Using the Various Options for Opening a Workbook 53
Exercise 4-4: Using Zoom, Freeze Panes, and Custom Views 54

Exercise 4-5: Selecting the Range of Cells for Editing 56
Exercise 4-6: Editing Cell Entries 58
Exercise 4-7: Verifying Data Entries with Text to Speech 58
Exercise 4-8: Deleting and Inserting Cells in the Spreadsheet 60
Exercise 4-9: Moving and Copying Cells in the Spreadsheet 62

Exercise 4-10: Adding Comments to the Spreadsheet 64
Exercise 4-11: Editing with Find and Replace and Spell Checking 66
Exercise 4-12: Editing Different Worksheets as a Group 69

Chapter 5: Building Formulas
Exercise 5-1: Building Arithmetic Formulas 75
Exercise 5-2: Building Comparative Formulas 76
Exercise 5-3: Working with Error Values in Formulas 77
Exercise 5-4: Building Formulas with AutoSum 80

Exercise 5-5: Editing Formulas in the Spreadsheet 81
Exercise 5-6: Changing the Order in Which Formulas Are Calculated 83
Exercise 5-7: Building Formulas with External Links 85

Exercise 5-8: Controlling When Formulas Are Recalculated 86