Page 28 - TP-Play_V-2.0_Book-6
P. 28
Functions Purpose Example
It returns the count of the number Input: =COUNT(4,8,12)
COUNT(range)
of values in the selected range. Output: 3
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
Let us use the mathematical functions in Excel 2016.
Perform the following steps to use the mathematical
functions:
Step 1 Type the given data in the Excel 2016
worksheet.
Step 2 To calculate the price of Pencils, type the
=PRODUCT(B3:C3) function in the cell D3.
Step 3 Press the Enter key from the keyboard.
Using PRODUCT function
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.
Step 4 To calculate the subtotal, type the
=SUM(D3:D5) in the cell D6.
Step 5 Press the Enter key from the keyboard.
Using SUM function
When you press the Enter key, subtotal appears in
the cell D6.
Step 6 Calculate the Tax by using the =(D6*7)/100
formula.
Step 7 Calculate the Total by using the
=SUM(D6:D7) function. Final output
appears as shown:
Text Functions Displaying Total
Functions Purpose Example
Input: =CONCATENATE(“Touch”,
CONCATENATE(text1, It joins together two or more
“pad”)
text2) different text strings.
Output: Touchpad
28 Play (Ver. 2.0)-VI

