Page 217 - CA_165_V2.0_C9_Flipbook
P. 217

Cell Address->B1
                                    When absolute->$B$1


                                                                                                 Drag the AutoFill
                                                                                                   Tool over the
                                                                                                 consecutive cells.










                        Formula in the                                                           =H4/$B$1*100
                          cells will be

                               =H5/$B$1*100
                               =H6/$B$1*100
                               =H7/$B$1*100

                        Relative         Absolute
                       Reference         Reference

                 The values will be displayed accordingly in respective cells.


                                                   Lab Assignment ‘n Activity                Century   #Technology Literacy
                                                                                                21 st
                                                                                               Skills


                    Complete the following activities and tick on the circle:
                    ª   Apply Absolute cell referencing to calculate the Total price of books in the worksheet:















                        Include 8% GST on the total price.



                   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    215
   212   213   214   215   216   217   218   219   220   221   222