Skip to ContentGo to accessibility page
OpenStax Logo
Workplace Software and Skills

Practice Exercises

Workplace Software and SkillsPractice Exercises

Practice Exercises

21 .

Go to the World Bank Data Catalog and find a dataset or topic that interests you, then download the Excel file. Format the data as a Data Table. Filter the data using one of the criteria. Change the Table Style. What information can be gleaned from the Data Table?

22 .

Using the data in the "mgmt_jobs" tab of the downloadable Chapter 11 data file, create a Data Table. Filter the data to find those rows that use the word “manager” and have median earnings greater than $50,000 per year.

23 .
Create a two-variable Data Table for profit for a product with a unit price of $25 and a cost per unit of $18. Investigate various levels of both the number of units sold and the price per unit.
24 .
Go to Kaggle to find a dataset that interests you. (Note: You may need to create an account.) Download the Excel file. Create the Correlation matrix for the dataset. You may need to adjust the data if nominal or ordinal data is included in the file. (Hint: Code the data using numbers.)
25 .
Using a dataset from Kaggle, get the Descriptive Statistics for the information.
26 .
Using a dataset from Kaggle, create a histogram with a chart for one of the key variables.
27 .
Using a dataset from Kaggle, use the Analyze Data tool to discover some additional ways to analyze the information.
28 .
Use Goal Seek to determine what grade you will need on a final exam in a class to get the grade you desire. You can use your grades from a class in which you are currently enrolled. You will need to know from the syllabus how your final grade is calculated.
29 .
Use the Scenario Manager to look at the different financing options for buying a car that you are interested in purchasing. Look at scenarios such as a lower interest rate or a shorter loan term. Create the summary table of the scenarios.
30 .
Using the data in the "grads" tab of the downloadable Chapter 11 data file, create a PivotTable of the information. Insert a slicer to filter the data by type of institution. Insert a calculated field to find the average number of independent and public institutions.
31 .
Go to Google Trends and choose a topic that interests you. Download a dataset and create a chart appropriate for the data.
32 .
Go to the Contextures website and scroll down to the Sample Data Files options. Download the office supply data file. Use the same dataset, use the Quick Analysis tool to add conditional formatting or sparklines to the Data Table.
33 .
Go to Google Trends and choose another topic that interests you. Download a dataset and create a chart appropriate for the data. Then, save that chart as a chart template.
PreviousNext
Order a print copy
Citation/Attribution
Reuse and redistribution of this content in digital or print format:
  • 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 prior written permission.
  • This book uses the Creative Commons Attribution-NonCommercial-ShareAlike License, which means that you can reuse and modify the material only for noncommercial purposes, must attribute OpenStax, and must distribute any derivative works under the same license.
  • Any commercial printing of this textbook, including using a local or custom printer, must be approved by OpenStax, and proper citation provided.
  • OpenStax-copyrighted images, activities, assessments, and similar components of this book are subject to the same licensing – CC-BY-NC-SA. They can be used for noncommercial purposes with attribution. Commercial use requires permission.
  • Permission requests: Anyone who intends to incorporate this content (including text, images, and other components) into large language models, use it in AI offerings, use it commercially (including in print), and/or has questions about another use case is welcome to complete our reuse request form.
Attribution information
  • If you are redistributing all or part of this book in a noncommercial 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 noncommercial digital format, then for every page that includes OpenStax content, you must license the derivative work under the same CC-BY-NC-SA license as the original, and 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

The information below includes the information needed to generate citations in most major styles (APA, MLA, etc.); you must reformat and organize the information as needed to fit the requirements of the style. Use the information below to generate a citation. We recommend using a citation tool such as this one.

© Apr 23, 2026 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike License. The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo, and Rice University name, and Rice University logo trademarks, or wordmarks are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.