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

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:

                     Cell Address or a Cell                         A1, C11, A24:B36, etc
                             Range
                  Functions                     SUM, MAX, MIN, etc.
                  Operators                                      Mathematical Operators
                                                +   (Addition)              -      (Subtraction)
                                                *    (Multiplication),        /      (Division)
                                                Exp (Exponent)
                                                                   Relational Operators
                                                >   (Greater than)          <        (Less than)
                                                =   (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   195
   192   193   194   195   196   197   198   199   200   201   202