Page 68 - ICT_for_JHS_3_Classical

example).
7. Press Enter, or click the Enter button on the Formula bar to complete
the formula.

Creating a subtraction formula using the point-and-

click method

Formulas can be created by using either numbers or cell references in the
definition. You can also use the mouse to select the cells to be used in the
formula instead of typing the cell number or cell reference. Using this method,
we are going to write a simple formula that subtracts one cell from another: =B3-
B2.

To create a simple formula using the point-and-click method:
1. Type the numbers you want to calculate in separate cells (for example,

type 128 in cell B2 and 345 in cell B3).
2. Click the cell where the answer will appear (B4, for example).
3. Type the equals sign (=) to let Excel know that a formula is being
defined.
4. Click on the first cell to be included in the formula (B3, for example).

5. Type the subtraction sign (-) to let Excel know that a subtraction
operation is to be performed.
6. Click on the next cell in the formula (B2, for example).
7. If you include multiple cells in the formula, repeat steps 4 and 5 until
the entire formula is entered.
8. Press Enter, or click the Enter button on the Formula bar to complete
the formula.