Page 26 - Trackpad_V5_Book 6
P. 26
FUNCTIONS
A function is a predefined formula in Excel. It starts with the = (equal to) sign. Functions are used
for computing complex calculations. There are many built-in functions provided by Excel. They
accept arguments and return values.
Arguments are input to the functions. The values should be given in between opening and closing
( ) parenthesis. For example, SUM(A1:A5) A1 and A5 are arguments and Sum is a function.
Some rules for using the Functions are:
All Excel functions must begin with = sign
Function name must be a valid Excel name.
Function must be followed by opening and closing parenthesis.
Most of the functions must contain an argument within it.
Let’s discuss the categories of function.
MATHEMATICAL FUNCTIONS
Some mathematical functions with their examples are given below.
Function 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 Input: =MOD(8,5)
(number, divisor) divided 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 the number to an integer value.
Output: 14
POWER It returns the result of a number raised to Input: =POWER(5,3)
(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
Input: =ABS(–25)
ABS(number) It returns the absolute value of a given number.
Output: 25
24 Pro (Ver. 5.0)-VI

