Page 28 - TP-Play_V-2.0_Book-6
P. 28

Functions                          Purpose                             Example

                                         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 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.
                                                                                 Using PRODUCT function
            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.

            Step 4   To calculate  the subtotal, type the
                     =SUM(D3:D5) in the cell D6.

            Step 5   Press the Enter key from the keyboard.
                                                                                    Using SUM function
            When you press the Enter key, subtotal appears in
            the cell D6.
            Step 6   Calculate the Tax by using the =(D6*7)/100

                     formula.
            Step 7   Calculate the Total by using the
                     =SUM(D6:D7) function. Final output
                     appears as shown:


            Text Functions                                                          Displaying Total


                    Functions                       Purpose                             Example

                                                                           Input: =CONCATENATE(“Touch”,
             CONCATENATE(text1,        It joins together two or more
                                                                           “pad”)
             text2)                    different text strings.
                                                                           Output: Touchpad




             28       Play (Ver. 2.0)-VI
   23   24   25   26   27   28   29   30   31   32   33