Excel: AVERAGE, MIN and MAX

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel: AVERAGE, MIN and MAX

AVERAGE adds a range and divides by how many numbers it holds; MIN and MAX find the smallest and biggest. Functions can be combined, like =MAX(B2:B9)−MIN(B2:B9).

Key words

AVERAGE
Skips empty cells and text.
MAX − MIN
How spread out the numbers are.

🔎 What to look for: An empty cell isn't a zero: AVERAGE leaves it out.

Zero2Hero — Zéro2Héros