Page 103 - Ms Excel Note and Workbook
P. 103
MICROSOFT EXCEL NOTE AND WORKBOOK
2. Enter the formula to calculate the desired value. In our example, we'll type
=(B4*C4)*$E$2, making $E$2 an absolute reference.
TIP
When writing a formula in
Microsoft Excel, you can
press the F4 key on your
keyboard to switch
between relative, absolute,
and mixed cell references,
3. Press Enter on your keyboard. The formula will calculate, and the result will display in
the cell.
4. Locate the fill handle in the bottom-right corner of the desired cell. In our example, we'll
locate the fill handle for cell D4.
5. Click and drag the fill handle over the cells you want to fill (cells D5:D13 in our
example).
94 | P a g e
