viii Section 9.2 Adding Transitions and Animations. . . . . . . . . . . . . . . . . . . . . . . . 374 Creating a New Presentation . . . . . . . . . . . . . .375 Advanced Features . . . . . . . . . . . . . . . . . . . . . .377 Section 9.3 Charts, Tables, and Handouts . . . 388 Creating Tables. . . . . . . . . . . . . . . . . . . . . . . . . .389 Creating Charts . . . . . . . . . . . . . . . . . . . . . . . . .391 Creating Speaker Notes . . . . . . . . . . . . . . . . . .395 Creating Handouts . . . . . . . . . . . . . . . . . . . . . .397 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 400 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 400 Application and Extension of Knowledge. . . . 401 Chapter 10 Spreadsheet Software . .404 Section 10.1 Introduction to Spreadsheets . . 406 Origin of Spreadsheets . . . . . . . . . . . . . . . . . . .407 Using Spreadsheets . . . . . . . . . . . . . . . . . . . . . .407 Entering Data . . . . . . . . . . . . . . . . . . . . . . . . . . .409 Using Formulas . . . . . . . . . . . . . . . . . . . . . . . . .411 Editing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . .413 Section 10.2 Managing Data in Spreadsheets. . 416 Customizing the Appearance. . . . . . . . . . . . . .417 Changing Data Locations . . . . . . . . . . . . . . . . .424 Rearranging Data. . . . . . . . . . . . . . . . . . . . . . . .426 Locating, Organizing, and Viewing Data. . . .429 Printing a Spreadsheet . . . . . . . . . . . . . . . . . . .434 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 438 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 438 Application and Extension of Knowledge. . . . 439 Chapter 11 Advanced Spreadsheet Uses . . . .442 Section 11.1 Calculating with Functions . . . . . 444 Using Functions . . . . . . . . . . . . . . . . . . . . . . . . .445 Complex Financial Formulas . . . . . . . . . . . . . .451 Logical Functions. . . . . . . . . . . . . . . . . . . . . . . .453 Section 11.2 Visual Enhancements of Data . . . 456 Conditional Formatting . . . . . . . . . . . . . . . . . .457 Charts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .459 Spreadsheet Charts in Text Documents . . . . .462 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .465 Comma-Separated Values Files . . . . . . . . . . . .466 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 468 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 468 Application and Extension of Knowledge. . . . 469 Chapter 12 Database Software. . . .472 Section 12.1 Introduction to Databases. . . . . 474 Overview of Databases . . . . . . . . . . . . . . . . . . .475 Examining a Database. . . . . . . . . . . . . . . . . . . .478 Creating a Database Structure . . . . . . . . . . . . .481 Section 12.2 Importing and Viewing Data . . . 487 Importing Records into a Database. . . . . . . . .488 Securing a Database. . . . . . . . . . . . . . . . . . . . . .488 Viewing Data . . . . . . . . . . . . . . . . . . . . . . . . . . .490 Joining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . .498 Section 12.3 Queries . . . . . . . . . . . . . . . . . . . 504 Locating Data . . . . . . . . . . . . . . . . . . . . . . . . . . .505 Creating Calculated Fields . . . . . . . . . . . . . . . .511 Creating Statistical Fields . . . . . . . . . . . . . . . . .513 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 516 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 516 Application and Extension of Knowledge. . . . 517 Chapter 13 Personal Information Management Software. .520 Section 13.1 Electronic Mail . . . . . . . . . . . . . . 522 E-mail Technologies. . . . . . . . . . . . . . . . . . . . . .523 E-mail Account Settings . . . . . . . . . . . . . . . . . .524 Appropriate E-mail Use . . . . . . . . . . . . . . . . . .527 Managing E-mail Communication . . . . . . . . .533 Section 13.2 Using Personal Information Management Software. . . . . . . . . 539 Outlook Interface . . . . . . . . . . . . . . . . . . . . . . . .540 Managing Messages . . . . . . . . . . . . . . . . . . . . .543 Managing Schedules . . . . . . . . . . . . . . . . . . . . .546 Managing Contacts . . . . . . . . . . . . . . . . . . . . . .550 Managing Tasks . . . . . . . . . . . . . . . . . . . . . . . . .551 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 554 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 554 Application and Extension of Knowledge. . . . 555 Chapter 14 Internet and the World Wide Web . . . . .560 Section 14.1 Internet and the World Wide Web. . . . . . . . . . . . . . . . . . . . 562 Internet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .563 Unit 3 Living Online . . . . . . . . . . .558