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 .
Why are collaborative workspaces important?
  1. They promote teamwork and increase productivity during in-office meetings.
  2. They enable employees to work independently.
  3. They enable organizations to meet the diverse needs of their employees through remote work options.
  4. They make it more efficient for organizations to gather the information and resources needed to complete their work.
2 .
What is one way to convert a PDF file to a .docx file?
  1. Open the PDF with Word.
  2. Drag the file from your desktop to your Word document.
  3. Insert it as a linked object into your Word document.
  4. Copy and paste the text into your Word document.
3 .
Office’s common user interface fosters integration. What does this mean?
  1. The common user interface enables collaborative workspaces.
  2. The common user interface makes remote work possible.
  3. The common user interface allows users to share files, edit documents, and have virtual meetings in real time.
  4. The common user interface has a similar format and structure in different applications.
4 .
Which function is similar to cut and paste?
  1. linking
  2. embedding
  3. converting
  4. integrating
5 .
What happens to the content of an Excel worksheet when it is integrated into a Word document?
  1. When information in the Excel source file changes, if the file is integrated properly, the information will also be updated in the Word file.
  2. When information in the Excel source file changes, the information will not be updated in the Word file.
  3. The Excel data will insert into your Word document as a link.
  4. The Excel data will insert into your Word document as textual content.
6 .
What steps should you use to integrate a Word document into an Excel file?
  1. Select the Layout tab and use Page Setup.
  2. Select the Review tab and use the Changes command.
  3. Select the Insert Object function and put your cursor where the information should be placed in your Excel document.
  4. Select the Get Data function and click on the Query Options.
7 .
Where will an Excel table be inserted when embedding it into a Word document?
  1. at the cursor location
  2. at the top of the document
  3. at the bottom of the document
  4. as an icon in the heading
8 .
How do you embed Access data into Word documents?
  1. Choose Paste Special options or use classic copy and paste.
  2. Use Update Link, and the table will be embedded if you click that option.
  3. Choose References followed by Insert Table of Figures.
  4. Use Insert followed by SmartArt, and the table will be embedded if you click that option.
9 .
How do you access all of the slides that have been integrated into a Word document?
  1. from the Review tab
  2. by double-clicking on the slide image in the document
  3. by pressing Page down
  4. by using Ctrl+Click
10 .
When adding Word documents to PowerPoint slides, what happens if you don’t choose the Link box?
  1. The Word document will be embedded into the slide, rather than linked.
  2. The Word document will be linked, but you will be unable to make any changes to it.
  3. The Word document will be embedded, with a picture of the information inserted into the PowerPoint slide.
  4. The Word document will be linked, but you will have to retype some of the information to make it display properly in PowerPoint.
11 .
__________ makes the PowerPoint file part of the Excel file and increases its file size.
  1. linking
  2. embedding
  3. inserting as a picture
  4. display as icon
12 .
What approach should you use to link only certain information from an Excel file into a PowerPoint slide?
  1. Use the Insert tab, Choose Link approach.
  2. Use the standard copy-and-paste approach.
  3. Use the Paste Special approach.
  4. Use the Display as icon approach.
13 .
What is the disadvantage of inserting an Excel chart into a PowerPoint slide as a JPEG or PNG image?
  1. The image is simply a copy that cannot be moved around once it is inserted into a PowerPoint slide.
  2. The image is simply a copy that cannot be integrated.
  3. The image is simply a copy that cannot be duplicated to use on more than one slide.
  4. The image is simply a copy that cannot be updated.
14 .
To easily export Access data to Excel, what should you do to the database information?
  1. Format the information.
  2. Convert the information to a JPEG file.
  3. Filter the information.
  4. Drop the information into a table in a Word document.
15 .
What is required to import an Excel file into an Access database?
  1. header text with appropriate spaces
  2. a blank database
  3. a JPEG image that can be double-clicked to edit the Excel file from Access
  4. a table from a Word document that can integrate the Excel information
16 .
What is one way to insert a chart from Google Sheets into Google Docs?
  1. You can go to the Insert window menu and use the mouse to choose Chart and then From Sheets.
  2. You can drag the chart from Google Sheets to Google Docs, as long as they are in separate windows.
  3. You can use the mouse to select the browser window where Google Sheets is located and then insert the browser window on Google Docs.
  4. You can use the Print Screen key on the keyboard to copy the chart and then press Ctrl+V at the position where you want to place the chart in Google Docs.
17 .
Which option will preserve much of your formatting in an Excel sheet when bringing it into Sheets?
  1. Import command
  2. copy and paste
  3. copy and paste without formatting
  4. Preview
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.