Page 44 - Plus_V2.2_C6_Flipbook
P. 44
Rules for using Functions
All Excel functions must begin with = sign.
Function name must be a valid Excel name.
Function must be followed by opening and closing parentheses.
Most of the functions must contain an argument within it.
Categories of Functions
Excel provides many categories of functions. Some of them are:
Mathematical Functions: Calculates the square root or absolute value of a number, product of
numbers, maximum, minimum, average etc.
Text Functions: Performs a number of operations on strings (i.e. a collection of characters
like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two strings,
searching for one string inside another etc.
Logical Functions: Evaluates conditions such as X > 5 and give the result as true or false.
Date and Time Functions: Calculates the day, month and year in a date and the hour, minute
and second at a particular time.
Let us discuss these categories in detail.
Mathematical Functions
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 It returns the remainder after a number is divided Input: =MOD(8,5)
(number, divisor) by the divisor. Output: 3
Input: =SQRT(81)
SQRT(number) It returns the square root of the given number.
Output: 9
Input: =INT(14.25)
INT(number) It rounds number to an integer value.
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
42 Premium Edition-VI

