Page 29 - Trackpad_V2.1_Class6
P. 29

For example, CONCATENATE () function:


                                                                             2  Type =CONCATENATE(A1,B1)
                                                                             function to concatenate two
                                                                             strings using cell reference.



                                                                             1  Type this data.


                 STATISTICAL AND LOGICAL FUNCTIONS

                 Some statistical and logical functions with their examples are given below:


                        Function                           Purpose                               Example



                                         It  returns the  largest  value  in  the  given  Input: =MAX(4,16,12,9)
                  MAX(range)
                                         range.                                         Output: 16

                                         It returns the smallest value in the given  Input: =MIN(4,16,12,9)
                  MIN(range)
                                         range.                                         Output: 4

                                         It returns the average of numbers, specific  Input: =AVERAGE(10, 12, 14)
                  AVERAGE(range)
                                         cell references, ranges of cells.              Output: 12

                                         It returns the count of the number of values  Input: =COUNT(4,8,12)
                  COUNT(range)
                                         in the selected range.                         Output: 3

                                         It  checks  whether the  given  condition  is  Percentage = 80
                  IF(condition,          met,  and returns value1 if the condition  Input: =IF(Percentage > 50,
                  value1, value2)        evaluates to true, and returns value2 if the  “Passed”, “Failed”)

                                         condition evaluates to false.                  Output: Passed

                 For example, MAX () function:








                                                                                        2  Type =MAX(B3:F3)
                                                                                        function in the cell G3.






                               1  Type this data.

                 Now press the Enter key and the maximum marks appear in cell G3. Similarly, we can find the
                 minimum marks by using the MIN() function.



                                                                                 Formulas and Functions in Excel 2016  27
   24   25   26   27   28   29   30   31   32   33   34