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

Practice Exercises

23 .
(a) Table with four columns and 5 rows labeled Location X is highlighted. (b) Same table copied, but now labeled Location Y displays different information in column D from table in (a). Using part (a) of the figure, move to the next column to the right. This new column will be for adding the average. This average can easily be calculated by typing the AVERAGE function. Research the syntax and use it in the new column. Once you find the average, copy the formula down the column.
24 .
WorldCorp’s sales team uses a customer relations management (CRM) software that gives the user the option to export data. This exported data needs to be formatted when you open it with Excel. Design a table with the following headers: Date, Product, Qty, Price per Unit, Total Value, and Notes and preformat each column based on its respective type of data.
25 .

Using the table from the last exercise, add the data shown in the following table. Insert a calculation for the total value instead of typing in the dollar amount from the table.

Date Product Price Qty Total
12/20/2020 Headphones $48.00 57 $2,736.00
12/28/2020 Headphones $48.00 74 $3,552.00
1/3/2021 LED 65 $780.00 13 $10,140.00
1/3/2021 Headphones $48.00 9 $432.00
1/5/2021 Headphones $48.00 10 $480.00
1/7/2021 OLED 45 $48.00 77 $30,800.00
1/8/2021 LED 65 $780.00 14 $10,920.00
1/8/2021 Headphones $48.00 16 $768.00
1/11/2021 LCD 42 $380.00 48 $18,240.00
1/13/2021 Plasma 65 $855.00 12 $10,260.00
1/13/2021 Headphones $48.00 85 $4,080.00
1/15/2021 Headphones $48.00 158 $7,584.00
1/17/2021 LCD 42 $380.00 55 $20,900.00
1/17/2021 Headphones $48.00 115 $5,520.00
1/21/2021 Plasma 65 $855.00 11 $9,405.00
1/22/2021 Headphones $48.00 15 $720.00
1/25/2021 LCD 42 $380.00 54 $20,520.00
1/27/2021 QLED 55 $620.00 10 $6,200.00
1/30/2021 LED 55 $550.00 10 $5,500.00
2/4/2021 LCD 32 $170.00 43 $7,310.00
2/7/2021 QLED 55 $620.00 15 $9,300.00
2/9/2021 OLED 45 $400.00 37 $14,800.00
2/11/2021 Plasma 65 $855.00 34 $29,070.00
2/15/2021 DLP 32 $250.00 97 $24,250.00
2/18/2021 LED 65 $780.00 54 $42,120.00
2/21/2021 LED 55 $550.00 21 $11,550.00
2/25/2021 LCD 42 $380.00 54 $20,520.00
2/27/2021 LCD 32 $170.00 14 $2,380.00
Table 9.2
26 .
Refer to Figure 9.23
.
Use the figure to find the average of the marginal profit value. First, determine the total volume sold and total marginal profit. Then, divide those two numbers to find the average marginal profit per unit sold. Design this extended table.
27 .
Refer to Figure 9.24
.
WorldCorp handed you an assignment to use the figure to determine the FOB $ average of all orders and then to compare the average order and the invoice order individually in a new column. Create the new column to show the difference between each individual order and the FOB $ average. Finally, divide that difference by the FOB $ to get a percent difference. Be sure to format the data as a percentage. Construct this table.
28 .
WorldCorp sells various business tablets that are designed to be rugged. In the past month, the model FE-546 sold 435, the model FR-765 sold 324, and the model FH-985 sold 213. They cost $356, $467, and $586, respectively. Construct a table with these values. Include a total column as well.
29 .
Refer to Figure 9.28
.
Using the data in the figure, construct a line chart comparing dates and sales. Build this chart. Look for information on the internet on how to build basic graphs using Excel.
30 .
Your manager at WorldCorp asks you to design a sales report with the following columns: date, model, price, quantity, and sales total. Enter four different fictional orders in the table. Use formatting that you feel is appropriate for the header rows.
31 .
Your manager at WorldCorp tells you to print the document. Explain in detail what you would do to print five copies of the document, which contains only one worksheet.
32 .
WorldCorp makes many products and sells them to thousands of customers. The sales team keeps call logs for when they make calls to their corporate clients to generate sales. These clients are retailers that buy directly from WorldCorp because of the volume discount. Design and create a call log with the date of the call, the purchasing executive’s name, the client’s name, the phone number, and the order details. The order details are separated in different columns for text description, units, sale value, and optional notes. These optional notes contain special delivery requests from the client. Use the cell formatting methods you have learned so far.
33 .
Create an address book using information for four friends or family members. The table should include their names, street addresses, phone numbers, and email addresses. Their street addresses should be separated into four columns: the street and house/apartment number, the city, the state, and the zip code. Use the formatting methods you have learned so far.
34 .

WorldCorp is releasing a new universal remote control model that has a touch screen and is programmable for any model of TV, stereo, cable box, and movie player. The sales figures for the preorders need to be added together by location and then multiplied by the price per unit to get the final sales figures. Enter the data into Sheets and complete the table using functions.

Item Description - Digital touch screen remote control. Row 4 headings: Date, Location X, Location Y, Location Z. Row 5: 5/24/2021, 424, 986, 883. Row 6 lists: 17/2021, 864, 332, 554. Row 7: 2/19/2021, 429, 446, 473. Row 8: Total Sales – blank. Row 9: Price per Unit – 76.88 in all. Row 10: Revenue – blank.
35 .
WorldCorp sells tablets to educational organizations. Each basic tablet’s price is $157.64, on a discounted rate because they are purchased for hundreds of students. The tablet comes with its own keyboard, all in one package. WorldCorp sold 654 in Fairfax, Virginia; 867 in Portland, Maine; and 532 in Deeville, Texas. Make a table forecasting the revenues of each location. Compare the locations with the total sales revenue using a proportion. Make a graph comparing these three locations’ performances. Use the best practices discussed in the chapter for designing tables.
36 .
WorldCorp sells tablets to educational organizations. Each basic tablet’s price is $157.64, on a discounted rate because they are to be bought for hundreds of students. The tablet comes with its own keyboard, all in one package. WorldCorp sold 654 in Fairfax, Virginia; 867 in Portland, Maine; and 532 in Deeville, Kansas. Make a table forecasting the revenues of each location. Use a conditional formatting of “Greater than” and set the minimum to be $100,000. Explain the significance of the conditional formatting in these three revenue comparisons.
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.