Page 44 - Plus_V2.2_C6_Flipbook
P. 44

Rules for using Functions

                     All Excel functions must begin with = 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 it.

                       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, maximum, minimum, average 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 give the result as true or false.

                      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.
                  Mathematical Functions


                        Functions                           Purpose                                 Example
                                                                                           Input: =SUM(4,8,12,16)
                   SUM(range)           It returns the sum of a range.
                                                                                           Output: 40
                                                                                           Input: =PRODUCT(4,2,8)
                   PRODUCT(range)       It multiplies the values in a range of cells.
                                                                                           Output: 64
                   MOD                  It returns the remainder after a number is divided  Input: =MOD(8,5)
                   (number, divisor)    by the divisor.                                    Output: 3

                                                                                           Input: =SQRT(81)
                   SQRT(number)         It returns the square root of the given number.
                                                                                           Output: 9

                                                                                           Input: =INT(14.25)
                   INT(number)          It rounds number to an integer value.
                                                                                           Output: 14

                   POWER(number,  It returns the result of a number raised to some  Input: =POWER(5,3)
                   power)               power.                                             Output: 125

                                        It returns the count of the number of values in the  Input: =COUNT(4,8,12)
                   COUNT(range)
                                        selected range.                                    Output: 3






                  42    Premium Edition-VI
   39   40   41   42   43   44   45   46   47   48   49