Page 27 - Trackpad_V5_Book 6
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 empty
cell to hold the sum
of the numbers.
4 Click on the
OK button.
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
Formulas and Functions in Excel 2021 25

