xi Copyright Goodheart-Willcox Co., Inc. 9.2.2 Adding Slide Transitions . . . . . . . . . . . . .374 9.2.3 Adding Animations . . . . . . . . . . . . . . . . .375 9.2.4 Adding a Hyperlink . . . . . . . . . . . . . . . . .377 9.2.5 Inserting a Background Image . . . . . . . .378 9.2.6 Adding a Header and Footer . . . . . . . . .380 9.3.1 Adding a Table . . . . . . . . . . . . . . . . . . . . .384 9.3.2 Adding a Chart . . . . . . . . . . . . . . . . . . . . .387 9.3.3 Adding Speaker Notes . . . . . . . . . . . . . . .390 9.3.4 Printing Handouts . . . . . . . . . . . . . . . . . .392 Chapter 10 Spreadsheet Software 10.1.1 Creating a Spreadsheet. . . . . . . . . . . . . . .405 10.1.2 Editing Data. . . . . . . . . . . . . . . . . . . . . . . .408 10.2.1 Formatting Text . . . . . . . . . . . . . . . . . . . . .411 10.2.2 Formatting Numbers . . . . . . . . . . . . . . . .413 10.2.3 Adjusting Column Width . . . . . . . . . . . .415 10.2.4 Adding Columns. . . . . . . . . . . . . . . . . . . .417 10.2.5 Copying Cells . . . . . . . . . . . . . . . . . . . . . .419 10.2.6 Relative and Absolute Cell Addresses. . .421 10.2.7 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . .425 Chapter 11 Advanced Spreadsheet Uses 11.1.1 Inserting Functions . . . . . . . . . . . . . . . . . .439 11.1.2 Using Date-Related Functions. . . . . . . . .442 11.1.3 Calculating a Payment . . . . . . . . . . . . . . .443 11.1.4 Using a Logical Function . . . . . . . . . . . . .446 11.2.1 Applying Conditional Formatting . . . . .449 11.2.2 Creating Charts . . . . . . . . . . . . . . . . . . . . .452 11.2.3 Using a Chart in a Document . . . . . . . . .455 Chapter 12 Database Software 12.1.1 Examining a Database . . . . . . . . . . . . . . .469 12.1.2 Adding Data . . . . . . . . . . . . . . . . . . . . . . .469 12.1.3 Editing Data. . . . . . . . . . . . . . . . . . . . . . . .471 12.1.4 Creating a Database . . . . . . . . . . . . . . . . .474 12.2.1 Importing Data . . . . . . . . . . . . . . . . . . . . .479 12.2.2 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . .482 12.2.3 Creating a Form. . . . . . . . . . . . . . . . . . . . .483 12.2.4 Creating a Report . . . . . . . . . . . . . . . . . . .485 12.2.5 Joining Tables. . . . . . . . . . . . . . . . . . . . . . .490 12.3.1 Creating a Simple Query . . . . . . . . . . . . .494 12.3.2 Creating an Advanced Query . . . . . . . . .496 12.3.3 Qualifying a Query. . . . . . . . . . . . . . . . . .498 12.3.4 Creating a Calculated Field . . . . . . . . . . .499 12.3.5 Creating a Statistical Field . . . . . . . . . . . .500 Chapter 13 Internet and the World Wide Web 13.1.1 Finding an IP Address . . . . . . . . . . . . . . .513 13.1.2 Setting the Browser Home Page . . . . . . .523 13.1.3 Citing Online Sources. . . . . . . . . . . . . . . .532 13.2.1 Identifying Design Principles . . . . . . . . .536 13.2.2 Creating a Basic Web Page. . . . . . . . . . . .540 13.2.3 Creating a Basic External Style Sheet. . .545 13.2.4 Adding JavaScript to a Web Page. . . . . .548 Chapter 14 Communication Networks 14.1.1 Connecting to a Network. . . . . . . . . . . . .564 14.2.1 Examining Network Topology . . . . . . . .570 14.3.1 Determining Wireless Network Security . . . . . . . . . . . . . . . . . . .576 14.3.2 Disabling Autorun . . . . . . . . . . . . . . . . . .578 14.3.3 Network Troubleshooting . . . . . . . . . . . .580 Chapter 15 Electronic Communication and Collaboration 15.1.1 Adding an Account to Outlook. . . . . . . .592 15.1.2 Creating a New Contact Group . . . . . . .598 15.2.1 Instant Messaging . . . . . . . . . . . . . . . . . . .610 15.2.2 Videoconferencing . . . . . . . . . . . . . . . . . .612 15.2.3 Subscribing to an RSS Feed . . . . . . . . . . .615 15.3.1 Terms of Use . . . . . . . . . . . . . . . . . . . . . . .622 15.3.2 Cyberbullying . . . . . . . . . . . . . . . . . . . . . .626 Chapter 16 Security, Privacy, and Safety 16.1.1 Cybersecurity Threats . . . . . . . . . . . . . . .644 16.1.2 Computer Viruses . . . . . . . . . . . . . . . . . . .648 16.2.1 Identity Theft . . . . . . . . . . . . . . . . . . . . . . .652 16.2.2 Social Media Security . . . . . . . . . . . . . . . .661 16.3.1 Strong Passwords . . . . . . . . . . . . . . . . . . .667 16.3.2 Antivirus Software . . . . . . . . . . . . . . . . . .671 Chapter 17 Careers in IT 17.1.1 Worldwide Internet Use. . . . . . . . . . . . . .688 17.1.2 Exploring IT Careers. . . . . . . . . . . . . . . . .699 17.2.1 Identifying Personal-Success Skills . . . .708 17.2.2 Investigating Professional Certifi cation . . . . . . . . . . . . . . . . . . . . . . . .718 17.2.3 Submitting a Résumé . . . . . . . . . . . . . . . .726