Page 43 - ModularV1.1 _c7_flipbook
P. 43

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 MS Excel.

                 Perform  the following steps to use the
                 mathematical functions:
                 Step 1  Type the following data in the MS Excel
                         worksheet.
                 Step 2  To calculate the price of Pencils, type the
                         =PRODUCT(B3:C3) function  in the  cell
                         D3.
                                                                                   Using PRODUCT function
                 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 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.

                 Step 6  Calculate the  Tax by using the                             Using SUM function
                         =(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




                                                                                          Formulas and Functions  41
   38   39   40   41   42   43   44   45   46   47   48