Page 25 - iprime_V2.2_class8
P. 25

Functions                          Purpose                             Example

                                              Returns the remainder after dividing    Input: =MOD(8,5)
                   MOD(number, divisor)
                                              the number by the divisor               Output: 3

                                              Returns the square root of the given    Input: =SQRT(81)
                       SQRT(number)
                                              number                                  Output: 9

                                              Rounds the number  to the nearest  Input: =INT(14.25)
                        INT(number)
                                              integer                                 Output: 14

                                              Returns the result of the number        Input: =POWER(5,3)
                  POWER(number, power)
                                              raised to the given power               Output: 125

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

                                              Returns  the  number  of  absolute      Input: =ABS(-25)
                        ABS(number)           value of the given number               Output: 25



                          Tech Funda



                       In Excel functions, you can use cell addresses instead of direct values.





                 To use the mathematical functions in Excel, follow these steps:
                 Step 1  Type the data in the Excel worksheet.

                 Step 2  To calculate the total price of Pencils, type =PRODUCT(B3:C3) function in cell D3.
                 Step 3  Press the Enter key.























                                                        Using PRODUCT Function

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


                                                                             Spreadsheet—Functions and Charts      23
   20   21   22   23   24   25   26   27   28   29   30