Page 25 - TP_iPlus_V2.1_Class8
P. 25

Functions                         Purpose                             Example

                                              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 digits.             Output: 35.67

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









                                                                                       2  To calculate the
                         1  Type the                                                  price of Pencils, type
                         following data
                                                                                      the =PRODUCT(B3:C3)
                         in the Excel
                                                                                      function in cell D3 and
                         worksheet.
                                                                                      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 in cell D6 and
                                                                                            press the Enter key.
















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