Workplace Software and Skills

# 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
3. Recommended Charts
4. Conditional formatting