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.
