Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Written Questions

34 .
What is the difference between data verification and data validation?
35 .
Discuss the differences between discrete and continuous data.
36 .
What are some advantages of using the Excel Data Table tool?
37 .
List and briefly describe the four levels of measurement.
38 .
Imagine you work in the human resources department of a regional hospital. You would like to survey employees about their satisfaction with their job. Develop two survey questions that are categorical. Develop two questions that are numerical. How might this data be analyzed in Excel?
39 .
What Excel tool would you use if you wanted to get an overall summary of a dataset?
40 .
How can regression be used in business?
41 .
Describe a few of the functions useful for dealing with data imported into a spreadsheet.
42 .
Describe the difference between the three types of t-Tests in Excel.
43 .
How do you get the Solver add-in?
44 .
Imagine you are an entrepreneur and are interested in starting a coffee shop in your hometown. How might you envision Excel being useful for you as you research whether the coffee shop is a good idea for the city?
45 .
How does Goal Seek differ from Solver?
46 .
Discuss a few examples where Scenario Manager might be used.
47 .
When would you use the List Formulas tool?
48 .
Describe how to insert a slicer into a PivotTable.
49 .
How do you access the Quick Analysis tool?
50 .
How are the clustered column chart and the histogram different?
51 .
How do you create a chart template?

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
  • 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
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.