11.8: Chapter Review - Review Questions
-
- Last updated
- Save as PDF
Review Questions
1 .
The distance from your home to the grocery store is an example of:
-
discrete data
-
qualitative data
-
continuous data
-
ordinal data
2 .
The Data Validation tool is found on which tab?
-
Home
-
Data
-
Insert
-
Review
3 .
Which level of measurement is appropriate for an opinion question with responses such as Disagree, Agree, or Neutral?
-
nominal
-
ratio
-
interval
-
ordinal
4 .
You would find the tool to format a selection as a table on which tab?
-
Home
-
Data
-
Insert
-
Page Layout
5 .
______ is used to summarize data into certain ranges that you define in table format.
-
Regression
-
Descriptive Statistics
-
Correlation
-
A histogram
6 .
The _____ function returns the mean of a dataset with multiple criteria.
-
SUMIFS
-
AVERAGEIFS
-
TRIM
-
COUNT
7 .
Descriptive Statistics is found under which add-in?
-
Data Analysis
-
Solver
-
ANOVA
-
Data tab
8 .
Which test do you use when you have two groups of normal data to investigate statistical differences?
-
Regression
-
t-Test: Two Sample Assuming Unequal Variances
-
z-Test: Two Sample for Means
-
ANOVA
9 .
The Text to Columns tool is the opposite of the ________ function.
-
CONCATENATE
-
CORRELATION
-
TRIM
-
Solver
10 .
Which Excel tool can help you find an optimal solution when you have several variables?
-
ANOVA
-
Data Analysis
-
Solver
-
z-Test
11 .
Where is the Scenario Manager found?
-
Home tab > Analyze Data
-
Review tab
-
What-If Analysis tools
-
Formulas tab > Insert Function
12 .
Which tool is used to find a solution when changing a single variable?
-
Goal Seek
-
What-If Analysis
-
Scenario Manager
-
Solver
13 .
Choosing ________ creates a separate table of the results of the scenarios you created in Scenario Manager.
-
Goal Seek
-
Show
-
Edit
-
Summary
14 .
What-If Analysis tools are accessed from which tab?
-
Insert
-
Data
-
Home
-
Formulas
15 .
Calculated fields in a PivotTable are inserted from which tab?
-
Slicer
-
Formulas
-
PivotTable Analyze
-
Data
16 .
_______ are a more visual way to filter information in a PivotTable.
-
Slicers
-
Calculated fields
-
Timelines
-
Formulas
17 .
How do you remove a timeline in a PivotTable?
-
Click out of the PivotTable.
-
Choose a different year.
-
Right-click on the timeline scroll bar.
-
Use the Timeline tab.
18 .
Which chart is best to show trends over time?
-
column
-
bar
-
line
-
scatter
19 .
Small line charts inserted into worksheet cells are called _____.
-
Slicers
-
Sparklines
-
Icon sets
-
Data bars
20 .
Where do you find saved chart templates?
-
Home tab
-
Quick Access tool
-
Recommended Charts
-
Conditional formatting