Page 31 - TP_Play_V2.1_class6
P. 31

Function                          Purpose                             Example

                                              It returns the count of the number of   Input: =COUNT(4,8,12)
                  COUNT(range)
                                              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 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.                      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 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



                                                                                     Formulas and Functions       29
   26   27   28   29   30   31   32   33   34   35   36