Page 47 - TP_Plus_v4_Class6
P. 47

The function in the example below would add the values of the cell range A1:A20.

                Rules for Using Functions                                                         =SUM(A1:A20)

                    All Excel functions must begin with = sign.
                                                                                      Equal sign                Argument
                    Function name must be a valid Excel name.                                    Function Name
                    Function must be followed by opening and closing parenthesis.

                    Most of the functions contain an argument.

                Categories of Functions

                Excel provides many categories of functions.
                Let us discuss these categories in detail.

                Mathematical Functions

                Mathematical functions are used to solve mathematical values.

                        Functions                              Purpose                                Example
                                            It returns the sum of values given as argument   Input: =SUM(4,8,12,16)
                 Sum(range)
                                            or values in a range of cells.                   Output: 40

                                            It multiplies the values given as argument or    Input: =PRODUCT(4,2,8)
                 Product(range)
                                            values in a range of cells.                      Output: 64

                                            It returns the remainder after a number is       Input: =MOD(8,5)
                 Mod (number, divisor)
                                            divided by the divisor.                          Output: 3
                                            It returns the square root of the given          Input: =SQRT(81)
                 Sqrt(number)
                                            number.                                          Output: 9
                                                                                             Input: =INT(14.25)
                 Int(number)                It rounds number to an integer value.
                                                                                             Output: 14
                                            It returns the result of a number raised to      Input: =POWER(5,3)
                 Power(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

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




                                      Factbot

                              In functions, we can also use the address of a range of cells in place of the values.



                Let us use the mathematical functions in Excel.








                                                                               #Charts, Formulas and Functions in Excel  45
   42   43   44   45   46   47   48   49   50   51   52