Page 25 - iPlus_Ver_2.0_class_8
P. 25

Functions                         Purpose                             Example

                                              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,                It returns a number after rounding   Input: =ROUND(35.666,2)
                 number_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.



                    Info Byte

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



                 When you press the Enter key, the 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)
                                                                                              function and press
                                                                                              the Enter key.





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