←
Review Questions

Review Questions

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