Introduction xxi Assessment Test xliii Part I Computing Fundamentals 1 Chapter 1 Understanding Operating Systems 3 Operating Systems and Their Roles When Using Computers and Devices 5 What Is Hardware? 5 What Is Software? 6 What Is an Operating System? 6 How Do They All Work Together? 7 Accessing and Locking the Operating System 9 Software and System Updates 12 Working with Files, Folders, and Libraries 17 Accessing Your Files and Folders 18 Understanding File Types 22 Managing Your Files and Folders 24 Customizing Your Computer 32 Customizing the Desktop 32 Understanding User Accounts 45 Summary 51 Exam Essentials 52 Key Terms 52 Review Questions 53 Chapter 2 Understanding Hardware 55 The Internal Hardware Components of a Computer 57 Peripheral Devices That Can Be Connected to a Computer 59 The Most Common Types of Computers and Devices 62 How Information Is Transmitted inside a Computer 65 How to Evaluate the Performance of a Computer or Device 66 Summary 71 Exam Essentials 72 Key Terms 72 Review Questions 74 Chapter 3 Understanding Software 77 The Dependencies between Hardware and Software 79 Installing, Removing, or Reinstalling Software 81 Software Licensing and Its Implications 91 The Most Common Types of Office Applications 96 Using Templates to Get Started with an Application 98 Personal Entertainment Applications 101 Compressing Files to Save Space 101 Optimizing Your Computer''s Hard Disk Performance 103 Protecting Yourself from Malware 108 Summary 109 Exam Essentials 110 Key Terms 111 Review Questions 112 Chapter 4 Troubleshooting Problems with Your Computer 115 Dealing with Problems Caused by Software 117 Dealing with Incompatibilities between the Operating System Version and Your Applications 118 Dealing with Unresponsive Applications 121 Dealing with Applications That Consume Too Many Resources 124 Dealing with Malware Infections 126 Using Safe Mode to Fix Problems with Windows 129 Finding Help Online 131 Dealing with Problems Caused by Hardware 132 Dealing with Problems Caused by Cables and Connectors 132 Upgrading the Firmware for Your Computer''s Components and Peripherals 133 Dealing with Drivers for Your Computer''s Hardware 135 Creating Your Own Backup System 140 Backing Up Your Data with Backup and Restore 140 Restoring Your Data with Backup and Restore 145 Backing Up Your Data to the Cloud with OneDrive 150 Summary 156 Exam Essentials 156 Key Terms 157 Review Questions 158 Part II Key Applications 161 Chapter 5 Exploring Common Application Features in Microsoft Office 163 Creating New Empty Documents with Microsoft Office 166 Starting and Closing Microsoft Office Applications 167 Opening and Closing Microsoft Office Files 168 Creating New Empty Files with Microsoft Office 169 Saving Your Microsoft Office Files 171 Working with Several Windows at the Same Time 175 The Basics of Using Microsoft Office Applications 180 Keyboard Shortcuts for Using the Ribbon Productively 180 Selecting, Copying, and Moving Data When Using Microsoft Office Applications 184 Dragging and Dropping Data When Using Microsoft Office Applications 193 Finding and Replacing Data in Your Microsoft Office Documents 194 Checking the Spelling of Your Microsoft Office Documents 197 Undoing Your Changes and Mistakes When Working with Microsoft Office Documents 200 Hiding Your Data from Tables and Charts 201 Selecting Non-adjacent Cells in Microsoft Excel Tables 203 Sorting Data When Working with Microsoft Excel Files 205 Adjusting the Way You View Microsoft Office Files 207 Adjusting the Size and the Orientation of Your Microsoft Office Files 211 Printing Your Documents from Microsoft Office 213 Where to Get Help with Using Microsoft Office 214 The Basics of Formatting Your Microsoft Office Files 217 Formatting the Text in Your Documents 217 Using Styles to Format Your Documents 220 Working with Multimedia Files in Microsoft Office 224 Adding Multimedia Files to Your Presentations 224 Adjusting the Pictures Used in Your Presentations 228 Summary 231 Exam Essentials 232 Key Terms 233 Review Questions 234 Chapter 6 Using Microsoft Word 237 Configuring the Layout of Your Documents 238 Adjusting Line and Paragraph Spacing in Your Documents 238 Aligning the Text in Your Documents 241 Organizing Your Documents into Columns 245 Setting the Margins of Your Documents 246 Displaying the Ruler When Editing Documents 249 Indenting the Text in Your Documents 250 Using Tabs to Control Where the Text Is Placed in Your Documents 254 Organizing the Data in Your Documents 258 Creating Bulleted and Numbered Lists 259 Sorting Single?]Level Lists 260 Creating Tables 262 Adding or Removing Rows and Columns in Your Tables 265 Merging and Splitting Cells in Your Tables 266 Adding Page Numbers to Your Documents 269 Summary 273 Exam Essentials 273 Key Terms 273 Review Questions 274 Chapter 7 Using Microsoft Excel 277 Navigating among Worksheets, Workbooks, and Cells 278 Navigating between Worksheets 279 Navigating between Cells 280 Changing the Alignment and the Positioning of Cells 284 Changing the Size of Cells 287 Formatting How Cells Are Displayed 290 Adding and Removing Rows and Columns 292 Merging or Unmerging Cells 295 Using Number Formats in Microsoft Excel Workbooks 297 Sorting and Filtering Data 299 Sorting Data 300 Filtering Data 302 Using Common Formulas and Functions 304 Using Mathematical Operators 305 Using Relative and Absolute References 307 Using Functions 310 Adding Charts and Graphs 313 Inserting a Line Chart 315 Inserting a Pie Chart 317 Inserting a Bar Graph 319 Summary 321 Exam Essentials 321 Key Terms 322 Review Questions 323 Chapter 8 Using Microsoft PowerPoint 325 Adding and Removing Slides When Creating Presentations 327 Changing the Order of Your Slides 330 Changing the Design and the Background of Your Presentations 331 Adding and Formatting the Text in Your Presentations 334 Changing the Layout of Your Slides 337 Adding Shapes and Pictures to Your Slides 339 Adding Tables to Your Presentations 342 Formatting the Tables in Your Presentations 345 Adding Charts to Your Presentations 348 Adding Video and Other Multimedia Files to Your Presentations 350 Adding Animations to Your Presentation 352 Setting Transitions between Slides and Viewing Your Presentations 355 Summary 357 Exam Essentials 358 Key Terms 358 Review Questions 359 Chapter 9 Using Microsoft Access 361 Adding, Modifying, and Removing Data in a Microsoft Access Database 362 Using Search in a Microsoft Access Database 367 Using Stored Queries in a Microsoft Access Database 370 Running Predefined Reports in a Microsoft Access Database 372 Creating Simple Reports in a Microsoft Access Database 373 Summary 379 Exam Essentials 380 Key Terms 380 Review Questions 381 Chapter 10 Collaborating with Others When Working in Microsoft Office 383 Adding Comments to Your Microsoft Office Files 384 Reviewing the Comments That Were Added to a Document 387 Tracking Changes in a Microsoft Word Document 388 Reviewing Changes in a Microsoft Word Document 390 Sharing Your Work Files Using Email 393 Storing Documents Using Network Attached Storage Solutions 396 Storing Documents Using Cloud Storage Solutions 398 Summary 400 Exam Essentials 400 Key Terms 401 Review Questions 402 Part III Living Online 405 Chapter 11 Using the Internet 407 Understanding the Terminology about the Internet and the WWW 408 Understanding the World Wide Web 410 Standard Domain Names 410 Special Domain Names 411 Understanding Hyperlinks 411 Browsing the Web with a Web Browser 412 Using Multiple Tabs While Browsing the Web 417 Downloading and Uploading Files on the Web 419 Setting a Homepage in Your Web Browser 420 Using and Clearing Your Browsing History 423 Using Favorites or Bookmarks in Your Web Browser 428 Searching for Text in a Web Page from Your Web Browser 433 Using Plug?]ins, Add?]ons, and Extensions in Your Web Browser 435 Summary 436 Exam Essentials 436 Key Terms 437 Review Questions 438 Chapter 12 Understanding Networking and Its Most Important Concepts 441 Understanding Networks: LAN vs. WAN 442 Understanding Network Addressing 445 IP Addresses 445 The Domain Name Service 446 Private IPv4 Address Ranges 448 Using and Securing Wireless Networks 449 Changing How You Authenticate to Wireless Access Points 450 Setting the Encryption for Your Wireless Network 451 Security Networks with Firewalls and Gateways 452 Using a Firewall 453