Page 45 - Plus_V2.2_C6_Flipbook
P. 45

Functions                            Purpose                                 Example
                  ROUND(number,        It returns a number after rounding to the specified  Input: =ROUND(35.666,2)
                  number_of_digits)    digits.                                            Output: 35.67

                                                                                          Input: =ABS(–25)
                  ABS(number)          It returns the absolute value of a given number.
                                                                                          Output: 25
                                                                                          Input: =MAX(4,16,12,9)
                  MAX(range)           It returns the largest value in the given range.
                                                                                          Output: 16
                                                                                          Input: =MIN(4,16,12,9)
                  MIN(range)           It returns the smallest value in the given range.
                                                                                          Output: 4
                                       It returns the average of the given numbers in a   Input: =AVERAGE(12,3,6)
                  AVERAGE(range)
                                       range.                                             Output: 7




                                                             Tech Fact
                             In functions, we can also use the cell address in place of the values.



                 Let us use the mathematical functions in Excel.

                 Perform the following steps to use the mathematical functions:
                 Step 1:  Type the following data in the Excel 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 can calculate the prices of the Geometry Boxes and Pens.


























                                                        Using PRODUCT function

                 Step 4:  To calculate the subtotal, type the =SUM(D3:D5) in the cell D6.
                 Step 5:  Press the Enter key from the keyboard.



                                                                               Formulas and Functions in Excel 2016  43
   40   41   42   43   44   45   46   47   48   49   50