AVERAGE, MIN and MAX work just like SUM: give them a range and they do the rest.

What is the class average?