Practice: A Monthly Budget
Put it together with a household budget. Income at the top, expenses below, then totals, the amount left over, and a check that flags overspending.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
Why is `$B$1` used in the share formula?
Your turn: write the code
In B11 show how much is left over (income minus total spent).
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.