Page 30 - Computer Genius Class 06
P. 30

Information Literacy
                         Quest                                                         Technology Literacy


                       If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then calculate and write
                       the output of the following formulas:

                       1.     1    2
                       2.          1    2
                        .    1      2         1

                        .    1           1




                  Functions

                  Functions are predefined  ormulas in   cel to per orm  oth simple and comple  calculations. They
                  accept arguments and return  alues.  rguments are input gi en to the  unctions. These arguments
                  can  e num ers or te t. The  alues should  e gi en in  et een the opening and closing     parenthesis.

                  Rules for using Functions

                      ll   cel  unctions must  egin  ith the   sign.
                     Function name must  e a  alid name.

                     Function must  e  ollo ed  y opening and closing parenthesis.

                  Categories of Functions
                    cel pro ides the  ollo ing categories o   unctions

                     Statistical Functions:  alculate the ma imum  minimum  a erage  etc. o  a set o  numeric data.

                     Financial Functions: Calculate interest on a loan, the number of instalment of a loan, the amount
                     o  e ery instalment  etc.
                     Date and Time Functions: Calculate the day, month, and year of a date and the hour, minute,
                     and second o  a particular time.

                     Mathematical Functions: Calculate the square root or absolute value of a number, product of
                     num ers  etc.
                     Logical Functions:   aluate conditions such as       and gi e the result as true or  alse.

                     Text Functions:  er orm a num er o  operations on strings  i.e.  a collection o  characters li e
                      hello      riend     computer    etc.    such  as   inding  the  length  o   a  string    oining  t o  strings
                     searching  or one string inside another  etc.
                     Database Functions:  uery a data ase  ased on the data contained in the data ase.

                     Information Functions: Provide information about a specific cell, such as the type of data it
                     contains   hether it is te tual or numeric.

                     Lookup and Reference Functions:  ocate speci ic  alues in speci ic cells.
                   et us discuss some o  these categories in detail.

                       28    Computer Genius-VI
   25   26   27   28   29   30   31   32   33   34   35