Page 48 - 2502_Pakistan-kifayat_C-8

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
Function name must be a valid Excel 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

Product(range) It multiplies the values given as argument or Input: =PRODUCT(4,2,8)
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.

46 Premium Edition-VIII