Page 211 - CA_165_V2.0_C9_Flipbook
P. 211

DATA ANALYSIS                                            7









                 One of the most important usage of a spreadsheet package is providing analytical reports of
                 values. Calculation on data in a spreadsheet package can be done easily in different ways to
                 provide useful information in a required format.
























                   FORMULAS

                 For doing calculations, formulas are used. Formulas can be applied on a large data set to
                 perform various mathematical operations such as addition, subtraction, division, multiplication
                 and many more.

                 A formula in a spreadsheet package may consist of the following:

                           Category                                     Description
                  Cell Address or a Cell        A1, C11, A24:B36, etc
                  Range

                  Functions                     SUM, MAX, MIN, etc.
                                                +   (Addition)              -      (Subtraction)
                  Mathematical Operators        *    (Multiplication)        /      (Division)
                                                ^   (Exponent)
                                                >   (Greater than)          <      (Less than)
                  Relational Operators          =   (Equal to)              <>   (Not equal to)
                                                <= (Less than or equal to)  >=   (greater than or equal to)
                  Parenthesis                   ()
                  Equal to operator             A formula always starts with an = operator.




                                                                                                 Data Analysis   209
   206   207   208   209   210   211   212   213   214   215   216