Page 350 - Excel Workbook for Dummies

41_798452 appb.qxp 3/13/06 7:33 PM Page 333
Appendix B: Table of Exercises 333

Exercise Name Page Number

Exercise 16-7: Filtering the Records in a Data List 214
Exercise 16-8: Querying an External Data Table 216
Chapter 17: Protecting the Spreadsheet
Exercise 17-1: Assigning a Password for Opening and Editing a Workbook 222

Exercise 17-2: Protecting a Worksheet 225
Exercise 17-3: Doing Data Entry in a Protected Worksheet 227
Exercise 17-4: Protecting the Entire Workbook 229
Chapter 18: Doing What-If Analysis

Exercise 18-1: Constructing a One-Variable Data Table in a Spreadsheet 234
Exercise 18-2: Constructing a Two-Variable Data Table in a Spreadsheet 236
Exercise 18-3: Constructing Various Scenarios for the Spreadsheet 238
Exercise 18-4: Doing Goal Seeking in a Spreadsheet 240

Exercise 18-5: Using Solver to Modify Multiple Input Values in a Spreadsheet 242
Chapter 19: Generating Pivot Tables
Exercise 19-1: Modifying an Existing Pivot Table 245
Exercise 19-2: Creating a New Pivot Table 249

Exercise 19-3: Modifying the Formatting in a Pivot Table 250
Exercise 19-4: Modifying the Structure of a Pivot Table 251
Exercise 19-5: Modifying the Summary Functions and Adding a Calculated
Field to a Pivot Table 253
Exercise 19-6: Creating a Pivot Chart 255
Chapter 20: Publishing Spreadsheets as Web Pages
Exercise 20-1: Saving a Spreadsheet as a Static Web Page 262
Exercise 20-2: Creating a Web Page with an Interactive Data Table 265

Exercise 20-3: Creating a Web Page with an Interactive Data List 266
Exercise 20-4: Creating a Web Page with an Interactive Pivot Table 267
Exercise 20-5: Creating a Web Page with an Interactive Chart 268

Exercise 20-6: Exporting the Spreadsheet Data in a Web Page Back to Excel 270
Exercise 20-7: Importing Web Data into Excel with a Web Query 271
Chapter 21: Adding Hyperlinks to Spreadsheets
Exercise 21-1: Adding Hyperlinks to Other Sheets in a Workbook 274
Exercise 21-2: Adding Hyperlinks to Other Documents 276

Exercise 21-3: Adding Hyperlinks to Web Pages and E-mail Addresses 277
Exercise 21-4: Assigning Hyperlinks to Custom Menus and Toolbars 279
(continued)