Page 45 - Plus V4 with Adobe class 6
P. 45
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
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
It returns the count of the number of values in Input: =COUNT(4,8,12)
Count(range)
the selected range. Output: 3
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
Input: =MAX(4,16,12,9)
Max(range) It returns the largest value in the given range.
Output: 16
It returns the smallest value in the given Input: =MIN(4,16,12,9)
Min(range)
range. Output: 4
It returns the average of the given numbers in Input: =AVERAGE(12,3,6)
Average(range)
a range. Output: 7
Factbot
In functions, we can also use the cell address in place of the values.
Let us use the mathematical functions in Excel.
Perform the following steps to use the mathematical functions:
When you press the Enter key, price of the pencils appears in the cell D3. Using the AutoFill feature,
we can calculate the prices of the Geometry Boxes and Pens.
#Charts, Formulas and Functions in Excel 43

