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 addin?

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

tTest: Two Sample Assuming Unequal Variances

zTest: 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

zTest
11
.
Where is the Scenario Manager found?

Home tab > Analyze Data

Review tab

WhatIf Analysis tools

Formulas tab > Insert Function
12
.
Which tool is used to find a solution when changing a single variable?

Goal Seek

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

Rightclick 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