Page 28 - Trackpad_V2.1_Class6
P. 28
5 Type the arguments in the number fields which are
the range of cells to find the sum of their contents.
6 Click on OK button.
Tick ( ) if you know this.
A formula starts with an (=) sign.
Functions are predefined formulas that perform a series of operations on a specified range of
values.
TEXT FUNCTIONS
Some text functions with their examples are given below:
Function Purpose Example
Input: =CONCATENATE
CONCATENATE It joins together two or more different text (“Track”, “pad”)
(text1, text2) strings.
Output: Trackpad
LEFT(text, It returns the specified number of characters Input: =LEFT(“Track”,3)
num_chars) from the left side of the text string. Output: Tra
RIGHT(text, It returns the specified number of characters Input: =RIGHT(“Track”,3)
num_chars) from the right side of the text string. Output: ack
Input: =LEN(“Track”)
LEN(text) It returns the length of the text string.
Output: 5
Input: =UPPER(“Track”)
UPPER(text) It converts the text string into uppercase.
Output: TRACK
Input: =LOWER(“Track”)
LOWER(text) It converts the text string into lowercase.
Output: track
26 Trackpad (V2.1)-VI

