Page 49 - TP_Modular_V2.1_Class7
P. 49

Function                          Purpose                             Example
                  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 2016.

                 Perform the following steps to use the mathematical functions:

                 Step 1   Type the given data  in the  Excel   2016
                         worksheet.
                 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, price of the pencils
                 appears in the cell D3. Using the AutoFill feature, we              Using PRODUCT function
                 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.                                                           Using SUM function
                 Step 6   Calculate the Tax by using the =(D6*7)/100

                         formula in cell D7.
                 Step 7   Calculate the Total by using the
                         =SUM(D6:D7) function in cell D8. Final

                         output appears as shown:


                 Text Functions
                                                                                        Displaying Total

                         Function                       Purpose                              Example
                                                                                Input: =CONCATENATE(“Touch”,
                  CONCATENATE(text1,        It joins together two or more
                                                                                “pad”)
                  text2)                    different text strings.
                                                                                Output: Touchpad
                                            It returns the specified number     Input: =LEFT(“Touch”,3)
                  LEFT(text, num_chars)     of characters from the left side    Output: Tou
                                            of the text string.



                                                                                     Formulas and Functions       47
   44   45   46   47   48   49   50   51   52   53   54