Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Review Questions

1 .
How does having a clear purpose for your presentation help you connect to your audience?
  1. It helps ensure that your presentation is coherent.
  2. It helps ensure that your presentation is consistent.
  3. It helps ensure that your presentation is relevant.
  4. It helps ensure that your presentation has an appropriate outline.
2 .
A consistent color scheme should have ________.
  1. elements that work together
  2. a uniform look and feel
  3. a focal point
  4. a key message
3 .
To determine the appropriate number of slides for your presentation, you should consider ________.
  1. whether the presentation will be delivered in person or via technology such as Zoom
  2. the needs of your audience
  3. the software you use to create the presentation
  4. the category of the presentation
4 .
To create an effective plan for your presentation, you should ________.
  1. focus on consistent design quality
  2. ensure the slideshow has a coherent design quality
  3. make sure that you tell a story throughout the presentation
  4. define the layout of your slides
5 .
The ________ in a presentation refers to the overall design and layout of the slides.
  1. title slide
  2. variants
  3. theme
  4. Slide Master
6 .
If you wanted to change the overall color style of a theme you are using, which option would be best?
  1. Go to the Design tab, then Variants.
  2. Go to the Home tab, then Slides.
  3. Go to the Insert tab, then Text.
  4. Go to the View tab, Outline View.
7 .
On the Home tab, the ________ command enables you to work with elements in your presentation such as adding bullets and aligning text.
  1. Layout
  2. Font
  3. Paragraph
  4. Design Ideas
8 .
What is the advantage of the Design tab over the Design Ideas feature?
  1. The Design tab has an on/off button that provides advanced slide layouts.
  2. The Design tab enables you to adjust elements of your presentation such as line spacing and columns.
  3. The Design tab offers the option of using a blank, white canvas to build your presentation.
  4. The Design tab provides a collection of tools that enable you to change layout designs for all of your slides at once.
9 .
To add a slide to your presentation, which option on the View tab should you select?
  1. Notes View
  2. Slide Sorter View
  3. Reading View
  4. Outline View
10 .
What type of slide layout offers the best way to present two or more different types of information in a presentation?
  1. Content with Caption
  2. Section Header
  3. Comparison
  4. Title and Content
11 .
_________ refers to the use of similar or identical elements, such as colors, fonts, or design elements, across multiple slides in a presentation.
  1. Repetition
  2. Contrast
  3. Alignment
  4. Proximity
12 .
A table in PowerPoint is used to ________.
  1. add special effects to text
  2. create charts and graphs
  3. present information in an organized format
  4. add images and videos
13 .
You need a picture of a squirrel for your presentation, but you have been unable to take one with your cell phone. What could you do instead?
  1. Use the WordArt tool.
  2. Use 3D models.
  3. Use SmartArt.
  4. Use a stock image.
14 .
WordArt in PowerPoint is used to ________.
  1. add special effects to text
  2. create charts and graphs
  3. add images and videos
  4. organize slides into sections
15 .
Why would you use a visual hierarchy in your presentation?
  1. to emphasize certain points
  2. to make the presentation more engaging
  3. to minimize distractions in the presentation
  4. to guide a viewer’s eyes to the most important information
16 .
As part of your presentation, you need to present data to your audience. To do this, which type of illustration should you select?
  1. SmartArt
  2. icons
  3. charts
  4. 3D models
17 .
What is a distinct feature of Slides that is not present in PowerPoint?
  1. changing ribbon
  2. drop-down boxes from each tab
  3. File, View, and Insert menus
  4. thumbnails on the left side
18 .
What is a primary difference between Slides and PowerPoint?
  1. Slides is a web-based software application, while PowerPoint is a stand-alone software program.
  2. PowerPoint is recommended for online collaboration, while Slides is best for self-contained work.
  3. Slides can only be used offline, while PowerPoint is ideal for mobile application devices.
  4. PowerPoint can only be used through cloud-based applications, while Slides is a desktop application.
19 .
If your workplace uses only Microsoft products, which program would be a better choice for creating a slideshow, and why?
  1. PowerPoint, because it is more feature-rich than Slides
  2. PowerPoint, because it is advantageous to remain within your workplace’s software ecosystem
  3. Slides, because it is more user-friendly than PowerPoint
  4. Slides, because it is better for online collaboration
20 .
When you convert your presentation from PowerPoint to Slides, some of the font effects are missing. Why does this happen?
  1. Slides is a desktop application.
  2. Slides does not include Illustrations tools.
  3. Slides is a web-based software application.
  4. Slides does not always convert WordArt consistently.
21 .
Which drop-down menu in Slides is best to access line spacing options for text?
  1. Insert
  2. Slide
  3. Arrange
  4. Format
22 .
To add a border to a text box in Slides, you must first do what?
  1. Copy the text.
  2. Select the text box,
  3. Go to the Format menu.
  4. A border cannot be added to a text box in Slides.
23 .
Which tool in Slides helps you change the layout of your slides?
  1. Slide menu
  2. Apply Layout
  3. Change Background
  4. Edit Theme
24 .
When adding images to your Slides presentation, what should you remember?
  1. Only copyrighted and trademarked images should be used.
  2. Before you insert the images into your presentation, they must be the correct size.
  3. You should use the Format menu to insert images.
  4. The images can come from any source, including pictures on your smartphone.
25 .
What is the advantage of using diagrams in a Slides presentation?
  1. Slides automatically designs any diagram that you select.
  2. You can copy and paste diagrams from other sources without making any modifications.
  3. You can present complex information in a simple and intuitive way.
  4. Diagrams make it easier to quickly create a presentation.
26 .
To present numerical data to your audience during a presentation using Slides, what tool(s) should you use?
  1. shapes and/or diagrams
  2. text boxes
  3. tables and/or charts
  4. images
27 .
Why are special characters useful in presentations?
  1. They add effects to text and make it more prominent.
  2. They add visual interest or convey specific meanings.
  3. They enable you to add images to a presentation.
  4. They are the most appropriate tools for presenting numerical data.
28 .
When using links in your presentation, what should you remember?
  1. Links are important tools and should be used extensively in presentations.
  2. Links can be used to make a presentation more visually appealing.
  3. Links can be distributed to your audience electronically for their personal access.
  4. Links should not be used if you have screenshots of the information you want to present.
Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.