Skip to main content
Workforce LibreTexts

16.7: Checking for Understanding

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

    1. You are tracking monthly sales for your parts and equipment company in 2019 and 2020. Your monthly sales are as follows with 2019 displayed first followed by 2020:
      1. January: 2400, 2670
      2. February 3300, 3100
      3. March 2700, 1900
      4. April 1900, 1920
      5. May 2700, 2450
      6. June 2650, 3200
      7. July 3200,1700
      8. August 1700, 1650
      9. September 1560, 1649
      10. October 1890, 1919
      11. November 2100,2400
      12. December 3400, 3600

    Please create an excel document with the following Table Columns:

    Month 2019 Sales 2020 Sales Sparklines

    Format your information as a table, and insert a Bar Chart Displaying the monthly profits in dollars. In addition, create a totals row to add the total profits.

    1. Create a Pie Chart to measure each month of sales in relation to the whole. Add an Image pertaining to Sales next to the chart.
    2. Place a document header & footer on the worksheet. The Header should be “Monthly Parts Sales”. The Footer should be the Date.

    16.7: Checking for Understanding is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?