DELETE THIS TEXT AND INSERT COVER HERE
,OpenStax Workplace Software and Skills Instructor Answer Guide
OpenStax Workplace Software and Skills
Instructor Answer Guide
Chapter 1: Technology in Everyday Life and Business .................................................................... 3
Chapter 2: Essentials of Software Applications for Business ........................................................ 14
Chapter 3: Creating and Working in Documents .......................................................................... 29
Chapter 4: Document Preparation ............................................................................................... 45
Chapter 5: Advanced Document Preparation............................................................................... 66
Chapter 6: Preparing Presentations.............................................................................................. 92
Chapter 7: Advanced Presentation Skills .................................................................................... 107
Chapter 8: Content Management Systems and Social Media in Business ................................. 124
Chapter 9: Working with Spreadsheets ...................................................................................... 136
Chapter 10: Advanced Excel Formulas, Functions, and Techniques .......................................... 156
Chapter 11: Advanced Excel Spreadsheets: Statistical and Data Analysis ................................. 174
Chapter 12: Using Excel in Accounting and Financial Reporting ................................................ 193
Chapter 13: Understanding and Using Databases ...................................................................... 199
Chapter 14: Advanced Database Use ......................................................................................... 211
Chapter 15: Integrating Applications .......................................................................................... 225
For more free, peer-reviewed, openly licensed resources visit OpenStax.org.
2 5/26/26
,OpenStax Workplace Software and Skills Instructor Answer Guide
Chapter 1: Technology in Everyday Life and Business
Review Questions
1. What nineteenth-century invention laid the foundation for future developments in
computing?
a. Jacquard’s loom
[Correct. Jacquard developed a machine that used a punch card system to automatically
weave designs in fabric.]
b. Apple’s Macintosh computer
[Apple’s Macintosh computer was launched in January 1984.]
c. Programma 101
[The Programma 101, a programmable calculator, was developed in 1964.]
d. TRS-80
[TRS-80 was launched by Tandy in the late 1970s.]
[Answer: A]
2. What is the main operating system for iPhone mobile devices?
a. Android
[The Android operating system is used to operate Google programs.]
b. Google
[Google is not an operating system.]
c. iOS
[Correct. iOS is Apple’s operating system, used to run iPhones.]
d. SMS
[SMS stands for short message service.]
[Answer: C]
3. What are direct deposit, high-speed printers/copiers, and automated inventory systems all
examples of?
a. outdated technology
[These advances in technology are used today.]
b. future developments in technology
[These are technological advances currently in use.]
c. early-stage developments in technology
[These are examples of technology in use today.]
d. advances in technology
[Correct. These are all examples of advances in technology.]
[Answer: D]
4. What is VR?
a. a mostly live, real environment with some digital elements embedded
[VR is mostly simulated, not mostly live.]
b. a computerized game for trying out a new product
[VR may be used in a computerized game, but this is not the definition of VR.]
c. a robot that can perform mundane tasks
[A robot is not virtual reality.]
For more free, peer-reviewed, openly licensed resources visit OpenStax.org.
5/26/2026 3
, OpenStax Workplace Software and Skills Instructor Answer Guide
d. a mostly simulated environment that allows the user to interact in the space
[Correct. VR is a mostly simulated environment that allows user interaction.]
[Answer: D]
5. The autopilot features on an airplane are an example of ________.
a. VR
[VR is a mostly simulated environment that allows the user to interact in the space.]
b. AI
[Correct. The use of autopilot is an example of advances in artificial intelligence.]
c. AR
[AR is a mostly live environment with some virtual elements.]
d. machine learning
[Machine learning is the use of software applications to make computations and
decisions.]
[Answer: B]
6. ________ is referred to as "the brains of the computer system."
a. Printer
[A printer is an additional piece of hardware outside of the computer itself.]
b. Mainframe
[A mainframe is part of a network of computers, used to process a great deal of data.]
c. Microprocessor
[Correct. The microprocessor is contained in the CPU and performs math and logical
operations within a computer system.]
d. Router
[A router is used to connect to the internet.]
[Answer: C]
7. ________ allows the computer to operate and process information quickly.
a. ROM
[ROM is memory that is not intended to be stored but to process information as it is
being used.]
b. RAM
[Correct. RAM is the primary, short-term memory that is used to process information
quickly.]
c. HTTP
[HTTP is the protocol that allows communication through the internet.]
d. WAN
[Wide area networks (WANs) allow access to regional service providers.]
[Answer: B]
8. What is a network adapter card that organizes information into small packets for movement
in the network or over the internet?
a. TCP (transmission control protocol)
[Correct. TCP identifies the devices sending and receiving data and organizes the
information into small packets.]
b. HTTP (hypertext transfer protocol)
For more free, peer-reviewed, openly licensed resources visit OpenStax.org.
4 5/26/26
,OpenStax Workplace Software and Skills Instructor Answer Guide
OpenStax Workplace Software and Skills
Instructor Answer Guide
Chapter 1: Technology in Everyday Life and Business .................................................................... 3
Chapter 2: Essentials of Software Applications for Business ........................................................ 14
Chapter 3: Creating and Working in Documents .......................................................................... 29
Chapter 4: Document Preparation ............................................................................................... 45
Chapter 5: Advanced Document Preparation............................................................................... 66
Chapter 6: Preparing Presentations.............................................................................................. 92
Chapter 7: Advanced Presentation Skills .................................................................................... 107
Chapter 8: Content Management Systems and Social Media in Business ................................. 124
Chapter 9: Working with Spreadsheets ...................................................................................... 136
Chapter 10: Advanced Excel Formulas, Functions, and Techniques .......................................... 156
Chapter 11: Advanced Excel Spreadsheets: Statistical and Data Analysis ................................. 174
Chapter 12: Using Excel in Accounting and Financial Reporting ................................................ 193
Chapter 13: Understanding and Using Databases ...................................................................... 199
Chapter 14: Advanced Database Use ......................................................................................... 211
Chapter 15: Integrating Applications .......................................................................................... 225
For more free, peer-reviewed, openly licensed resources visit OpenStax.org.
2 5/26/26
,OpenStax Workplace Software and Skills Instructor Answer Guide
Chapter 1: Technology in Everyday Life and Business
Review Questions
1. What nineteenth-century invention laid the foundation for future developments in
computing?
a. Jacquard’s loom
[Correct. Jacquard developed a machine that used a punch card system to automatically
weave designs in fabric.]
b. Apple’s Macintosh computer
[Apple’s Macintosh computer was launched in January 1984.]
c. Programma 101
[The Programma 101, a programmable calculator, was developed in 1964.]
d. TRS-80
[TRS-80 was launched by Tandy in the late 1970s.]
[Answer: A]
2. What is the main operating system for iPhone mobile devices?
a. Android
[The Android operating system is used to operate Google programs.]
b. Google
[Google is not an operating system.]
c. iOS
[Correct. iOS is Apple’s operating system, used to run iPhones.]
d. SMS
[SMS stands for short message service.]
[Answer: C]
3. What are direct deposit, high-speed printers/copiers, and automated inventory systems all
examples of?
a. outdated technology
[These advances in technology are used today.]
b. future developments in technology
[These are technological advances currently in use.]
c. early-stage developments in technology
[These are examples of technology in use today.]
d. advances in technology
[Correct. These are all examples of advances in technology.]
[Answer: D]
4. What is VR?
a. a mostly live, real environment with some digital elements embedded
[VR is mostly simulated, not mostly live.]
b. a computerized game for trying out a new product
[VR may be used in a computerized game, but this is not the definition of VR.]
c. a robot that can perform mundane tasks
[A robot is not virtual reality.]
For more free, peer-reviewed, openly licensed resources visit OpenStax.org.
5/26/2026 3
, OpenStax Workplace Software and Skills Instructor Answer Guide
d. a mostly simulated environment that allows the user to interact in the space
[Correct. VR is a mostly simulated environment that allows user interaction.]
[Answer: D]
5. The autopilot features on an airplane are an example of ________.
a. VR
[VR is a mostly simulated environment that allows the user to interact in the space.]
b. AI
[Correct. The use of autopilot is an example of advances in artificial intelligence.]
c. AR
[AR is a mostly live environment with some virtual elements.]
d. machine learning
[Machine learning is the use of software applications to make computations and
decisions.]
[Answer: B]
6. ________ is referred to as "the brains of the computer system."
a. Printer
[A printer is an additional piece of hardware outside of the computer itself.]
b. Mainframe
[A mainframe is part of a network of computers, used to process a great deal of data.]
c. Microprocessor
[Correct. The microprocessor is contained in the CPU and performs math and logical
operations within a computer system.]
d. Router
[A router is used to connect to the internet.]
[Answer: C]
7. ________ allows the computer to operate and process information quickly.
a. ROM
[ROM is memory that is not intended to be stored but to process information as it is
being used.]
b. RAM
[Correct. RAM is the primary, short-term memory that is used to process information
quickly.]
c. HTTP
[HTTP is the protocol that allows communication through the internet.]
d. WAN
[Wide area networks (WANs) allow access to regional service providers.]
[Answer: B]
8. What is a network adapter card that organizes information into small packets for movement
in the network or over the internet?
a. TCP (transmission control protocol)
[Correct. TCP identifies the devices sending and receiving data and organizes the
information into small packets.]
b. HTTP (hypertext transfer protocol)
For more free, peer-reviewed, openly licensed resources visit OpenStax.org.
4 5/26/26
