Skip to main content
Workforce LibreTexts

15.8: Check for Understanding

  • Page ID
    13683
  • \( \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 have been asked to track department spending for your unit for the month. Please create a budget with the following headings:
    Item Category Number Purchased Cost per item Total Cost Percent of Total spent

    Now, also calculate the totals, maximum and minimum spend amounts using the AutoSum feature. All amounts are only in dollars, not cents.

    1. Once your budget has been created, use conditional formatting to highlight any number under $500 in Red.
    2. On your next sheet, please create a spending tracking report with the A column cells being numbers from 1-100 using autofill. In addition, change the name of Sheet2 to “Spending” and change the color of the tab to blue.

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

    • Was this article helpful?