Page 30 - CG_v2.1_flipBooks_class_6
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.  =(A1 - A2) * A3
                       2.  =A3 + (A1 * A2)
                       3.  =A1 * ((A2 + A3) – 10)

                       4.  =A1 / ((A3 – A1) –5)





                  Functions

                  Functions are predefined formulas in Excel to perform both simple and complex calculations. They
                  accept arguments and return values. Arguments are input given to the functions. These arguments can
                  be numbers or text. The arguments should be given in between the opening and closing ( ) parenthesis.

                  Rules for using Functions

                     All Excel functions must begin with the = sign.
                     Function name must be a valid name.

                     Function must be followed by opening and closing parenthesis.
                  Most of the functions contain an argument within it.
                  Categories of Functions

                  Excel provides the following categories of functions:
                     Statistical Functions: Calculate the maximum, minimum, average, etc. of a set of numeric data.

                      Financial Functions: Calculate interest on a loan, the number of instalment of a loan, the amount
                     of every instalment, etc.
                      Date and Time Functions: Calculate the day, month, and year of a date and the hour, minute,
                     and second of a particular time.
                      Mathematical Functions: Calculate the square root or absolute value of a number, product of
                     numbers, etc.

                      Logical Functions: Evaluate conditions such as X > 5 and give the result as true or false.
                      Text Functions: Perform a number of operations on strings (i.e., a collection of characters like
                     'hello',  'friend',  'computer',  etc.),  such  as  finding  the  length  of  a  string,  joining  two  strings,
                     searching for one string inside another, etc.

                      Database Functions: Query a database based on the data contained in the database.
                      Information Functions: Provide information about a specific cell, such as the type of data it
                     contains, whether it is textual or numeric.
                      Lookup and Reference Functions: Locate specific values in specific cells.



                       28    Computer Genius (V2.1)-VI
   25   26   27   28   29   30   31   32   33   34   35