In the senior application of Excel, many statistics functions can bring great convenience to our statistical work. Finding a suitable statistical function for data statistics according to the characteristics of the data can improve the efficiency of data processing. In this paper, by comparing three statistical functions, their characteristics and advantages are introduced.