- 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.
- Once your budget has been created, use conditional formatting to highlight any number under $500 in Red.
- 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.