PracticeExcelSign in
Excel practice exercises

AVERAGE practice exercises

Find the mean of a range with AVERAGE, and see how it treats blank cells and text differently from zeros.

Start the first exercise
  1. 1Find the average with AVERAGEIn B7, use AVERAGE to find the mean score in B2:B6.
  2. 2AVERAGE skips blank cellsTuesday has no sales figure yet. In B7, use AVERAGE on B2:B6 to get the average of the days that do have one.
  3. 3Round an average with ROUNDIn E1, work out the average number of visitors per day, rounded to one decimal. Put AVERAGE inside ROUND: ROUND(AVERAGE(B2:B7),1).

Functions in this topic

Read the guide