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

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

• If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
• If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution: