Page 84 - TGPT_V5.0_C5_Flipbook
P. 84

FUNCTIONS


              Functions are predefined formulas in Excel to perform both simple and complex calculations. They
              accept arguments and return values. Arguments are input to the functions. These arguments can
              be numbers or text. The values should be given in between opening and closing ( ) parenthesis.


              Rules for Using Functions

              Rules for using Functions are:

                  All Excel functions must begin with = sign.
                  Function name must be a valid Excel name.

                  Function must be followed by opening and closing parenthesis.
                  Most of the functions must contain an argument within it.

              Categories of Functions


              Excel provides many categories of functions.

              Let us discuss some of these categories in detail.

              Mathematical Functions

              Mathematical functions are used to solve mathematical values.

                   Functions                             Purpose                                  Example
                                                                                         Input: =SUM(D3:D7)
               sum(range)           It returns the sum of a range.
                                                                                         Output: 6590
                                                                                         Input: =PRODUCT(B4:C4)
               Product(range)       It multiplies the values in a range of cells.
                                                                                         Output: 1350
                                    It returns the count of the number of values in  Input: =COUNT(D3:D7)
               Count(range)         the selected range.                                  Output: 5


                                                                                          Input: =MAX(B3:B7)
                Max(range)          It returns the largest value in the given range.
                                                                                          Output: 1500
                                                                                          Input: =MIN(C3:C7)
                Min(range)          It returns the smallest value in the given range.
                                                                                          Output: 1














                                                             Factbot


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




                  82  Premium Edition-V
   79   80   81   82   83   84   85   86   87   88   89