Microsoft sway utilizes responsive design which means

Complete: In the Lab #2 exercise for this module on page EX110
If it says "If requested by instructor", it IS REQUESTED
DO NOT print if it asks you to
IGNORE step #13
Please read Module 3 of MS Excel in your book.

Complete the tutorial and submit it.It is important that you understand what you are learning.

Complete: IN THE LAB #2 (Ex 181)
If it says "if requested by instructor"
It is requested, complete the step
Any files you may need will be found in the COURSE DOCUMENTS section

A FUNDAMENTAL COMBINED APPROACH

DISCOVERING COMPUTERS &

OFFICE 2016 MICROSOFT® OFFICE 365™

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

A FUNDAMENTAL COMBINED APPROACH A FUNDAMENTAL COMBINED APPROACH

Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States

Steven M. Freund Mary Z. Last Philip J. Pratt Susan L. Sebok Misty E. Vermaat Jennifer T. Campbell Mark Frydenberg

DISCOVERING COMPUTERS &

OFFICE 2016 MICROSOFT® OFFICE 365™

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

© 2017 Cengage Learning

ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced or distributed in any form or by any means, except as permitted by U.S. copyright law, without the prior written permission of the copyright owner.

Microsoft and the Office logo are either registered trademarks or trademarks of Microsoft Corporation in the United States and/ or other countries. Cen- gage Learning is an independent entity from the Microsoft Corporation, and not affiliated with Microsoft in any manner.

Mac users: If you’re working through this product using a Mac, some of the steps may vary. Additional information for Mac users is included with the data files for this product.

The material in this book was written using Microsoft Office 2016 and was Quality Assurance tested before the publication date. As Microsoft continually updates Office 2016 and Office 365, your software experience may vary slightly from what is seen in the printed text.

Library of Congress Control Number: 2015958649

ISBN: 978-1-305-87180-9

Cengage Learning 20 Channel Center Street Boston, MA 02210 USA

Cengage Learning is a leading provider of customized learning solutions with employees residing in nearly 40 different countries and sales in more than 125 countries around the world. Find your local representative at www.cengage.com.

Cengage Learning products are represented in Canada by Nelson Education, Ltd.

To learn more about Cengage Learning, visit www.cengage.com

Purchase any of our products at your local college store or at our preferred online store www.cengagebrain.com

Discovering Computers and Microsoft Office 2016: A Fundamental Combined Approach Steven M. Freund Mary Z. Last Philip J. Pratt Susan L. Sebok Misty E. Vermaat Jennifer T. Campbell Mark Frydenberg

SVP, GM Skills & Global Product Management: Dawn Gerrain

Product Director: Kathleen McMahon

Senior Product Team Manager: Lauren Murphy

Associate Product Managers: William Guiliani, Amanda Lyons, Melissa Stehler

Senior Director, Development: Marah Bellegarde

Product Development Manager: Leigh Hefferon

Managing Content Developer: Emma F. Newsom

Developmental Editors: Amanda Brodkin, Deb Kaufmann, Lyn Markowicz, Lisa Ruffolo, Karen Stevens

Product Assistant: Erica Chapman, Cara Suriyamongkol

Manuscript Quality Assurance: Jeffrey Schwartz, John Freitas, Serge Palladino, Susan Pedicini, Danielle Shaw, Susan Whalen

Senior Production Director: Wendy Troeger

Production Director: Patty Stephan

Senior Content Project Manager: Matthew Hutchinson

Manufacturing Planner: Julio Esperas

Designer: Diana Graham

Text Design: Joel Sadagursky

Cover Template Designer: Diana Graham

Cover image(s): Mario7/Shutterstock.com; Mrs. Opossum/Shutterstock.com

Compositor: Lumina Datamatics

Vice President, Marketing: Brian Joyner

Marketing Director: Michele McTighe

Marketing Manager: Stephanie Albracht

For product information and technology assistance, contact us at Cengage Learning Customer & Sales Support, 1-800-354-9706

For permission to use material from this text or product, submit all requests online at www.cengage.com/permissions.

Further permissions questions can be e-mailed to permissionrequest@cengage.com

Printed in the United States of America Print Number: 01 Print Year: 2017

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

Contents

A FUNDAMENTAL COMBINED APPROACH

v

DISCOVERING COMPUTERS &DISCOVERING COMPUTERS & OFFICE 2016MICROSOFT® OFFICE 365™

Productivity Apps for School and Work Introduction to OneNote 2016 PA 2 Introduction to Sway PA 6 Introduction to Of�ce Mix PA 10 Introduction to Microsoft Edge PA 14

DISCOVERING COMPUTERS

CHAPTER ONE Introducing Today’s Technologies: Computers, Devices, and the Web Today’s Technology 2 Computers 4

Laptops 4 Tablets 4 Desktops and All-in-Ones 6 Servers 6

Mobile and Game Devices 7 Smartphones 7 Digital Cameras 8 Portable and Digital Media Players 8 E-Book Readers 9 Wearable Devices 9 Game Devices 10 Mini Feature 1-1: Living Digitally — Gaming and

Digital Home 10 Data and Information 12

Input 12 Output 14 Memory and Storage 16

The Web 20 Web Searching 22 Online Social Networks 23 Internet Communications 24

Digital Security and Privacy 24 Viruses and Other Malware 24 Privacy 24 Health Concerns 26 Environmental Issues 26

Programs and Apps 26 Operating Systems 27 Applications 27 Installing and Running Programs 28

Developing Programs and Apps 29 Communications and Networks 30

Wired and Wireless Communications 31 Networks 32 Mini Feature 1-2: Staying in Sync 34

Technology Uses 35 Education/Mini Feature 1-3: Digital School 35 Government 36 Finance 36 Retail 36 Entertainment 38 Health Care 38 Science 38 Travel 39 Publishing 39 Manufacturing 40

Technology Users 41 Summary 43 Study Guide 44 Key Terms 45 Checkpoint 46 Problem Solving 48 Collaboration 48 How To: Your Turn 49 Internet Research 52 Critical Thinking 54 Collaboration 54

CHAPTER TWO Connecting and Communicating Online: The Internet, Websites, and Media The Internet 56

Evolution of the Internet 56 Connecting to the Internet 58

Internet Service Providers 61 How Data Travels the Internet 62 IP Addresses and Domain Names 62

The World Wide Web 65 Navigating the Web 65 Mini Feature 2-1: Browsers 66 Web Addresses 68 Web Apps and Mobile Apps 69

Types of Websites 71 Search Engines 71 Mini-Feature 2-2: Online Social Networks 72

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

vi Contents Discovering Computers & Microsoft® Office 365™ Office 2016

Informational and Research 74 Media Sharing 75 Bookmarking 75 News, Weather, Sports, and Other Mass Media 76 Educational 77 Business, Governmental, and Organizational 77 Blogs 78 Wikis and Collaboration 78 Health and Fitness 79 Science 79 Entertainment 79 Banking and Finance 79 Travel and Tourism 80 Mapping 80 Retail and Auctions 81 Careers and Employment 82 E-Commerce 82 Portals 82 Content Aggregation 83 Website Creation and Management 84

Digital Media on the Web 85 Graphics 85 Audio 86 Video 87 Plug-Ins 88

Other Internet Services 88 Email 88 Email Lists 90 Internet Messaging 90 Chat Rooms 91 Online Discussions 91 VoIP 92 FTP 92 Mini Feature 2-3: Digital Communications 93

Netiquette 94 Summary 95 Study Guide 96 Key Terms 97 Checkpoint 98 Problem Solving 100 Collaboration 100 How to: Your turn 101 internet Research 104 Critical thinking 106 Collaboration 106

CHAPTER THREE Computers and Mobile Devices: Evaluating Options for Home and Work Computers and Mobile Devices 108 Mobile Computers and Desktops 108

Laptops, Tablets, and Other Mobile Computers 111 Handheld Computers 112 Mini Feature 3-1: Mobile Computer

Buyer’s Guide 113 Desktops and All-in-Ones 114 Mini Feature 3-2: Desktop Buyer’s Guide 115

Servers 116 Terminals 117

Point-of-Sale Terminals 118 ATMs 118 Self-Service Kiosks 119

Supercomputers 120 Cloud Computing 121 Mobile Devices 122

Smartphones 123 Digital Cameras 125 Portable and Digital Media Players 127 Mini Feature 3-3: Mobile Device Buyer’s Guide 128 E-Book Readers 129 Wearable Devices 130

Game Devices 131 Embedded Computers 132 Putting It All Together 134 Ports and Connections 134

USB Ports 136 Port Replicators and Docking Stations 136 Wireless Device Connections 137

Protecting Hardware 139 Hardware Theft and Vandalism 139 Hardware Failure 139

Health Concerns of Using Technology 142 Repetitive Strain Injuries 142 Other Physical Risks 143 Behavioral Health Risks 144

Summary 145 Study Guide 146 Key Terms 147 Checkpoint 148 Problem Solving 150 Collaboration 150 How To: Your Turn 151 Internet Research 154 Critical Thinking 156 Collaboration 156

CHAPTER FOUR Programs and Apps: Productivity, Graphics, Security, and Other Tools Programs and Apps 158

Role of the Operating System 158 Obtaining Software 161 Installing Software 162 Categories of Programs and Apps 163

Productivity Applications 165 Developing Projects 165 Word Processing 167 Presentation 168 Spreadsheet 168 Database 170 Note Taking 171 Calendar and Contact Management 171 Software Suite 172 Project management 172 Accounting 173 Personal Finance 174 Legal 175 Tax Preparation 176 Document Management 176 Enterprise Computing 177 Mini Feature 4-1: Web and Mobile Apps

for Personal and Business Productivity 177 Graphics and Media Applications 179

Computer-Aided Design 180 Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

Discovering Computers & Microsoft® Office 365™ Office 2016 Contents vii

Desktop Publishing 180 Paint/Image Editing 181 Photo Editing and Photo Management 181 Video and Audio Editing 183 Multimedia and Website Authoring 184 Media Player 185 Disc Burning 185

Personal Interest Applications 185 Mini Feature 4-2: Web and Mobile

Apps for Media and Personal Interest 186 Communications Applications 188 Security Tools 189

Personal Firewall 189 Mini Feature 4-3: Viruses and Malware 190 Antivirus Programs 191 Spyware, Adware, and Other Malware Removers 192 Internet Filters 193

File, Disk, and System Management Tools 194 File Manager 194 Search 195 Image Viewer 195 Uninstaller 195 Disk Cleanup 196 Disk Defragmenter 197 Screen Saver 197 File Compression 198 PC Maintenance 198 Backup and Restore 198

Summary 199 Study Guide 200 Key Terms 201 Checkpoint 202 Problem Solving 204 Collaboration 204 How To: Your Turn 205 Internet Research 208 Critical Thinking 210 Collaboration 210

CHAPTER FIVE DIGITAL SECURITY, ETHICS, AND PRIVACY: Threats, Issues, and Defenses Digital Security Risks 212

Cybercrime 212 Internet and Network Attacks 215

Malware 215 Botnets 216 Denial of Service Attacks 217 Back Doors 217 Spoofing 217 Safeguards against Internet and Network Attacks 218 Firewalls 219

Unauthorized Access and Use 221 Safeguards against Unauthorized Access and Use 221 Access Controls 222 User Names and Passwords 222 Possessed Objects 224 Biometric Devices 224 Two-Step Verification 226 Digital Forensics 227

Software Theft 228 Safeguards against Software Theft 228

Information Theft 229 Safeguards against Information Theft 229 Encryption 229 Digital Signatures and Certificates 231 Mini Feature 5-1: Cloud Data Privacy 231

Hardware Theft, Vandalism, and Failure 233 Backing Up — The Ultimate Safeguard 233

Mini Feature 5-2: Disaster Recovery 234 Wireless Security 236

Mini Feature 5-3: Mobile Security 237 Ethics and Society 238

Information Accuracy 239 Intellectual Property Rights 240 Codes of Conduct 241 Green Computing 241

Information Privacy 242 Electronic Profiles 242 Cookies 243 Phishing 244 Spyware and Adware 245 Social Engineering 245 Privacy Laws 246 Employee Monitoring 247 Content Filtering 247

Summary 249 Study Guide 250 Key Terms 251 Checkpoint 252 Problem Solving 254 Collaboration 254 How To: Your Turn 255 Internet Research 258 Critical Thinking 260 Collaboration 260

Microsoft Of�ce 2016 and Windows 10

Of�ce 2016 and Windows 10: Essential Concepts and Skills Objectives OFF 1

Roadmap OFF 1 Introduction to the Windows 10 Operating System OFF 2

Using a Touch Screen and a Mouse OFF 3 Scrolling OFF 4 Keyboard Shortcuts OFF 5 Starting Windows OFF 5 To Sign In to an Account OFF 6 The Windows Desktop OFF 7

Introduction to Microsoft Of�ce 2016 OFF 7 Microsoft Of�ce 2016 Apps OFF 7 Microsoft Of�ce 2016 Suites OFF 8

Running and Using an App OFF 9 Word OFF 9 To Run an App Using the Start Menu

and Create a Blank Document OFF 9 To Maximize a Window OFF 11 Word Document Window, Ribbon, and

Elements Common to Of�ce Apps OFF 12 To Display a Different Tab on the Ribbon OFF 16 To Collapse and Expand the Ribbon

and Use Full Screen Mode OFF 17 Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

viii Contents Discovering Computers & Microsoft® Office 365™ Office 2016

To Use a Shortcut Menu to Relocate the Quick Access Toolbar OFF 19

To Customize the Quick Access Toolbar OFF 20 To Enter Text in a Document OFF 21

Document Properties OFF 22 To Change Document Properties OFF 22

Printing, Saving, and Organizing Files OFF 23 Printing a Document OFF 23 To Print a Document OFF 23 Organizing Files and Folders OFF 25 To Create a Folder OFF 26 Folder Windows OFF 27 To Create a Folder within a Folder OFF 28 To Create the Remaining Folders OFF 28 To Expand a Folder, Scroll through

Folder Contents, and Collapse a Folder OFF 29 To Switch from One App to Another OFF 30 To Save a File in a Folder OFF 31 Navigating in Dialog Boxes OFF 34 To Minimize and Restore a Window OFF 34 To Save a File on OneDrive OFF 35 To Sign Out of a Microsoft Account OFF 37

Screen Resolution OFF 38 To Change the Screen Resolution OFF 39 To Exit an Of�ce App with One Document Open OFF 41 To Copy a Folder to OneDrive OFF 42 To Unlink a OneDrive Account OFF 44

Additional Microsoft Of�ce Apps OFF 45 PowerPoint OFF 46 To Run an App Using the Search Box OFF 47 The PowerPoint Window and Ribbon OFF 48 To Enter Content in a Title Slide OFF 49 To Save a File in a Folder OFF 49 To Create a New Of�ce Document

from the Backstage View OFF 50 To Enter Content in a Title Slide of a Second

PowerPoint Presentation OFF 51 To Save a File in a Folder OFF 51 To Close an Of�ce File Using the Backstage View OFF 52 To Open a Recent Of�ce File Using

the Backstage View OFF 52 To Exit an Of�ce App OFF 53 Excel OFF 53 To Create a New Blank Of�ce

Document from File Explorer OFF 54 To Run an App from File Explorer

and Open a File OFF 55 Unique Features of Excel OFF 56 To Enter a Worksheet Title OFF 57 To Save an Existing Of�ce File

with the Same File Name OFF 58 To Save a File with a New File Name OFF 59 To Exit an Of�ce App OFF 59 Access OFF 59 To Run an App OFF 59 Unique Elements in Access OFF 60 To Create an Access Database OFF 61 To Close an Of�ce File OFF 62 To Open an Existing Of�ce File OFF 63 To Exit an Of�ce App OFF 63

Other Of�ce Apps OFF 64 Outlook OFF 64

Publisher OFF 65 OneNote OFF 66

Renaming, Moving, and Deleting Files OFF 67 To Rename a File OFF 68 To Move a File OFF 68 To Delete a File OFF 69

Microsoft Of�ce and Windows Help OFF 70 To Open the Help Window

in an Of�ce App OFF 70 Moving and Resizing Windows OFF 70 To Move a Window by Dragging OFF 70 To Resize a Window by Dragging OFF 71 Using Of�ce Help OFF 72 To Obtain Help Using the Search Text Box OFF 72 Obtaining Help while Working in an

Of�ce App OFF 73 To Obtain Help Using the Tell Me Box OFF 74 Using the Windows Search Box OFF 74 To Use the Windows Search Box OFF 74

Summary OFF 75 Apply Your Knowledge OFF 76 Extend Your Knowledge OFF 77 Expand Your World OFF 78 In the Labs OFF 78

Microsoft Word 2016

MODULE ONE Creating, Formatting, and Editing a Word Document with a Picture Objectives WD 1 Introduction WD 1 Project — Flyer with a Picture WD 1

To Run Word and Specify Settings WD 3 Entering Text WD 3

To Type Text WD 4 To Display Formatting Marks WD 5 To Insert a Blank Line WD 5 To Zoom Page Width WD 6 Wordwrap WD 7 To Wordwrap Text as You Type WD 7 Spelling and Grammar Check WD 8 To Check Spelling and Grammar as You Type WD 8 To Enter More Text WD 9 Navigating a Document WD 10

Formatting Paragraphs and Characters WD 11 Font, Font Sizes, and Themes WD 12 To Center a Paragraph WD 13 To Center Another Paragraph WD 13 Formatting Single versus Multiple Paragraphs

and Characters WD 14 To Select a Line WD 14 To Change the Font Size of Selected Text WD 15 To Change the Font of Selected Text WD 16 To Change the Case of Selected Text WD 17 To Apply a Text Effect to Selected Text WD 18 To Shade a Paragraph WD 19 To Select Multiple Lines WD 20 To Change the Font Size of Selected Text WD 20 To Bullet a List of Paragraphs WD 21 To Undo and Redo an Action WD 22

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

Discovering Computers & Microsoft® Office 365™ Office 2016 Contents ix

To Italicize Text WD 23 To Color Text WD 24 To Use the Mini Toolbar to Format Text WD 25 To Select a Group of Words WD 26 To Underline Text WD 27 To Bold Text WD 27 To Zoom One Page WD 28 To Change Theme Colors WD 29 To Zoom Page Width WD 30 Selecting Text WD 30

Inserting and Formatting a Picture in a Word Document WD 31

To Center Another Paragraph WD 31 To Insert a Picture WD 31 To Zoom the Document WD 33 To Resize a Graphic WD 34 To Zoom 100% WD 35 To Apply a Picture Style WD 36 To Apply Picture Effects WD 37

Enhancing the Page WD 38 To Add a Page Border WD 39 To Zoom One Page WD 40 To Change Spacing before and

after Paragraphs WD 40 To Center Page Contents Vertically WD 41 To Save the Document and Exit Word WD 42

Correcting Errors and Revising a Document WD 42 Types of Changes Made to Documents WD 43 To Run Word, Open a Document, and

Specify Settings WD 43 To Insert Text in an Existing Document WD 43 To Delete Text WD 44 To Move Text WD 44 To Save and Print the Document WD 45 To Switch to Read Mode WD 46 To Switch to Print Layout View WD 46

Summary WD 47 Apply Your Knowledge WD 48 Extend Your Knowledge WD 50 Expand Your World WD 51 In the Labs WD 52

MODULE TWO Creating a Research Paper with References and Sources Objectives WD 57 Introduction WD 57 Project — Research Paper WD 57

MLA Documentation Style WD 58 Changing Document Settings WD 60

To Run Word and Specify Settings WD 60 Styles WD 60 To Modify a Style WD 61 Adjusting Line and Paragraph Spacing WD 62 To Change Line Spacing WD 62 To Remove Space after a Paragraph WD 63 To Update a Style to Match a Selection WD 64

Creating a Header WD 64 To Switch to the Header WD 65 To Right-Align a Paragraph WD 66 To Enter Text WD 66 To Insert a Page Number WD 66

To Close the Header WD 68 Typing the Research Paper Text WD 68

To Enter Name and Course Information WD 69 To Click and Type WD 70 Keyboard Shortcuts WD 71 To Format Text Using a Keyboard Shortcut WD 71 To Display the Rulers WD 72 To First-Line Indent Paragraphs WD 72 To AutoCorrect as You Type WD 74 To Use the AutoCorrect Options Button WD 75 To Create an AutoCorrect Entry WD 75 The AutoCorrect Dialog Box WD 77 To Enter More Text WD 77 Citations WD 78 To Change the Bibliography Style WD 78 To Insert a Citation and Create Its Source WD 79 To Enter More Text WD 81 Footnotes WD 82 To Insert a Footnote Reference Mark WD 82 To Enter Footnote Text WD 83 To Insert a Citation Placeholder WD 83 Footnote Text Style WD 84 To Modify a Style Using a Shortcut Menu WD 84 To Edit a Source WD 86 To Edit a Citation WD 88 Working with Footnotes and Endnotes WD 89 To Enter More Text WD 90 To Count Words WD 90 Automatic Page Breaks WD 91 To Enter More Text and Insert a Citation

Placeholder WD 91 To Hide and Show White Space WD 92 To Edit a Source WD 93 To Enter More Text WD 94

Creating an Alphabetical Works Cited Page WD 95 To Page Break Manually WD 95 To Apply a Style WD 96 To Center Text WD 96 To Create a Bibliographical List WD 96

Proofreading and Revising the Research Paper WD 98 To Modify a Source WD 99 To Update a Field WD 99 To Go to a Page WD 101 Copying, Cutting, and Pasting WD 101 To Copy and Paste WD 102 To Display the Paste Options Menu WD 103 To Find Text WD 103 To Replace Text WD 104 Find and Replace Dialog Box WD 105 To Find and Insert a Synonym WD 105 To Check Spelling and Grammar at Once WD 106 The Main and Custom Dictionaries WD 107 To Look Up Information WD 108 To Zoom Multiple Pages WD 109 To Change Read Mode Color WD 110 To Save and Print the Document and

Exit Word WD 111 Summary WD 111 Apply Your Knowledge WD 112 Extend Your Knowledge WD 113 Expand Your World WD 115 In the Labs WD 116

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

x Contents Discovering Computers & Microsoft® Office 365™ Office 2016

MODULE THREE Creating a Business Letter with a Letterhead and Table Objectives WD 121 Introduction WD 121 Project — Business Letter with a Letterhead

and Table WD 121 To Run Word and Change Word Settings WD 123 To Change Margin Settings WD 123

Creating a Letterhead WD 124 To Insert a Shape WD 125 Floating versus Inline Objects WD 127 To Change an Object’s Position WD 127 To Change an Object’s Text Wrapping WD 128 To Apply a Shape Style WD 129 To Add Text to a Shape WD 129 To Use the ‘Increase Font Size’ Button WD 130 To Bold Selected Text WD 131 To Change the Document Theme WD 131 To Insert an Online Picture WD 131 To Resize a Graphic to a Percent of

the Original Size WD 133 To Change the Color of a Graphic WD 134 To Set a Transparent Color in a Graphic WD 135 To Adjust the Brightness and

Contrast of a Graphic WD 136 To Change the Border Color on a Graphic WD 137 To Change an Object’s Text Wrapping WD 137 To Move a Graphic WD 138 To Copy a Graphic WD 138 To Use Paste Options WD 139 To Move a Graphic WD 139 To Flip a Graphic WD 140 To Format and Enter Text WD 140 To Insert a Symbol from the Symbol

Dialog Box WD 141 To Insert a Symbol from the Insert

a Symbol Gallery WD 142 To Enter Text WD 143 To Bottom Border a Paragraph WD 143 To Clear Formatting WD 144 AutoFormat As You Type WD 145 To Convert a Hyperlink to Regular Text WD 146

Creating a Business Letter WD 147 To Save a Document with a New File Name WD 147 To Apply a Style WD 147 Using Tab Stops to Align Text WD 149 To Display the Ruler WD 149 To Set Custom Tab Stops WD 149 To Insert the Current Date in a Document WD 151 To Enter the Inside Address and Salutation WD 152 To Create a Building Block WD 152 To Modify a Building Block WD 153 To Insert a Building Block WD 154 Building Blocks versus AutoCorrect WD 155 To Insert a Nonbreaking Space WD 155 To Enter Text WD 156 Tables WD 157 To Insert an Empty Table WD 157 To Enter Data in a Table WD 158 To Enter More Data in a Table WD 159

To Apply a Table Style WD 160 To Resize Table Columns to Fit Table Contents WD 161 To Select a Column WD 162 Selecting Table Contents WD 163 To Align Data in Cells WD 163 To Center a Table WD 164 To Insert a Row in a Table WD 165 To Insert a Column in a Table WD 167 To Merge Cells WD 167 To Split Table Cells WD 168 To Split a Table WD 168 To Change the Font of Text in a Table Row WD 168 Deleting Table Data WD 169 To Add More Text WD 169 To Bullet a List as You Type WD 169 To Enter More Text and then Save and

Print the Letter WD 171 Addressing and Printing Envelopes

and Mailing Labels WD 171 To Address and Print an Envelope WD 171 Envelopes and Labels WD 172

Summary WD 173 Apply Your Knowledge WD 175 Extend Your Knowledge WD 175 Expand Your World WD 177 In the Labs WD 178

Microsoft PowerPoint 2016

MODULE ONE Creating and Editing a Presentation with Pictures Objectives PPT 1 Introduction PPT 1 Project — Presentation with a Bulleted List

and Pictures PPT 2 Choosing a Document Theme and Variant PPT 3

To Choose a Document Theme and Variant PPT 3 Creating a Title Slide PPT 5

To Enter the Presentation Title PPT 6 Correcting a Mistake When Typing PPT 7 Paragraphs PPT 7 To Enter the Presentation Subtitle Paragraph PPT 7 To Zoom a Slide PPT 8

Formatting Characters in a Presentation PPT 9 Fonts and Font Styles PPT 9 To Select a Paragraph PPT 9 To Italicize Text PPT 10 To Increase Font Size PPT 10 To Select a Word PPT 11 To Change the Text Color PPT 11

Adding a New Slide to a Presentation PPT 12 To Add a New Text Slide with a Bulleted List PPT 12

Creating a Text Slide with a Multilevel Bulleted List PPT 13

To Enter a Slide Title PPT 14 To Select a Text Placeholder PPT 15 To Type a Multilevel Bulleted List PPT 15 To Type the Remaining Text for Slide 2 PPT 17 To Select a Group of Words PPT 17

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

Discovering Computers & Microsoft® Office 365™ Office 2016 Contents xi

To Bold Text PPT 18 To Increase Font Size PPT 18

Adding New Slides, Changing Slide Layouts, and Changing the Theme PPT 19

To Add a New Slide and Enter a Slide Title and Headings PPT 19

To Add a Slide with the Title Only Layout PPT 21 To Enter a Slide Title PPT 23 To Change the Theme PPT 23 To Change the Variant PPT 25

Powerpoint Views PPT 26 To Move to Another Slide in Normal View PPT 26

Inserting Pictures into Slides PPT 28 To Insert a Picture into the Title Slide PPT 28 To Insert a Picture into a Slide without a

Content Placeholder PPT 29 To Insert a Picture into a Content Placeholder PPT 30 To Insert a Picture into a Slide without a

Content Placeholder PPT 31 Resizing Photos and Illustrations PPT 32

To Proportionally Resize Pictures PPT 32 To Nonproportionally Resize the

Photograph on Slide 2 PPT 33 To Resize the Illustration on Slide 4 PPT 34 To Move Pictures PPT 35 To Rotate a Picture PPT 36

Ending a Slide Show with a Closing Slide PPT 37 To Duplicate a Slide PPT 38 To Arrange a Slide PPT 39

Making Changes to Slide Text Content PPT 39 Replacing Text in an Existing Slide PPT 40 Deleting Text PPT 40 To Delete Text in a Placeholder PPT 40

Adding a Transition PPT 42 To Add a Transition between Slides PPT 42 Document Properties PPT 44

Viewing the Presentation in Slide Show View PPT 45 To Start Slide Show View PPT 45 To Move Manually through Slides in

a Slide Show PPT 46 To Save and Print the Presentation PPT 47

Summary PPT 48

Apply Your Knowledge PPT 49

Extend Your Knowledge PPT 50

Expand Your World PPT 51

In the Labs PPT 52

MODULE TWO Enhancing a Presentation with Pictures, Shapes, and WordArt Objectives PPT 57 Introduction PPT 57 Project — Presentation with Pictures,

Shapes, and Wordart PPT 57 Downloading a Theme and Editing Slides PPT 59

To Search for and Download an Online Theme PPT 59 To Delete a Slide PPT 60 To Create a Title Slide PPT 61 To Create the First Text Slide PPT 62 To Create the Second Text Slide PPT 63

Inserting and Formatting Pictures in a Presentation PPT 63 To Insert a Picture into a Slide

without a Content Placeholder PPT 63 To Change a Picture PPT 65 To Correct a Picture PPT 66 To Apply a Picture Style PPT 67 To Add a Picture Border PPT 68 To Change a Picture Border Color PPT 69 To Apply Picture Effects PPT 70

Inserting and Formatting a Shape PPT 71 To Add a Shape PPT 72 To Resize a Shape PPT 73 To Add Other Shapes PPT 74 To Apply a Shape Style PPT 75 To Apply Another Style PPT 77 To Add Text to a Shape PPT 78 To Change the Font PPT 78 To Format the Text PPT 79 Format Painter PPT 80 To Format Text Using the Format Painter PPT 80 To Copy and Paste a Shape PPT 81

Formatting Slide Backgrounds PPT 83 To Insert a Texture Fill PPT 84 To Format the Background Texture

Fill Transparency PPT 86 To Insert a Gradient Fill PPT 86 To Insert a Picture to Create a Background PPT 87 To Format the Background Picture

Fill Transparency PPT 88 Inserting and Formatting Wordart PPT 88

To Insert WordArt PPT 89 To Change the WordArt Shape PPT 90 To Apply a WordArt Text Fill PPT 91 To Change the Weight of the WordArt Outline PPT 92 To Change the Color of the WordArt Outline PPT 93

Reviewing and Revising Individual Slides PPT 94 Replace Dialog Box PPT 94 To Find and Insert a Synonym PPT 94 To Add Notes PPT 95 To Find and Replace Text PPT 96 Checking Spelling PPT 97 To Check Spelling PPT 98 To Add a Transition between Slides PPT 100 To Print Speaker Notes PPT 101 To Save and Print the Presentation PPT 102

Summary PPT 103 Apply Your Knowledge PPT 104 Extend Your Knowledge PPT 107 Expand Your World PPT 110 In the Labs PPT 111

MODULE THREE Reusing a Presentation and Adding Media and Animation Objectives PPT 121 Introduction PPT 121 Project — Presentation with Video, Audio,

Animation, and Photos with Effects PPT 121 Inserting Photos and Adding Effects PPT 123

To Insert and Resize a Photo into a Slide without Content Placeholders PPT 123

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

xii Contents Discovering Computers & Microsoft® Office 365™ Office 2016

Adjusting Photo Colors PPT 124 To Color a Photo PPT 124 To Add an Artistic Effect to a Photo PPT 125 To Change the Stacking Order PPT 126

Modifying Placeholders PPT 127 To Resize a Placeholder PPT 128 To Align Paragraph Text PPT 128 To Move a Placeholder PPT 129 To Delete a Placeholder PPT 130 Changing Views PPT 131 To Change Views PPT 131

Modifying and Copying an Illustration PPT 132 To Zoom a Slide PPT 133 To Ungroup an Illustration PPT 133 To Change the Color of a Clip Object PPT 134 To Delete a Clip Object PPT 136 To Regroup Objects PPT 137 To Copy a Clip from One Slide to Another PPT 138

Adding Media to Slides PPT 139 To Insert a Video File PPT 140 To Trim a Video File PPT 141 To Add Video Options PPT 142 To Insert an Audio File PPT 143 To Add Audio Options PPT 145 To Resize a Video PPT 147 To Add a Video Style PPT 147 To Add a Video Border PPT 148 To Change a Video Border Color PPT 149

Animating Slide Content PPT 150 Custom Animations PPT 150 To Animate an Illustration Using

an Entrance Effect PPT 150 To Change Animation Direction PPT 151 To Animate an Illustration Using

an Emphasis Effect PPT 152 To Animate an Illustration Using an Exit Effect PPT 153 To Change Exit Animation Direction PPT 154 To Preview an Animation Sequence PPT 154 To Modify Entrance Animation Timing PPT 155 To Modify Emphasis and Exit Timings PPT 156 To Animate Content Placeholder Paragraphs PPT 157

Customizing Slide Elements PPT 158 To Change the Theme and Variant on One Slide PPT 159 To Change the Theme Colors PPT 160 To Run a Slide Show with Media PPT 161 To Preview and Print a Handout PPT 161

Summary PPT 162 Apply Your Knowledge PPT 163 Extend Your Knowledge PPT 166 Expand Your World PPT 169 In the Labs PPT 170

Microsoft Excel 2016

MODULE ONE Creating a Worksheet and a Chart Objectives EX 1 Introduction EX 1 Project — Personal Budget Worksheet and a Chart EX 1 Selecting a Cell EX 4

Entering Text EX 4 To Enter the Worksheet Titles EX 5 AutoCorrect EX 7 To Enter Column Titles EX 7 To Enter Row Titles EX 9

Entering Numbers EX 9 To Enter Numbers EX 10

Calculating a Sum EX 12 To Sum a Column of Numbers EX 12

Using the Fill Handle to Copy a Cell to Adjacent Cells EX 13

To Copy a Cell to Adjacent Cells in a Row EX 14 To Calculate Multiple Totals at the Same Time EX 16 To Enter a Formula Using the Keyboard EX 18 To Copy a Cell to Adjacent Cells in a Row EX 19

Formatting the Worksheet EX 19 Font Style, Size, and Color EX 21 To Change a Cell Style EX 21 To Change the Font EX 22 To Apply Bold Style to a Cell EX 23 To Increase the Font Size of a Cell Entry EX 24 To Change the Font Color of a Cell Entry EX 25 To Center Cell Entries across Columns

by Merging Cells EX 26 To Format Rows Using Cell Styles EX 27 To Format Numbers in the Worksheet EX 29 To Adjust the Column Width EX 31 To Use the Name Box to Select a Cell EX 32 Other Ways to Select Cells EX 33

Adding a Pie Chart to the Worksheet EX 33 To Add a 3-D Pie Chart EX 35 To Apply a Style to a Chart EX 36

Changing the Sheet Tab Names EX 37 To Move a Chart to a New Sheet EX 38 To Change the Sheet Tab Name EX 39 Document Properties EX 40

Printing a Worksheet EX 41 To Preview and Print a Worksheet

in Landscape Orientation EX 41 Autocalculate EX 43

To Use the AutoCalculate Area to Determine a Maximum EX 44

Correcting Errors EX 45 Correcting Errors while Entering Data into a Cell EX 45 Correcting Errors after Entering Data into a Cell EX 45 Undoing the Last Cell Entry EX 46 Clearing a Cell or Range of Cells EX 47 Clearing the Entire Worksheet EX 48

Summary EX 49 Apply Your Knowledge EX 50 Extend Your Knowledge EX 52 Expand Your World EX 53 In the Labs EX 53

MODULE TWO Formulas, Functions, and Formatting Objectives EX 57 Introduction EX 57 Project — Worksheet with Formulas and Functions EX 58 Entering the Titles and Numbers into the Worksheet EX 60

To Enter the Worksheet Title and Subtitle EX 61

Copyright 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203

Discovering Computers & Microsoft® Office 365™ Office 2016 Contents xiii

To Enter the Column Titles EX 61 To Enter the Salary Data EX 62

Flash Fill EX 62 To Use Flash Fill EX 63 To Enter the Row Titles EX 64 To Change the Sheet Tab Name and Color EX 64

Entering Formulas EX 65 To Enter a Formula Using the Keyboard EX 65 Arithmetic Operations EX 66 Order of Operations EX 66 To Enter Formulas Using Point Mode EX 67 To Copy Formulas Using the Fill Handle EX 69

Option Buttons EX 70 To Determine Totals Using the Sum Button EX 70 To Determine the Total Tax Percentage EX 71

Using the AVERAGE, MAX, and MIN Functions EX 72 To Determine the Highest Number in a Range

of Numbers Using the Insert Function Dialog Box EX 72

To Determine the Lowest Number in a Range of Numbers Using the Sum Menu EX 74

To Determine the Average of a Range of Numbers Using the Keyboard EX 76

To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle EX 77

Verifying Formulas Using Range Finder EX 78 To Verify a Formula Using Range Finder EX 78

Formatting the Worksheet EX 79 To Change the Workbook Theme EX 80 To Format the Worksheet Titles EX 81 To Change the Background Color and Apply a Box

Border to the Worksheet Title and Subtitle EX 82 To Apply a Cell Style to the Column Headings and

Format the Total Rows EX 83 To Format Dates and Center Data in Cells EX 84 To Apply an Accounting Number Format and

Comma Style Format Using the Ribbon EX 85 To Apply a Currency Style Format with a Floating