viii Principles of Information Technology Copyright Goodheart-Willcox Co., Inc. Working with a Presentation . . . . . . . . . . . . . .354 Managing the Presentation. . . . . . . . . . . . . . . .366 Section 9.2 Adding Transitions and Animations. . . . . . . . . . . . . . . . . . . . . . . . 370 Creating a New Presentation . . . . . . . . . . . . . .371 Advanced Features . . . . . . . . . . . . . . . . . . . . . .373 Section 9.3 Charts, Tables, and Handouts . . . 382 Creating Tables. . . . . . . . . . . . . . . . . . . . . . . . . .383 Creating Charts . . . . . . . . . . . . . . . . . . . . . . . . .385 Creating Speaker Notes . . . . . . . . . . . . . . . . . .389 Creating Handouts . . . . . . . . . . . . . . . . . . . . . .391 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 394 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 394 Application and Extension of Knowledge . . . . . 395 Chapter 10 Spreadsheet Software . .398 Section 10.1 Introduction to Spreadsheets . . 400 Origin of Spreadsheets . . . . . . . . . . . . . . . . . . .401 Using Spreadsheets . . . . . . . . . . . . . . . . . . . . . .401 Entering Data . . . . . . . . . . . . . . . . . . . . . . . . . . .403 Using Formulas . . . . . . . . . . . . . . . . . . . . . . . . .404 Editing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . .406 Section 10.2 Managing Data in Spreadsheets . . . . . . . . . . . . . . . . . . . . . . . 409 Customizing the Appearance. . . . . . . . . . . . . .410 Changing Data Locations . . . . . . . . . . . . . . . . .417 Rearranging Data. . . . . . . . . . . . . . . . . . . . . . . .419 Locating and Organizing Data. . . . . . . . . . . . .422 Printing a Spreadsheet . . . . . . . . . . . . . . . . . . .426 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 430 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 430 Application and Extension of Knowledge . . . . . 431 Chapter 11 Advanced Spreadsheet Uses . . . . .434 Section 11.1 Calculating with Functions . . . . . 436 Using Functions . . . . . . . . . . . . . . . . . . . . . . . . .437 Complex Financial Formulas . . . . . . . . . . . . . .443 Logical Functions. . . . . . . . . . . . . . . . . . . . . . . .444 Section 11.2 Visual Enhancements of Data. . . 447 Conditional Formatting . . . . . . . . . . . . . . . . . .448 Charts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .450 Spreadsheet Charts in Text Documents . . . . .453 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .456 Comma-Separated Values Files . . . . . . . . . . . .456 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 458 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 458 Application and Extension of Knowledge . . . . . 459 Chapter 12 Database Software . . . .462 Section 12.1 Introduction to Databases. . . . . 464 Overview of Databases . . . . . . . . . . . . . . . . . . .465 Examining a Database. . . . . . . . . . . . . . . . . . . .468 Creating a Database Structure . . . . . . . . . . . . .471 Section 12.2 Importing and Viewing Data. . . . . 477 Importing Records into a Database. . . . . . . . .478 Viewing Data . . . . . . . . . . . . . . . . . . . . . . . . . . .480 Joining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . .486 Section 12.3 Queries . . . . . . . . . . . . . . . . . . . 492 Locating Data . . . . . . . . . . . . . . . . . . . . . . . . . . .493 Creating Calculated Fields . . . . . . . . . . . . . . . .498 Creating Statistical Fields . . . . . . . . . . . . . . . . .499 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 502 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 502 Application and Extension of Knowledge . . . . . 503 Unit 3 Living Online . . . . . . . . . . .506 Chapter 13 Internet and the World Wide Web. . . . . .508 Section 13.1 Internet and the World Wide Web. . . . . . . . . . . . . . . . . . . . 510 Internet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .511 Digital Wellness . . . . . . . . . . . . . . . . . . . . . . . . .526 Using Search Engines . . . . . . . . . . . . . . . . . . . .527 Ethical Use of the Internet . . . . . . . . . . . . . . . .531 Section 13.2 Creating for the Web. . . . . . . . . 533 Designing for the Web. . . . . . . . . . . . . . . . . . . .534 HTML . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .537 Programming Languages . . . . . . . . . . . . . . . . .546 Chapter Summary . . . . . . . . . . . . . . . . . . . . . . 550 Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . 550 Application and Extension of Knowledge . . . . . 551