Page 46 - Plus_V2.2_C6_Flipbook
P. 46
When you press the Enter key, subtotal appears in the cell D6.
Step 6: Calculate the Tax by using the =(D6*7)/100 formula.
Using SUM function Calculating Tax
Step 7: Calculate the Total by using the =SUM(D6:D7) function. Final output appears as shown:
Displaying Total
Text Functions
Functions Purpose Example
Input: =CONCATENATE
CONCATENATE It joins together two or more different text
(text1, text2) strings. (“Touch”, “pad”)
Output: Touchpad
It returns the specified number of characters Input: =LEFT(“Touch”,3)
LEFT(text, num_chars)
from the left side of the text string. Output: Tou
RIGHT(text, num_ It returns the specified number of characters Input: =RIGHT(“Touch”,3)
chars) from the right side of the text string. Output: uch
Input: =LEN(“Touch”)
LEN(text) It returns the length of the text string.
Output: 5
Input: =UPPER(“Touch”)
UPPER(text) It converts the text string into uppercase.
Output: TOUCH
Input: =LOWER(”Touch”)
LOWER(text) It converts the text string into lowercase.
Output: touch
Let us use the Text functions by performing the following steps:
Step 1: Type the following data in the Excel worksheet.
44 Premium Edition-VI

