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
   40   41   42   43   44   45   46   47   48   49   50