Page 25 - TP_iPlus_V2.1_Class8
P. 25
Functions Purpose Example
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 digits. Output: 35.67
It returns the absolute value of a Input: =ABS(-25)
ABS(number)
given number. Output: 25
To use the mathematical functions, follow the given steps:
2 To calculate the
1 Type the price of Pencils, type
following data
the =PRODUCT(B3:C3)
in the Excel
function in cell D3 and
worksheet.
press the Enter key.
Info Byte
In functions, we can also use the cell address in place of the values.
When you press the Enter key, the 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)
function in cell D6 and
press the Enter key.
23
Spreadsheet—Functions and Charts

