Skip to main content
Workforce LibreTexts

11.8: Chapter Review - Review Questions

  • Page ID
    32824
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)

    ( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\id}{\mathrm{id}}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\kernel}{\mathrm{null}\,}\)

    \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\)

    \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\)

    \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    \( \newcommand{\vectorA}[1]{\vec{#1}}      % arrow\)

    \( \newcommand{\vectorAt}[1]{\vec{\text{#1}}}      % arrow\)

    \( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vectorC}[1]{\textbf{#1}} \)

    \( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)

    \( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)

    \( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)

    \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)

    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

    This page titled 11.8: Chapter Review - Review Questions is shared under a CC BY 4.0 license and was authored, remixed, and/or curated by OpenStax via source content that was edited to the style and standards of the LibreTexts platform.