1 Chapter 5 Word-Processing Software 5.1.1 Entering Text . . . . . . . . . . . . . . . . . . . . . . 162 5.1.2 Formatting Text . . . . . . . . . . . . . . . . . . . . 164 5.1.3 Adjusting Margins . . . . . . . . . . . . . . . . . . 167 5.1.4 Adjusting Line Spacing . . . . . . . . . . . . . . 169 5.1.5 Creating a Style . . . . . . . . . . . . . . . . . . . . 171 5.1.6 Adding a Page Break . . . . . . . . . . . . . . . . 173 5.1.7 Creating a Table . . . . . . . . . . . . . . . . . . . . 175 5.1.8 Modifying a Table . . . . . . . . . . . . . . . . . . 176 5.1.9 Creating a Document from a Template . . . 178 5.2.1 Proofing Settings . . . . . . . . . . . . . . . . . . . 185 5.2.2 Checking Spelling and Grammar . . . . . . . 189 Chapter 6 Formal Documents 6.1.1 Creating a Personal Business Letter . . . . . 206 6.1.2 Formatting a Business Letter . . . . . . . . . . 208 6.2.1 Formatting a Report . . . . . . . . . . . . . . . . 221 6.2.2 Adding Page Numbers . . . . . . . . . . . . . . 222 6.2.3 Creating a Table of Contents . . . . . . . . . . 224 6.2.4 Adding Citations . . . . . . . . . . . . . . . . . . . 226 6.3.1 Locating Information’s Source . . . . . . . . . 233 Chapter 7 Presentation Software 7.1.1 Comparing Slide Composition . . . . . . . . . 248 7.1.2 Adding Slides and Text . . . . . . . . . . . . . . 250 7.1.3 Adding Graphics . . . . . . . . . . . . . . . . . . . 252 7.1.4 Applying a Theme . . . . . . . . . . . . . . . . . . 255 7.1.5 Reusing Slides . . . . . . . . . . . . . . . . . . . . . 256 7.1.6 Displaying a Presentation . . . . . . . . . . . . . 259 7.1.7 Managing a Presentation . . . . . . . . . . . . . 263 7.2.1 Creating a New Presentation . . . . . . . . . . 266 7.2.2 Adding Slide Transitions . . . . . . . . . . . . . 268 7.2.3 Adding Animations . . . . . . . . . . . . . . . . . 269 7.2.4 Adding a Hyperlink . . . . . . . . . . . . . . . . . 271 7.2.5 Inserting a Background Image . . . . . . . . . 273 7.2.6 Adding a Header and Footer . . . . . . . . . 274 7.2.7 Creating a Summary Zoom . . . . . . . . . . . 277 7.3.1 Adding a Table . . . . . . . . . . . . . . . . . . . . 280 7.3.2 Adding a Chart . . . . . . . . . . . . . . . . . . . . 283 7.3.3 Adding Speaker Notes . . . . . . . . . . . . . . 286 7.3.4 Printing Handouts . . . . . . . . . . . . . . . . . . 289 Chapter 8 Spreadsheet Software 8.1.1 Creating a Spreadsheet . . . . . . . . . . . . . . 302 8.1.2 Editing Data . . . . . . . . . . . . . . . . . . . . . . . 305 8.2.1 Formatting Text . . . . . . . . . . . . . . . . . . . . 308 8.2.2 Formatting Numbers . . . . . . . . . . . . . . . . 310 8.2.3 Adjusting Column Width . . . . . . . . . . . . . 312 8.2.4 Adding Columns . . . . . . . . . . . . . . . . . . . 313 8.2.5 Copying Cells. . . . . . . . . . . . . . . . . . . . . . 316 8.2.6 Relative and Absolute Cell Addresses . . . 318 8.2.7 Sorting Data . . . . . . . . . . . . . . . . . . . . . . 322 Chapter 9 Advanced Spreadsheet Uses 9.1.1 Inserting Functions . . . . . . . . . . . . . . . . . . 337 9.1.2 Using Date-Related Functions . . . . . . . . . 339 9.1.3 Calculating a Payment . . . . . . . . . . . . . . . 342 9.1.4 Using a Logical Function . . . . . . . . . . . . . 345 9.2.1 Applying Conditional Formatting . . . . . . . 348 9.2.2 Creating Charts . . . . . . . . . . . . . . . . . . . . 351 9.2.3 Using a Chart in a Document . . . . . . . . . . 354 Chapter 10 Database Software 10.1.1 Examining a Database . . . . . . . . . . . . . . 369 10.1.2 Adding Data . . . . . . . . . . . . . . . . . . . . . 369 10.1.3 Editing Data . . . . . . . . . . . . . . . . . . . . . . 371 10.1.4 Creating a Database . . . . . . . . . . . . . . . . 374 10.2.1 Importing Data . . . . . . . . . . . . . . . . . . . 379 10.2.2 Sorting Data . . . . . . . . . . . . . . . . . . . . . 382 10.2.3 Creating a Form . . . . . . . . . . . . . . . . . . . 384 10.2.4 Creating a Report . . . . . . . . . . . . . . . . . 386 10.2.5 Joining Tables . . . . . . . . . . . . . . . . . . . . 392 10.3.1 Creating a Simple Query . . . . . . . . . . . . 396 10.3.2 Creating an Advanced Query . . . . . . . . 398 10.3.3 Qualifying a Query . . . . . . . . . . . . . . . . 401 10.3.4 Creating a Calculated Field . . . . . . . . . . 402 10.3.5 Creating a Statistical Field . . . . . . . . . . . 404 Chapter 11 Personal Information Management Software 11.1.1 Adding an Account to Outlook . . . . . . . 416 11.1.2 Creating a New Contact Group . . . . . . . 422 11.1.3 Adding a Signature to Outlook Messages . . . . . . . . . . . . . . . 425 11.2.1 Add a New Calendar to Outlook . . . . . 440 11.2.2 Add a Task to Outlook . . . . . . . . . . . . . 442