Page 30 - Digicode_AI_class_6
P. 30

Information Literacy
                   byte 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 values 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.

            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.
            Let us discuss some of these categories in detail.


                 28    DigiCode AI-VI
   25   26   27   28   29   30   31   32   33   34   35