xii 6.2.1 Saving an Offi ce Document. . . . . . . . . . .225 6.2.2 Printing an Offi ce Document. . . . . . . . . .228 6.2.3 Opening an Offi ce Document . . . . . . . . .230 6.3.1 Creating and Sorting a List . . . . . . . . . . .235 6.3.2 Inserting a 3D Model . . . . . . . . . . . . . . . .239 6.3.3 Creating a SmartArt Organization Chart . . . . . . . . . . . . . . . . . .242 6.3.4 Manipulating a Media File . . . . . . . . . . .244 6.3.5 Editing a Document . . . . . . . . . . . . . . . . .245 6.3.6 Copying Content Between Documents . . . . . . . . . . . . . . . . .248 6.3.7 Formatting Text . . . . . . . . . . . . . . . . . . . . .251 6.3.8 Format Painter. . . . . . . . . . . . . . . . . . . . . .252 6.4.1 Offi ce Options . . . . . . . . . . . . . . . . . . . . . .261 6.4.2 Offi ce Help . . . . . . . . . . . . . . . . . . . . . . . . .263 Chapter 7 Word-Processing Software 7.1.1 Entering Text . . . . . . . . . . . . . . . . . . . . . . .272 7.1.2 Formatting Text . . . . . . . . . . . . . . . . . . . . .274 7.1.3 Adjusting Margins . . . . . . . . . . . . . . . . . .277 7.1.4 Adjusting Line Spacing . . . . . . . . . . . . . .279 7.1.5 Creating a Style . . . . . . . . . . . . . . . . . . . . .281 7.1.6 Adding a Page Break . . . . . . . . . . . . . . . .283 7.1.7 Creating a Table. . . . . . . . . . . . . . . . . . . . .285 7.1.8 Modifying a Table . . . . . . . . . . . . . . . . . . .286 7.1.9 Creating a Document from a Template .288 7.2.1 Proofi ng Settings . . . . . . . . . . . . . . . . . . . .295 7.2.2 Checking Spelling and Grammar . . . . . .299 Chapter 8 Formal Documents 8.1.1 Creating a Personal Business Letter . . . .316 8.1.2 Formatting a Business Letter. . . . . . . . . .318 8.2.1 Formatting a Report . . . . . . . . . . . . . . . . .331 8.2.2 Adding Page Numbers. . . . . . . . . . . . . . .332 8.2.3 Creating a Table of Contents . . . . . . . . . .334 8.2.4 Adding Citations. . . . . . . . . . . . . . . . . . . .336 8.3.1 Locating Information’s Source . . . . . . . .343 Chapter 9 Presentation Software 9.1.1 Comparing Slide Composition . . . . . . . .358 9.1.2 Adding Slides and Text . . . . . . . . . . . . . .360 9.1.3 Adding Graphics. . . . . . . . . . . . . . . . . . . .362 9.1.4 Applying a Theme . . . . . . . . . . . . . . . . . .365 9.1.5 Reusing Slides . . . . . . . . . . . . . . . . . . . . . .366 9.1.6 Displaying a Presentation . . . . . . . . . . . .369 9.1.7 Managing a Presentation . . . . . . . . . . . . .373 9.2.1 Creating a New Presentation. . . . . . . . . .376 9.2.2 Adding Slide Transitions . . . . . . . . . . . . .378 9.2.3 Adding Animations . . . . . . . . . . . . . . . . .379 9.2.4 Adding a Hyperlink . . . . . . . . . . . . . . . . .381 9.2.5 Inserting a Background Image . . . . . . . .383 9.2.6 Adding a Header and Footer . . . . . . . . .384 9.2.7 Creating a Summary Zoom . . . . . . . . . . .387 9.3.1 Adding a Table . . . . . . . . . . . . . . . . . . . . .390 9.3.2 Adding a Chart . . . . . . . . . . . . . . . . . . . . .393 9.3.3 Adding Speaker Notes . . . . . . . . . . . . . . .396 9.3.4 Printing Handouts . . . . . . . . . . . . . . . . . .399 Chapter 10 Spreadsheet Software 10.1.1 Creating a Spreadsheet. . . . . . . . . . . . . . .412 10.1.2 Editing Data. . . . . . . . . . . . . . . . . . . . . . . .414 10.2.1 Formatting Text . . . . . . . . . . . . . . . . . . . . .418 10.2.2 Formatting Numbers . . . . . . . . . . . . . . . .420 10.2.3 Adjusting Column Width . . . . . . . . . . . .422 10.2.4 Adding Columns. . . . . . . . . . . . . . . . . . . .423 10.2.5 Copying Cells . . . . . . . . . . . . . . . . . . . . . .426 10.2.6 Relative and Absolute Cell Addresses . . . . . . . . . . . . . . . . . . . . . .428 10.2.7 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . .432 Chapter 11 Advanced Spreadsheet Uses 11.1.1 Inserting Functions . . . . . . . . . . . . . . . . . .447 11.1.2 Using Date-Related Functions. . . . . . . . .449 11.1.3 Calculating a Payment . . . . . . . . . . . . . . .452 11.1.4 Using a Logical Function . . . . . . . . . . . . .455 11.2.1 Applying Conditional Formatting . . . . .458 11.2.2 Creating Charts . . . . . . . . . . . . . . . . . . . . .461 11.2.3 Using a Chart in a Document . . . . . . . . .464 Chapter 12 Database Software 12.1.1 Examining a Database . . . . . . . . . . . . . . .479 12.1.2 Adding Data . . . . . . . . . . . . . . . . . . . . . . .479 12.1.3 Editing Data. . . . . . . . . . . . . . . . . . . . . . . .481 12.1.4 Creating a Database . . . . . . . . . . . . . . . . .484 12.2.1 Importing Data . . . . . . . . . . . . . . . . . . . . .489 12.2.2 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . .492 12.2.3 Creating a Form. . . . . . . . . . . . . . . . . . . . .494 12.2.4 Creating a Report . . . . . . . . . . . . . . . . . . .496 12.2.5 Joining Tables. . . . . . . . . . . . . . . . . . . . . . .502 12.3.1 Creating a Simple Query . . . . . . . . . . . . .506 12.3.2 Creating an Advanced Query . . . . . . . . .508 12.3.3 Qualifying a Query. . . . . . . . . . . . . . . . . .511 12.3.4 Creating a Calculated Field . . . . . . . . . . .512 12.3.5 Creating a Statistical Field . . . . . . . . . . . .514