Page 305 - TP_IT_V1.0_C9_flipbpookl
P. 305
Formula Evaluation Result
=10+2*16/2
=10+2*4^2/2 =10+32/2 26
=10+16
=36–4/4
=6*6-(1+3)/2^2 35
=36–1
=3+5*16
=3+5*4^2 83
=3+80
=2+2-3^2+10
=2+2-9+10
=10/5+2-(1+2)^2+10 5
=4-9+10
=-5+10
Evaluate the following equations using operator precedence and then test the result in the
uiz Bee spreadsheet:
1. =8-4/2 8. =-4/2+2
2. =5*5+8 9. =1+2^2-2
3. =3+5*4 10. =4*3/2
4. =2^5+8 11. =5+6^2*4-3
5. =3+2^2 12. =(2+3-1)*6+212/6
6. =5+6*2^2 13. =64/6+2*4-1
7. =8/4*4 14. =7+2-1*1/1^2
USING CELL ADDRESS IN FORMULA
Instead of giving direct values in a formula, we can also give addresses of the cells containing values. When the values
of the cells change, the results obtained by the formula also get updated accordingly. For example, to get the sum of
the values in the cells A1 and A2, the formula =A1+A2 will be used in the cell A3.
Let us do the activity given below to see how this works:
Case 1:
Cell A1 has 5, cell A2 has 8, and cell A3 has =5+8.
What is the result in cell A3?
Ans: It will be 13
Case 2:
Now, change the values in cell A1 to 10, cell A2 to 7.
Cell A3 has =5+8
What changes do you see in cell A3?
Ans: No changes as the formula is still adding 5+8 and not changed to new values of cell A1 and A2.
Electronic Spreadsheet 303

