Page 47 - TP_Plus_v4_Class6
P. 47
The function in the example below would add the values of the cell range A1:A20.
Rules for Using Functions =SUM(A1:A20)
All Excel functions must begin with = sign.
Equal sign Argument
Function name must be a valid Excel name. Function Name
Function must be followed by opening and closing parenthesis.
Most of the functions contain an argument.
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
It returns the sum of values given as argument Input: =SUM(4,8,12,16)
Sum(range)
or values in a range of cells. Output: 40
It multiplies the values given as argument or Input: =PRODUCT(4,2,8)
Product(range)
values in a range of cells. Output: 64
It returns the remainder after a number is Input: =MOD(8,5)
Mod (number, divisor)
divided by the divisor. Output: 3
It returns the square root of the given Input: =SQRT(81)
Sqrt(number)
number. Output: 9
Input: =INT(14.25)
Int(number) It rounds number to an integer value.
Output: 14
It returns the result of a number raised to Input: =POWER(5,3)
Power(number, power)
some power. Output: 125
ROUND(number, It returns a number after rounding to the Input: =ROUND(35.666,2)
number_of_digits) specified digits. Output: 35.67
It returns the absolute value of a given Input: =ABS(–25)
ABS(number)
number. Output: 25
Factbot
In functions, we can also use the address of a range of cells in place of the values.
Let us use the mathematical functions in Excel.
#Charts, Formulas and Functions in Excel 45

