Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 20 - 2617_JSSPS_C-6
P. 20

    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

                     18     Premium Edition-VI

| 15 16 17 18 19 20 21 22 23 24 25 |