- name the sheet
- understand references
- enter information
- activate a cell
- enter row headings
- enter column headings
- make a column wider
- enter values
- calculate a difference
- calculate a percent diff
- sum some values
- calculate net income
- copy formulas
- copy and paste
- use the fill handle
- change a value
- extra bits
calculate net income
The final row of the worksheet contains cells to calculate the net income: total income minus total expenses. Here's how to enter that final formula.
Click cell B6. Its reference appears in the formula in cell B28.
Click cell B27. Its reference appears in the formula in cell B28.
Press Enter (Windows) or Return (Mac OS). The result of the formula appears in cell B28.
Have you been saving your work?
Now is a good time to click the Save button on the Standard toolbar to save your work up to this point.