Page 45 - Trackpad_V4.0_c6_Flpbook
P. 45

Interdisciplinary Learning                                                    Lab Activity


                    If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then calculate and write the output of the
                    following formulas:
                    a.  (A1 - A2) * A3

                    b.  A3 + (A1 * A2)
                    c.  A1 * (A2 + A3) – 10



                 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 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
                                                                                             Input: =SUM(4,8,12,16)
                 Sum(range)           It returns the sum of a range.
                                                                                             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 number by  Input: =MOD(8,5)
                 divisor)             the divisor.                                           Output: 3
                                                                                             Input: =SQRT(81)
                 Sqrt(number)         It returns the square root of the given number.
                                                                                             Output: 9
                                      It removes the decimal part of a number and            Input: =INT(14.25)
                 Int(number)
                                      returns only the integer part.                         Output: 14
                 Power(number,        It returns the result of a number raised to some       Input: =POWER(5,3)
                 power)               power.                                                 Output: 125
                                      It returns the count of the number of values in the    Input: =COUNT(4,8,12)
                 Count(range)
                                      selected range.                                        Output: 3




                                                                             Charts, Formulas & Functions in Excel  43
   40   41   42   43   44   45   46   47   48   49   50