Page 50 - modular4.0
P. 50
Chapter Profile
Function Purpose Example
It returns the remainder after a Input: =MOD(8,5)
MOD(number, divisor)
number is divided by the divisor. Output: 3
It returns the square root of the Input: =SQRT(81)
SQRT(number)
given number. Output: 9
It rounds number down to the Input: =INT(14.25)
INT(number)
nearest integer value. Output: 14
It returns the result of a number Input: =POWER(5,3)
POWER(number, power)
raised to some power. Output: 125
ROUND(number, It returns a number after rounding Input: =ROUND(35.666,2)
number_of_digits) to the specified number of digits. Output: 35.67
It returns the absolute value of a Input: =ABS(-25)
ABS(number)
given number. Output: 25
Let us use the mathematical functions in Excel 2019.
Perform the following steps to use the mathematical functions:
1 Type the given
data in the Excel 2019
worksheet.
2 To calculate the price of Pencils, type the
=PRODUCT(B3:C3) function and press Enter key.
When you press the Enter key, price of the pencils appears in the cell D3. Using the AutoFill feature,
we can calculate the prices of the Geometry Boxes and Pens.
3 To calculate the subtotal,
type the =SUM(D3:D5) in the
cell D6 and press Enter key.
When you press the Enter key, subtotal appears in the cell D6.
48 Modular (Ver. 4.0)-VII

