Page 27 - TP_Pro_V5.1_Class6
P. 27
Let us understand this by taking an example of the SUM( ) function. Perform the following steps:
2 Click on Formulas tab.
3 Click on the
Insert Function
command.
1 Select an 4 Select SUM
empty cell to in the Select a
hold the sum of Function List.
the numbers.
5 Click on the
OK button.
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
Formulas and Functions in Excel 2021 25

