Page 50 - modular4.0
P. 50

Chapter Profile

                           Function                          Purpose                              Example
                                               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  number down  to the  Input: =INT(14.25)
                   INT(number)
                                               nearest integer value.                  Output: 14
                                               It returns the result of a number       Input: =POWER(5,3)
                   POWER(number, power)
                                               raised to some power.                   Output: 125

                   ROUND(number,               It returns a number after rounding      Input: =ROUND(35.666,2)
                   number_of_digits)           to the specified number of 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 2019.

                  Perform the following steps to use the mathematical functions:




                                   1  Type the given
                                   data in the Excel 2019
                                   worksheet.







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


                  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.









                                                                             3   To calculate the subtotal,
                                                                             type the =SUM(D3:D5) in the
                                                                             cell D6 and press Enter key.



                  When you press the Enter key, subtotal appears in the cell D6.









                48   Modular (Ver. 4.0)-VII
   45   46   47   48   49   50   51   52   53   54   55