Page 31 - Digicode_AI_class_6
P. 31

Mathematical Functions

             Functions                   Purpose                              Example

                                                                              Input: =SUM(4,8,12,16)
             SUM(range)                  It returns the sum of a range.
                                                                              Output: 40

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

                                         It  returns  the  remainder  after  a   Input: =MOD(8,5)
             MOD(number, divisor)
                                         number is divided by the divisor.    Output: 3

                                         It  returns  the  square  root  of  the   Input: =SQRT(81)
             SQRT(number)
                                         given number.                        Output: 9
                                         It rounds the number to an integer  Input: =INT(14.25)
             INT(number)
                                         value.                               Output: 14

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

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

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

                                         It returns the absolute value of a   Input: =ABS(-25)
             ABS(number)
                                         given number.                        Output: 25
            Let us use the mathematical functions in Excel. To use the mathematical functions, follow the given steps:
















                      1  Type the following
                     data  in  the  Excel
                     worksheet.







                                                      2   To  calculate  the  price  of  Pencils, type  the
                                                      =PRODUCT(B3:C3) function and press the Enter key.



                                                                         Formulas and Functions in Excel  29
   26   27   28   29   30   31   32   33   34   35   36