Page 46 - Plus V4 with Adobe class 6
P. 46
To calculate the price
Type the given of Pencils, type the
1 data in the Excel =PRODUCT(B3:C3) function 2
worksheet. and press Enter key.
Calculate
the Tax by
using the
=(D6*7)/100 4
formula.
To calculate the subtotal, type the Calculate the Total by
3 =SUM(D3:D5) function and press 5 using the =SUM(D6:D7)
Enter key from the keyboard. function.
Text Functions
Text functions are used to work on the characters entered as text.
Functions Purpose Example
Input: =CONCATENATE
Concatenate It joins together two or more different text (“Touch”, “pad”)
(text1, text2) strings. 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
It returns the specified number of characters Input: =RIGHT(“Touch”,3)
Right(text, num_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 upper case. Output: TOUCH
Input: =LOWER(”Touch”)
Lower(text) It converts the text string into lower case. Output: touch
Let us use the Text functions by performing the following steps:
Type =CONCATENATE(A3,B3)
Type the given function to concatenate the
1 data in the Excel first name and last name and 3
worksheet. press Enter key.
When you press the Enter key, first name and last name appear after concatenation.
44 Plus (Ver. 4.0)-VI

