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?