Skip to main content
Workforce LibreTexts

19.5: Checking for Understanding

  • Page ID
    13712
  • \( \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}}\)

    1. You have imported the following information into Excel from your customer relations management system (CRM)
    Jim Jones jjones@gmail.com 1123 East Street Reno, NV 55434 500
    Catherine Ford cford@yahoo.com 3432 West Street Lansing, MI 233423 600
    Jules Brown jbrown@msn.com 4322 North Lane Marietta, GA 53234 1200
    1. Using the data function of excel, organize the data and add it to the following header groups.
      1. First & Last Name
      2. Email Address
      3. Street
      4. City
      5. State
      6. Zip
      7. Quantity (last number)
    2. Sort the data from the largest quantity to the smallest
    3. Add a Data Validation column to the right of quantity with the heading “Shipped”? Make the options available only “Yes” “No” or “NA”
    4. Format the data as a table.

    This page titled 19.5: Checking for Understanding is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer (Minnesota State Opendora) .

    • Was this article helpful?