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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)
- 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:
- January: 2400, 2670
- February 3300, 3100
- March 2700, 1900
- April 1900, 1920
- May 2700, 2450
- June 2650, 3200
- July 3200,1700
- August 1700, 1650
- September 1560, 1649
- October 1890, 1919
- November 2100,2400
- December 3400, 3600
Please create an excel document with the following Table Columns:
| Month | 2019 Sales | 2020 Sales | Total Sales |
- Using the data you entered, perform the following:
- Add a Theme to the Chart
- Change the Margins to .5 inches
- Make the document Landscape
- Add a Background Image of a Tool of your choice to the worksheet.
- Make sure your document is printing gridlines
- Freeze the Header Rows
- Add a comment to your document
- Run Accessibility Tracker
- Protect your sheet with a password.