A real-world job using what the Basics section covered.
What you’ll do
Here’s a month of spending against a budget. You’ll work out what’s left in each category, flag the ones that went over, total the month and see how much of it went on rent.
Your turn
Step 1 of 5
1
In D2, work out how much of the Rent budget is left: the budget minus what was spent. Then fill it down to D13.
2
In E2, show "Over" if more was spent than budgeted, otherwise "OK". Fill it down to E13.
3
In H2, total everything spent this month.
4
In H3, work out what share of the total spending went on rent (row 2).
5
Show H3 as a percent: select it and press Ctrl+Shift+5.
Type in D2 and press Enter. While you type, click cells to add them.