Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 57 - 2611_SmartGPT Pro V(5.0) C-5
P. 57

    These arguments can be numbers or text. The values should be given in between the
                     opening and closing ( ) parenthesis.

                     RULES FOR USING FUNCTIONS

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

                       The function must be followed by opening and closing parenthesis.

                       Most of the functions contain an argument within it.

                     CATEGORIES OF FUNCTIONS

                     Excel provides many categories of functions. Let us discuss these categories in detail.

                     Mathematical and Statistical Functions

                     A Mathematical and Statistical function helps you perform basic math operations (such

                     as addition or subtraction) and calculate simple statistics, such as the average (mean),
                     maximum (max), and minimum (min) values of a set of numbers.

                          Functions                           Purpose                                Example

                      Sum(range)           It returns the sum of a range.                    Input: =SUM(4,8,12,16)
                                                                                             Output: 40
                                                                                             Input: =PRODUCT(4,2,8)
                      Product(range)       It multiplies the values in a range of cells.     Output: 64

                      Mod (number,         It returns the remainder after dividing a         Input: =MOD(8,5)
                      divisor)             number by the divisor.                            Output: 3

                      Sqrt(number)         It returns the square root of the given           Input: =SQRT(81)
                                                                                             Output: 9
                                           number.
                                           It removes the decimal part of a number           Input: =INT(14.25)
                      Int(number)
                                           and returns only the integer part.                Output: 14
                      Power(number,        It returns the result of a number raised to       Input: =POWER(5,3)
                      power)               some power.                                       Output: 125
                                           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 to the         Input:
                      number_of_           specified digits.                                 =ROUND(35.666,2)
                      digits)                                                                Output: 35.67

                      ABS(number)          It returns the absolute value of a given          Input: =ABS(–25)
                                           number.                                           Output: 25

                                           It returns the largest value in the given         Input: =MAX(4,16,12,9)
                      Max(range)
                                           range.                                            Output: 16
                      Min(range)           It returns the smallest value in the given        Input: =MIN(4,16,12,9)
                                                                                             Output: 4
                                           range.

                                                                                     Charts, Formulas & Functions in Excel  55

| 52 53 54 55 56 57 58 59 60 61 62 |