- 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 a Difference
Column D, which will display the difference between budgeted and actual amounts, will contain simple formulas that subtract one cell’s contents from another’s using cell references. In this step, we’ll write the first formula. Later, we’ll copy the formula to other cells in the column.
- Activate cell D3.
- Type =.
Click in cell C3.
Its cell reference appears in cell D3.
- Type –.
Click in cell B3.
Its cell reference is appended to the formula in cell D3.
Press Enter.
The result of the formula you entered appears in cell D3.