Page 91 - Ms Excel Note and Workbook
P. 91
MICROSOFT EXCEL NOTE AND WORKBOOK
To create a formula:
In our example below, we'll use a simple formula and cell references to calculate a budget.
1. Select the cell that will contain the formula. In our example, we'll select cell D12.
2. Type the equals sign (=). Notice how it appears in both the cell and the formula bar.
TIP
All formulas in Excel must
begin with an equals sign
(=)..
3. Type the cell address of the cell you want to reference first in the formula: cell D10 in
our example. A blue border will appear around the referenced cell.
82 | P a g e