Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 27

    A function is a predefined formula in Excel. It starts with the = (equal to) sign. Functions are used
                      for computing complex calculations. There are many built-in functions provided by Excel. They
                      accept arguments and return values.
                      Arguments are input to the functions. The values should be given in between opening and closing
                      ( ) parenthesis. For example, in formula =SUM(A1:A5), A1 and A5 are arguments and SUM is a
                      function.

                      Some rules for using functions are:
                         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 atleast one argument within it.

                      Let’s discuss the categories of function.

                                MATHEMATICAL FUNCTIONS

                      Some mathematical functions with their examples are given below.

                            Function                           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  Input: =MOD(8,5)
                       (number, divisor)      divided 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 the number to an integer value.
                                                                                             Output: 14
                       POWER                  It  returns the  result  of  a  number  raised  to  Input: =POWER(5,3)
                       (number, power)        some power.                                    Output: 125

                       ROUND(number,          It  returns a  number  after rounding  to  the  Input: =ROUND(35.666,2)
                       number of digits)      specified digits.                              Output: 35.67

                                                                                             Input: =ABS(–25)
                       ABS(number)            It returns the absolute value of a given number.
                                                                                             Output: 25

                       26   Premium Edition-VII

| 22 23 24 25 26 27 28 29 30 31 32 |