Page 29 - KEC Khaitan C6 Flipbook
P. 29
6 Type the arguments in the number fields which are
the range of cells to find the sum of their contents.
7 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 start of the text string. Output: Tra
RIGHT(text, It returns the specified number of characters Input: =RIGHT("Track",3)
num_chars) from the end 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
Formulas and Functions in Excel 2021 27

