Page 203 - CA 165 ver 1.0 Class 9
P. 203

Cell Address->F3
                                                                                    When absolute->$F$3






                                                                                             Drag the AutoFill
                                                                                              Tool over the
                                                                                             consecutive cells.
















                         Formula in the cells will be

                            =F7/$F$3*100
                            =F8/$F$3*100
                            =F9/$F$3*100
                            =F10/$F$3*100

                    Relative          Absolute
                    Reference         Reference

                 The values will be displayed accordingly in respective cells.

                                                   Lab Assignment ‘n Activity                      Experiential Learning




                    Complete the following activities and tick on the circle.
                                                                ª   What will be the value displayed in cell E2
                                                                    after evaluation?
                                                                ª   If the formula of the cell E2 is copied to E3
                                                                    and E4, what will be the resultant formula
                                                                    in both the cells?



                   OPERATOR

                 An operator is a symbol that performs certain mathematical or logical operations. In a cell, the
                 calculation takes place in the order of precedence of operators (in a similar way as BODMAS in
                 mathematics).

                 The table given in the next page shows the operators, their meaning and their order of execution.
                 When two operators share the same ranking or precedence, calculation is done in the order from left
                 to right.




                                                                                                Data Analysis    201
   198   199   200   201   202   203   204   205   206   207   208