Page 56 - TP_Prime_v2.2_Class_6
P. 56
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.
When you press the Enter key, the price of the pencils appears in cell D3. Using the Auto
Fill 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.
Prime (Ver. 2.2)-VI When you press the Enter key, subtotal appears in the cell D6.
Step 5: Press the Enter key from the keyboard.
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:
54
Using PRODUCT Function
Using SUM Function Displaying Total
Text Functions
Function Purpose Example
CONCATENATE It joins together two or more Input: =CONCATENATE(“Touch”,
(text1, text2) different text strings. “pad”)
Output: Touchpad

