Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - ClickGPT V4.0 C-5
P. 35

    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  33

| 30 31 32 33 34 35 36 37 38 39 40 |