Page 42 - TP_Pluse_V2.2_Class_6
P. 42

21 st
                   Let’s PraCtiCe                                                         Century   #Critical Thinking
                                                                                            Skills
                    If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
                    the following formulas:

                    1.  (A1 - A2) * A3             ____________________________________________________

                    2.  A3 + (A1 * A2)             ____________________________________________________

                    3.  A1 * (A2 + A3) – 10          ____________________________________________________




                         FUNCTIONS


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


                       Rules for using Functions

                     All Excel functions must begin with the = sign.

                     Function name must be a valid Excel name.
                     Function must be followed by opening and closing parentheses.

                     Most of the functions must contain an argument within them.

                       Categories of Functions

                  Excel provides many categories of functions. Some of them are:

                      Mathematical Functions: Calculates the square root or absolute value of a number, product of
                    numbers etc.

                      Text Functions: Performs 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.

                     Logical Functions: Evaluates conditions such as X > 5 and gives the result as true or false.
                      Statistical Functions: Calculates the maximum, minimum, average etc., of a set of numeric
                    data.

                      Date and Time Functions: Calculates the day, month and year in a date and the hour, minute and
                    second at a particular time.

                  Let us discuss these categories in detail.





                  40    Plus (Ver. 2.2)-VI
   37   38   39   40   41   42   43   44   45   46   47