The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set. Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. The MODE.SNGL function will accept up to 254 individual arguments.
The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.