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 .
Excel is a spreadsheet software that can design sales report tables and calculate math equations using ______.
  1. data, lines, and rectangles
  2. calculators, graph paper, text
  3. numbers, GUI, WordArt
  4. cells, formulas, and functions
2 .
What is the primary difference between worksheets and workbooks?
  1. Worksheets are tabs in a workbook.
  2. Workbooks are tabs in a worksheet.
  3. Worksheets are cells in a workbook.
  4. Workbooks are cells in a worksheet.
3 .
Which command can be used to paste information that was recently copied?
  1. Ctrl+C
  2. Ctrl+A
  3. Ctrl+V
  4. Ctrl+=
4 .
What is the cell format that lets you type long numbers using just the first three digits?
  1. Scientific
  2. Date
  3. Accounting
  4. General
5 .
What are examples of the benefits of using both numerical and text data in your worksheet but keeping them in separate columns?
  1. Numerical data can be combined with text data for writing descriptions of objects and their measurements.
  2. Text data can be used for autofilling a calculation of multiple scenarios.
  3. Numerical data can be used in accounting, dates, or number formats, while text is used for descriptions or headers.
  4. Text and numerical data are easily typed and interpreted by Excel, as it can read words, thus they can be used for computable lists.
6 .
What is a benefit of preformatting cells in Excel?
  1. You can automatically fill the data without typing it by inserting an image from the phone.
  2. You can type the data and Excel will apply the format, so it looks how you want it to.
  3. You can send a Bluetooth connection to the data, and it will be autofilled.
  4. You can use the cell references to do mathematical operations.
7 .
What are the two methods to add numbers in Excel?
  1. using the SUM function and the “+” sign in formulas
  2. using constants and cell references
  3. using variables and constants
  4. using functions such as PRODUCT and constants
8 .
The ______ function does not have the same functionality compared with the “/” because it does not return a full answer if it has decimals.
  1. DIVISION
  2. PRODUCT
  3. QUOTIENT
  4. PROPORTION
9 .
Where in the ribbon can you change the font?
  1. You can change the font in the Alignment command group on the Home tab.
  2. You can change the font in the Text command group on the Insert tab.
  3. You can change the font in the Symbols command group on the Insert tab.
  4. You can change the font in the Font command group on the Home tab.
10 .
Identify the steps for automatically highlighting any cells from a column that are greater than a certain number.
  1. Select the cell you want to analyze, click on Conditional Formatting, go to Highlight cell rules, click Greater than, and set the parameters.
  2. Select the column in question, then click on Conditional Formatting, go to Highlight cell rules, click Greater than, and set the parameters.
  3. Select the column in question, then click on Conditional Formatting, go to Highlight cell rules, click Between, and set the parameters.
  4. Select the cell you want to analyze, click on Conditional Formatting, go to Highlight cell rules, and click Top 10%.
11 .
Where do you find the Spell check command in Sheets?
  1. Format menu
  2. Extensions menu
  3. Tools menu
  4. File menu
12 .
______ is the process to select two noncontiguous cell ranges.
  1. Ctrl+Select
  2. Shift+Select
  3. mouse left-click select
  4. mouse right-click select
13 .
What commands or tools are found on the toolbar?
  1. all the options that are contained on the Tools menu
  2. tools that the user selects to be placed on the toolbar
  3. the more widely used tools/commands
  4. all of the commands and tools from the File and Data menus
14 .
What menu would you use to add cells in a worksheet in Sheets?
  1. Tools
  2. Insert
  3. Edit
  4. Data
15 .
Double-clicking on the cell edge between the column header row will ______.
  1. change the format of the cell to financial
  2. automatically resize the column width to the data in the column
  3. remove the data in that column
  4. highlight the column for graphing
16 .
Where will you find the Themes settings in Sheets?
  1. Format menu
  2. Insert menu
  3. action bar
  4. Page Layout menu
17 .
What is the function name for subtracting in Sheets?
  1. There is none.
  2. MINUS
  3. SUBTRACT
  4. DIFFERENCE
18 .
______ is the name of the function for multiplication of two values in Sheets.
  1. PRODUCT
  2. TIMES
  3. MULTIPLY
  4. RESULT
19 .
What is the difference between the QUOTIENT and DIVIDE functions?
  1. DIVIDE gives you decimals in the result, and QUOTIENT gives you whole numbers.
  2. There is no difference; they will always produce the same answer.
  3. QUOTIENT will give a result with the first two decimal places, whereas DIVIDE gives a result that includes all decimal places.
  4. You can use QUOTIENT in Sheets, and you can use DIVIDE in Excel.
20 .
What would be a general header style most favored by the corporate world?
  1. leaving it plain text, as it can be easily read by Sheets
  2. aligning the text to the right, applying a bright color background, and plain type
  3. applying bold text, with no background or alignment
  4. applying a background color shading, bold font, and center aligned
21 .
How do you look for public templates in Sheets?
  1. You need to go to the Welcome screen, and search for templates there.
  2. You need to go to Google.com, and type “X template site:docs.google.com”.
  3. You can’t because Sheets doesn’t have access to public templates.
  4. You can look for Microsoft Word templates because they work in Sheets, too.
22 .
What is the main difference between freezing panes in Excel and in Sheets?
  1. In Sheets, you can choose the row or column at any part of the worksheet.
  2. In Excel, you can choose the row or column at any part of the worksheet.
  3. In Sheets, you can only start the pane freeze at the first row or column.
  4. Both are the same in all aspects.
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.