The COUNT function calculates how many values are present in the selected range of cells.
Use the COUNTIF function, to count cells based on a single criterion; e.g. count cells if equal to etc.
To highlight, how many blank cells are present in the selected range of cells, use the COUNTBLANK function.
Use the average function to get an average of numbers or range of cells.
The AverageIF function calculates an average of range of cells based on one condition, like you may exclude 9 to calculate average.
In above screenshot, the second smallest values were found by using the function.
To highlight the largest figure or second largest etc., use the LARGE function.
To calculate median of data, use the MEDIAN function.
Use MODE function to find out mode of the selected values.
To calculate standard deviation, use the STDEVA function.