Page 28 - Chinmaya_C6_flipbook
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 (“Touch”, “pad”)
(text1, text2) strings.
Output: Touchpad
LEFT(text, It returns the specified number of characters Input: =LEFT(“Touch”,3)
num_chars) from the left side of the text string. Output: Tou
RIGHT(text, It returns the specified number of characters Input: =RIGHT(“Touch”,3)
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 uppercase.
Output: TOUCH
Input: =LOWER(”Touch”)
LOWER(text) It converts the text string into lowercase.
Output: touch
26 Premium Edition-VI

