Page 45 - Plus V4 with Adobe class 6
P. 45

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

                                                                                        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
                                       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
                                       It returns the count of the number of values in  Input: =COUNT(4,8,12)
             Count(range)
                                       the selected range.                              Output: 3

             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
                                                                                         Input: =MAX(4,16,12,9)
             Max(range)                It returns the largest value in the given range.
                                                                                         Output: 16
                                       It returns the smallest value in the given        Input: =MIN(4,16,12,9)
             Min(range)
                                       range.                                            Output: 4
                                       It returns the average of the given numbers in  Input: =AVERAGE(12,3,6)
             Average(range)
                                       a range.                                          Output: 7


                                       Factbot


                               In functions, we can also use the cell address in place of the values.


            Let us use the mathematical functions in Excel.
            Perform the following steps to use the mathematical functions:

            When you press the Enter key, price of the pencils appears in the cell D3. Using the AutoFill feature,
            we can calculate the prices of the Geometry Boxes and Pens.





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