SUM, AVERAGE, MIN & MAX practice exercises

SUM, AVERAGE, MIN and MAX are the first formulas everyone needs: totals, averages and the highest and lowest values in a column. MEDIAN gives the middle value, which is often more honest than the average when there are outliers.

Syntax

SUM(range)  ·  AVERAGE(range)  ·  MIN(range)  ·  MAX(range)  ·  MEDIAN(range)
range
A block of cells like F2:F9. You can also list several ranges separated by commas.

The practice data

An orders table: who sold what, where, and for how much. Every exercise below uses this sheet, and your answer goes in H2.

ABCDEF
1RepRegionProductUnitsPriceSales
2AnaEastWidget12560
3BenWestGadget520100
4CaraEastGadget820160
5DevNorthWidget205100
6AnaWestGizmo350150
7BenEastWidget7535
8CaraNorthGizmo250100
9DevEastGadget620120

Worked example

=SUM(F2:F9)

Adds up all 8 Sales values. Result:

825

Your turn: 3 exercises

Type a formula and press Enter. It is checked by a real formula engine, so any correct approach counts.

1 Return the average Units per order.

H2

2 Return the difference between the largest and smallest Sales value.

H2

3 Return the median Sales value.

H2

Practice SUM, AVERAGE, MIN & MAX in the full lesson, free

Lesson 2 has more exercises in a real spreadsheet grid, with hints and progress tracking. No card needed.

Open lesson 2

Common SUM, AVERAGE, MIN & MAX mistakes

FAQ

Why does my SUM show 0?

The numbers are probably stored as text, often after pasting. Convert them with VALUE or Data → Split text to columns.

AVERAGE or MEDIAN?

AVERAGE is pulled up or down by extreme values; MEDIAN is the middle value and ignores outliers.

Keep practicing