Page 45 - C_GPT _V4 _class_6
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 Functions
Mathematical functions are used to solve mathematical values.
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

