1. =Average()
    This function is use to find out average value of a given number.



2. =Averageif()
    This function is use to find out the average value of a given number from a specified range those are fulfil our condition.



3. =Min()
    It return the minimum value from specified range.



4. =Max()
    It returns to the maximum value from the given range.



5. Large()
    To find the third largest number, use the following LARGE function.


Here 1st largest value – 9, 2nd largest value – 9, 3rd largest value – 8


6. Small()
    To find the third Smallest number, use the following SMALL function.


Here 1st smallest – 4, 2nd smallest – 5, 3rd smallest – 6


7. =Median()
  • When we find out median or middle number first we have to sort the number in ascending order.
  • Count the total number. If number is odd, formula 


  • If number is Even, formula



8. =Mode()
    Mode function returns the number having maximum frequency.