Page 57 - 2611_SmartGPT Pro V(5.0) C-5

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

Sum(range) It returns the sum of a range. Input: =SUM(4,8,12,16)
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 Input: =MOD(8,5)
divisor) number by the divisor. Output: 3

Sqrt(number) It returns the square root of the given Input: =SQRT(81)
Output: 9
number.
It removes the decimal part of a number Input: =INT(14.25)
Int(number)
and returns only the integer part. Output: 14
Power(number, It returns the result of a number raised to Input: =POWER(5,3)
power) some power. Output: 125
It returns the count of the number of Input: =COUNT(4,8,12)
Count(range)
values in the selected range. Output: 3
ROUND(number, It returns a number after rounding to the Input:
number_of_ specified digits. =ROUND(35.666,2)
digits) Output: 35.67

ABS(number) It returns the absolute value of a given Input: =ABS(–25)
number. Output: 25

It returns the largest value in the given Input: =MAX(4,16,12,9)
Max(range)
range. Output: 16
Min(range) It returns the smallest value in the given Input: =MIN(4,16,12,9)
Output: 4
range.

Charts, Formulas & Functions in Excel 55