Page 25 - iprime_V2.2_class8
P. 25
Functions Purpose Example
Returns the remainder after dividing Input: =MOD(8,5)
MOD(number, divisor)
the number by the divisor Output: 3
Returns the square root of the given Input: =SQRT(81)
SQRT(number)
number Output: 9
Rounds the number to the nearest Input: =INT(14.25)
INT(number)
integer Output: 14
Returns the result of the number Input: =POWER(5,3)
POWER(number, power)
raised to the given power Output: 125
ROUND(number, Returns a number after rounding it Input: =ROUND(35.666,2)
number_of_digits) to the specified digits Output: 35.67
Returns the number of absolute Input: =ABS(-25)
ABS(number) value of the given number Output: 25
Tech Funda
In Excel functions, you can use cell addresses instead of direct values.
To use the mathematical functions in Excel, follow these steps:
Step 1 Type the data in the Excel worksheet.
Step 2 To calculate the total price of Pencils, type =PRODUCT(B3:C3) function in cell D3.
Step 3 Press the Enter key.
Using PRODUCT Function
When you press the Enter key, the total price of the pencils appears in the cell D3. Using
the AutoFill feature, we can calculate the total prices of the Geometry Boxes and Pens.
Spreadsheet—Functions and Charts 23

