1
Copyright Goodheart-Willcox Co., Inc.
7.1.5 Reusing Slides. . . . . . . . . . . . . . . . . . . . . .250
7.1.6 Displaying a Presentation . . . . . . . . . . . . .253
7.1.7 Managing a Presentation . . . . . . . . . . . . .256
7.2.1 Creating a New Presentation . . . . . . . . . .260
7.2.2 Adding Slide Transitions . . . . . . . . . . . . . .262
7.2.3 Adding Animations. . . . . . . . . . . . . . . . . .263
7.2.4 Adding a Hyperlink. . . . . . . . . . . . . . . . . .265
7.2.5 Inserting a Background Image. . . . . . . . . .266
7.2.6 Adding a Header and Footer . . . . . . . . . .268
7.3.1 Adding a Table . . . . . . . . . . . . . . . . . . . . .272
7.3.2 Adding a Chart . . . . . . . . . . . . . . . . . . . . .275
7.3.3 Adding Speaker Notes . . . . . . . . . . . . . . .278
7.3.4 Printing Handouts. . . . . . . . . . . . . . . . . . .280
Chapter 8
Spreadsheet Software
8.1.1 Creating a Spreadsheet . . . . . . . . . . . . . .293
8.1.2 Editing Data . . . . . . . . . . . . . . . . . . . . . . .296
8.2.1 Formatting Text. . . . . . . . . . . . . . . . . . . . .299
8.2.2 Formatting Numbers. . . . . . . . . . . . . . . . .301
8.2.3 Adjusting Column Width. . . . . . . . . . . . . .303
8.2.4 Adding Columns. . . . . . . . . . . . . . . . . . . .304
8.2.5 Copying Cells . . . . . . . . . . . . . . . . . . . . . .307
8.2.6 Relative and Absolute Cell Addresses. . . .309
8.2.7 Sorting Data . . . . . . . . . . . . . . . . . . . . . . .313
Chapter 9
Advanced Spreadsheet Uses
9.1.1 Inserting Functions . . . . . . . . . . . . . . . . . .327
9.1.2 Using Date-Related Functions . . . . . . . . . .329
9.1.3 Calculating a Payment. . . . . . . . . . . . . . . .332
9.1.4 Using a Logical Function . . . . . . . . . . . . . .334
9.2.1 Applying Conditional Formatting . . . . . . .337
9.2.2 Creating Charts . . . . . . . . . . . . . . . . . . . . .340
9.2.3 Using a Chart in a Document. . . . . . . . . . .343
Chapter 10
Database Software
10.1.1 Examining a Database. . . . . . . . . . . . . . .357
10.1.2 Adding Data . . . . . . . . . . . . . . . . . . . . . .357
10.1.3 Editing Data . . . . . . . . . . . . . . . . . . . . . .359
10.1.4 Creating a Database . . . . . . . . . . . . . . . .362
10.2.1 Importing Data . . . . . . . . . . . . . . . . . . . .367
10.2.2 Sorting Data . . . . . . . . . . . . . . . . . . . . . .370
10.2.3 Creating a Form . . . . . . . . . . . . . . . . . . .371
10.2.4 Creating a Report . . . . . . . . . . . . . . . . . .374
10.2.5 Joining Tables. . . . . . . . . . . . . . . . . . . . .378
10.3.1 Creating a Simple Query. . . . . . . . . . . . .382
10.3.2 Creating an Advanced Query . . . . . . . . .384
10.3.3 Qualifying a Query . . . . . . . . . . . . . . . . .387
10.3.4 Creating a Calculated Field . . . . . . . . . . .388
10.3.5 Creating a Statistical Field. . . . . . . . . . . .390