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
Symbols
A
absolute reference 10.1 Data Tables and Ranges
accounting equation 12.1 Basic Accounting
Advanced Research Projects Agency (ARPA) 1.3 The Internet, Cloud Computing, and the Internet of Things
Analysis ToolPak 11.2 Statistical Functions
Analytical dashboard 14.6 Data Analysis and Integration
Android operating system 1.1 Computing from Inception to Today
ANOVA: Single Factor 11.2 Statistical Functions
ANOVA: Two-Factor With Replication 11.2 Statistical Functions
ANOVA: Two-Factor Without Replication 11.2 Statistical Functions
application software 2.1 Software Basics
augmented reality (AR) 1.1 Computing from Inception to Today
B
best fit regression line 11.5 Data Analysis Charts
C
Calculated Field 11.4 PivotTables/Charts
central processing unit (CPU) 1.2 Computer Hardware and Networks
chart template 11.5 Data Analysis Charts
clustered column chart 11.5 Data Analysis Charts
Code Builder 14.5 Using Macros
collaboration 2.6 Collaboration
combination chart 11.5 Data Analysis Charts
comma-delimited (CSV) file 13.4 Maintaining Records in a Database
Command Button Wizard 14.3 Customizing Forms
command control 14.3 Customizing Forms
communication applications 2.3 Communication and Calendar Applications
comparison operators 10.2 More About Formulas
Conditional Formatting menu 11.5 Data Analysis Charts
content control fields 5.3 Creating Forms in Microsoft Word
content creation 8.5 Social Media in Business
content curation 8.5 Social Media in Business
content management system (CMS) 8.1 What Are Content Management Systems?
Continuous Form View 14.3 Customizing Forms
Control Panel 2.2 Files and Folders
control source 14.4 Customizing Reports
D
database application 2.1 Software Basics
Database files 2.2 Files and Folders
Detail section 14.3 Customizing Forms
development database 13.1 What Is a Database?
dialog box 2.1 Software Basics
digital database 13.1 What Is a Database?
digital platform 13.1 What Is a Database?
Document files 2.2 Files and Folders
E
Edit Individual Documents 5.2 Mail Merge in Microsoft Word
electronic medical records 1.1 Computing from Inception to Today
engagement management (EM) 8.5 Social Media in Business
ENIAC (Electronic Numerical Integrator and Calculator) 1.1 Computing from Inception to Today
enterprise content management 8.1 What Are Content Management Systems?
enterprise content management (ECM) system 8.2 Common Content Management Systems
Entertainment Software Ratings Board (ESRB) 1.1 Computing from Inception to Today
Extract All 2.2 Files and Folders
F
file compression 2.2 Files and Folders
file format 2.2 Files and Folders
File History 2.2 Files and Folders
file sharing software 2.6 Collaboration
FileStream 2.6 Collaboration
financial accounting 12.1 Basic Accounting
form control 14.3 Customizing Forms
Form Design Tools 14.3 Customizing Forms
form property 14.3 Customizing Forms
G
Generally Accepted Accounting Procedures (GAAP) 12.2 Financial Functions in Microsoft Excel
graphical user interface (GUI) 2.1 Software Basics
H
I
IBM Enterprise Content Management 8.2 Common Content Management Systems
inferential statistics 11.2 Statistical Functions
information processing cycle 1.2 Computer Hardware and Networks
Insert Slicer 11.4 PivotTables/Charts
Insert Timeline 11.4 PivotTables/Charts
International Financial Reporting Standards (IFRS) 12.2 Financial Functions in Microsoft Excel
internet protocol address (IP address) 1.3 The Internet, Cloud Computing, and the Internet of Things
iPhone operating system (iOS) 1.1 Computing from Inception to Today
L
linear regression 11.2 Statistical Functions
List Formulas 11.4 PivotTables/Charts
local area networks (LANs) 1.2 Computer Hardware and Networks
long-tail keyword 8.5 Social Media in Business
M
Macro Builder 14.5 Using Macros
Macro Designer 14.5 Using Macros
Macro Recorder 14.5 Using Macros
managerial accounting 12.1 Basic Accounting
many-to-many relationship 14.2 Multiple Table Forms
Meeting etiquette 2.6 Collaboration
message box 14.5 Using Macros
Microsoft SQL Server 13.1 What Is a Database?
mobile content management system (MCMS) 8.1 What Are Content Management Systems?
MsgBox action 14.5 Using Macros
N
network adapter card 1.2 Computer Hardware and Networks
Nintendo Entertainment System (NES) 1.1 Computing from Inception to Today
nonrelational database 13.1 What Is a Database?
NoSQL database 13.1 What Is a Database?
O
one-to-many relationship 14.2 Multiple Table Forms
one-to-one relationship 14.2 Multiple Table Forms
online analytical processing (OLAP) 13.4 Maintaining Records in a Database
online transaction processing (OLTP) 13.4 Maintaining Records in a Database
Open Office Writer 2.1 Software Basics
Operational dashboard 14.6 Data Analysis and Integration
order of operations 10.2 More About Formulas
P
Page Background 3.5 Document Design
personal area networks (PANs) 1.2 Computer Hardware and Networks
personal computer (PC) 1.2 Computer Hardware and Networks
Personally identifiable information (PII) 1.3 The Internet, Cloud Computing, and the Internet of Things
PivotChart 10.4 PivotTables
PivotTable Analyze 10.4 PivotTables
Portable Document Format (PDF) 2.2 Files and Folders
predefined queries 13.3 Querying a Database
presentation application 2.1 Software Basics
Presentation files 2.2 Files and Folders
R
random access memory (RAM) 1.2 Computer Hardware and Networks
read-only memory (ROM) 1.2 Computer Hardware and Networks
README file 2.1 Software Basics
record navigation buttons 13.4 Maintaining Records in a Database
Recycle Bin 2.2 Files and Folders
relational database management system (RDBMS) 13.1 What Is a Database?
Remove Slicer 11.4 PivotTables/Charts
Remove Timeline 11.4 PivotTables/Charts
Report Layout Design Controls 14.4 Customizing Reports
Rich Text Format (RTF) 2.2 Files and Folders
S
search engine optimization (SEO) 8.1 What Are Content Management Systems?
Secure File Transfer Protocol (SFTP) 1.2 Computer Hardware and Networks
secure sockets layer (SSL) 1.2 Computer Hardware and Networks
semistructured data 13.1 What Is a Database?
Single Form View 14.3 Customizing Forms
social media analytics 8.5 Social Media in Business
social media calendar 8.5 Social Media in Business
Social media content management 8.1 What Are Content Management Systems?
software installation 2.1 Software Basics
Sorting and Grouping 14.4 Customizing Reports
spreadsheet application 2.1 Software Basics
Spreadsheet files 2.2 Files and Folders
stacked column chart 11.5 Data Analysis Charts
status bar 2.1 Software Basics
structured data 13.1 What Is a Database?
structured query language (SQL) 13.1 What Is a Database?, 13.1 What Is a Database?
Subform Wizard 14.2 Multiple Table Forms
system-related software 2.1 Software Basics
T
t-Test: Paired Two Sample for Means 11.2 Statistical Functions
t-Test: Two-Sample Assuming Equal Variances 11.2 Statistical Functions
t-Test: Two-Sample Assuming Unequal Variances 11.2 Statistical Functions
TLS (transport layer security) 1.2 Computer Hardware and Networks
top-down table 10.4 PivotTables
tracing dependent functions 10.5 Auditing Formulas and Fixing Errors
tracing precedent functions 10.5 Auditing Formulas and Fixing Errors
W
web content management system (WCMS) 8.1 What Are Content Management Systems?
web crawler software 8.4 Search Engine Optimization
wide area networks (WANs) 1.2 Computer Hardware and Networks
word processing application 2.1 Software Basics
WYSIWYG (What You See Is What You Get) 8.2 Common Content Management Systems
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.