Page 95 - Computer - 6

1. Type the values 5, 10, and 20 in cells A1, B1, and C1 respectively.

2. Select the cell D1.

3. Type an equal sign and click cell A1. 1 2

A moving dashed border appears around cell A1. The cell
reference A1 is added to the formula in cell D1.

4. Type a plus sign (+) and click cell B1. 3

A moving dashed border appears around cell B1. The cell
reference B1 gets added to the formula in cell D1.

5. Again, type a plus sign (+) and click cell C1. 4

A moving dashed border appears around cell C1. The cell

reference C1 gets added to the formula in cell D1. The formula
now reads = A1 + B1 + C1. 5

6. Press the Enter button in the Formula bar or press the Enter key.

The result of the formula appears in cell D1.

Knowledge Discovery Subject Enrichment

Different cell references in a formula are displayed in different colours and the
corresponding cell is highlighted with the same colour.

PRECEDENCE OF OPERATORS IN A FORMULA
Excel supports a variety of operators. The table given below illustrates some common operators and
their order of precedence (order of evaluation) in a formula.
Operator Operation Precedence Example Result

^ Exponent 1 = 5 ^ 2 25

* Multiplication 2 = 6 * 2 12
/ Division 2 = 20 / 4 5

+ Addition 3 = 3 + 5 8
– Subtraction 3 = 10 – 3 7

& Concatenation 4 = "Red " & "Fort" Red Fort

• If a formula contains multiple operators with the same precedence, Excel evaluates them from
left to right.
For example, the formula = 20 + 4 * 5 – 10, evaluates to result 30. Here, multiplication is performed
first, followed by addition and subtraction.

93