Page 45 - TP_Pluse_V2.2_Class_6
P. 45
Let us use the Text functions by performing the following steps:
Step 1: Type the following data in the Excel worksheet.
Step 2: Type the =CONCATENATE(A3,B3) function in the cell C3 to concatenate the first name and
last name.
Step 3: Press the Enter key from the keyboard.
Using CONCATENATE function
When you press the Enter key, first name and last name appear after concatenation.
Logical Functions
Functions Purpose Example
It checks whether the given condition is met, and Percentage = 80
IF(condition, returns value1 if the condition evaluates to true, Input: =IF(Percentage >=
value1, value2) and returns value2 if the condition evaluates 50, “Passed”, “Failed”)
to false. Output: Passed
Statistical Functions
Functions Purpose Example
Input: =MAX(4,16,12,9)
MAX(range) It returns the largest value in the given range.
Output: 16
Input: =MIN(4,16,12,9)
MIN(range) It returns the smallest value in the given range.
Output: 4
It returns the average of the given numbers in a Input: =AVERAGE(12,3,6)
AVERAGE(range)
range. Output: 7
It returns the count of the number of values in the Input: =COUNT(4,8,12)
COUNT(range)
selected range. Output: 3
Let us use the Statistical functions in Excel.
Perform the following steps to use the Statistical functions:
Step 1: Type the following data in the Excel worksheet.
Step 2: Type =MAX(B3:F3) function in the cell G3 to find the maximum marks.
Formulas and Functions in Excel 2016 43

