Page 30 - KEC Khaitan C6 Flipbook
P. 30

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 with their examples are given below:



                         Function                           Purpose                               Example




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

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

                                                                                         Input: =AVERAGE(10, 12, 14)
                    AVERAGE(range)        It returns the average of a range of numbers.
                                                                                         Output: 12

                                          It returns the count of the number of values in  Input: =COUNT(4,8,12)
                    COUNT(range)
                                          the selected range.                            Output: 3
                                          It checks whether the given condition is met,  Percentage = 80
                    IF(condition, value1,   and returns value1 if the condition evaluates  Input: =IF(Percentage >= 50,
                    value2)               to  true,  and  returns value2  if the  condition  “Passed”, “Failed”)
                                          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.



                   28   Premium Edition-VI
   25   26   27   28   29   30   31   32   33   34   35