Skip to main content
Workforce LibreTexts

17.4: Checking for Understanding

  • Page ID
    13696
  • \( \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 Total Sales
    1. Using the data you entered, perform the following:
      1. Add a Theme to the Chart
      2. Change the Margins to .5 inches
      3. Make the document Landscape
      4. Add a Background Image of a Tool of your choice to the worksheet.
      5. Make sure your document is printing gridlines
      6. Freeze the Header Rows
      7. Add a comment to your document
      8. Run Accessibility Tracker
      9. Protect your sheet with a password.

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

    • Was this article helpful?