Page 43 - TP_Pluse_V2.2_Class_6
P. 43

Mathematical Functions

                      Functions                            Purpose                                 Example

                                                                                          Input: =SUM(4,8,12,16)
                  SUM(range)           It adds the values in a range of cells.
                                                                                          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 divided  Input: =MOD(8,5)
                  (number, divisor)    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 off number to an integer value.
                                                                                          Output: 14

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

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

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




                                                             Tech Fact
                             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:

                 Step 1:  Type the data in the Excel worksheet as shown here..
                 Step 2:  To calculate the price of Pencils, type the =PRODUCT(B3:C3) function in the cell D3.

                 Step 3:  Press the Enter key from the keyboard.
                 When you press the Enter key, the price of the pencils appears in cell D3. Using the Auto Fill feature,
                 we can calculate the prices of the Geometry Boxes and Pens.

                 Step 4:  To calculate the subtotal, type the =SUM(D3:D5) in the cell D6.

                 Step 5:  Press the Enter key from the keyboard.
                 When you press the Enter key, subtotal appears in the cell D6.


                 Step 6:  Calculate the Tax by using the =(D6*7)/100 formula.



                                                                               Formulas and Functions in Excel 2016  41
   38   39   40   41   42   43   44   45   46   47   48