Page 349 - Excel Workbook for Dummies

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

Table B-1 (continued)

Exercise Name Page Number
Exercise 11-2: Building Formulas that Perform Vertical Lookups in a Table 145
Exercise 11-3: Using the Lookup Wizard to Build Formulas that Perform
Two-Way Lookups in a Table 147

Chapter 12: Using the Logical Functions
Exercise 12-1: Using the IF Function to Build Formulas that Select
Alternate Values 151

Exercise 12-2: Using the IF Function to Build Formulas that Perform
Alternate Calculations 154
Exercise 12-3: Building Formulas with Nested IF Functions 155
Exercise 12-4: Building Formulas that Trap Error Values 157

Chapter 13: Text Formulas and Functions
Exercise 13-1: Building Simple Text Formulas that Join Data Entries 162
Exercise 13-2: Building Formulas with Text Functions that Join Data Entries
and Change Their Case 165
Chapter 14: Charting Spreadsheet Data
Exercise 14-1: Changing the Location of Existing Charts 174
Exercise 14-2: Creating a New Embedded Chart 176
Exercise 14-3: Making Formatting Changes to a Chart 180

Exercise 14-4: Editing the Structure, Contents, and Location of a Chart 182
Chapter 15: Adding Graphics to the Spreadsheet
Exercise 15-1: Resizing and Grouping Graphic Objects 187

Exercise 15-2: Adding Clip Art to a Spreadsheet 190
Exercise 15-3: Importing Images from Graphics Files into a Spreadsheet 193
Exercise 15-4: Creating and Adding Graphics with the Drawing Toolbar 195
Exercise 15-5: Adding Text Boxes to a Spreadsheet 197
Exercise 15-6: Constructing WordArt in a Spreadsheet 199

Chapter 16: Building and Maintaining Data Lists
Exercise 16-1: Constructing a New Data List and Adding Records with
the Data Form 204

Exercise 16-2: Finding and Editing Records with the Data Form 206
Exercise 16-3: Sorting the Records in a Data List 208
Exercise 16-4: Sorting the Records in a Data List on More Than Three Keys 209
Exercise 16-5: Sorting the Fields in a Data List 210

Exercise 16-6: Subtotaling the Records in a Data List 211