Page 46 - C_GPT _V4 _class_6
P. 46

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



                          Factbot

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



              Perform the following steps to use the mathematical functions:

              When you press the Enter key, the price of the pencils appears in cell D3. Using the AutoFill feature,
              we can calculate the prices of the Geometry Boxes and Pens.






                                                                                     To calculate the price
                       Type the given                                                of Pencils, type the
                   1   data in the Excel                                             =PRODUCT(B3:C3) function    2
                       worksheet.                                                    and press Enter key.










                                                                                                    Calculate
                                                                                                    the Tax by
                                                                                                    using the
                                                                                                    =(D6*7)/100   4
                                                                                                    formula.



                      To calculate the subtotal, type the              Calculate  the  Total  by
                  3   =SUM(D3:D5) function and press               5   using the =SUM(D6:D7)
                      Enter key from the keyboard.                     function.











                 44     CodeGPT (Ver. 4.0)-VI
   41   42   43   44   45   46   47   48   49   50   51