Excel Study · Module 1: First steps

Class 3AVERAGE, MIN & MAX

Name: Excel Class 3: AVERAGE, MIN & MAX
Uploaded: 2026-10-04T15:40:17-07:00
Duration: 1 min 26 s
Description: Three of the most used Excel functions: =AVERAGE(B2:B8) for the mean, =MAX(B2:B8) for the highest value and =MIN(B2:B8) for the lowest. Change any score and all three update at once.

Basics1:26 videoFree

Watch on YouTube ↗

Three of the most used Excel functions: =AVERAGE(B2:B8) for the mean, =MAX(B2:B8) for the highest value and =MIN(B2:B8) for the lowest. Change any score and all three update at once.

Try this AI prompt

Works in ChatGPT, Gemini, Copilot or Claude.

In Excel, student scores are in cells B2 to B8. Write a formula that finds the highest score.

The answer that works

✓ checked in Excel

=MAX(B2:B8)

AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.