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
   300   301   302   303   304   305   306   307   308   309   310