Page 26 - iPlus_Ver_2.0_class_8
P. 26
4 Calculate the
Tax by using the
=(D6*7)/100
formula.
5 Calculate the Total by using the =SUM(D6:D7) function.
Text Functions
Functions Purpose Example
Input: =CONCATENATE(“Touch”, “pad”)
CONCATENATE(text1, It joins together two or more
Output: Touchpad
text2) different text strings.
It returns the specified number Input: =LEFT(“Touch”,3)
LEFT(text, num_chars) of characters from the left side of Output: Tou
the text string.
It returns the specified number of Input: =RIGHT(“Touch”,3)
RIGHT(text, num_chars) characters from the right side of Output: uch
the text string.
It returns the length of the text Input: =LEN(“Touch”)
LEN(text)
string. Output: 5
It converts the text string into Input: =UPPER(“Touch”)
UPPER(text)
uppercase. Output: TOUCH
It converts the text string into Input: =LOWER(”Touch”)
LOWER(text)
lowercase. Output: touch
To use the Text functions, follow the given steps:
1 Type the
following
data in
the Excel 2 Type =CONCATENATE(A3,B3)
worksheet. function to concatenate the First
Name and Last Name and press
the Enter key.
24
iPlus (Ver. 2.0)-VIII

