Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 51 - 2620_Birla Open Mind C-6
P. 51

    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  49

| 46 47 48 49 50 51 52 53 54 55 56 |