Excel Practice - AVERAGE
Instruction
Find the average score in column B from B2 to B6.
Formula Syntax
=AVERAGE(number1, [number2], ...)
- number1: Numeric value or numeric reference.
- [number2]: Numeric value or numeric reference.
- ...: Additional optional arguments.
What it does
Find the average score in column B from B2 to B6.
quiz-scores.xlsx
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Anna | 8 |
| 3 | Ben | 7 |
| 4 | Chris | 9 |
| 5 | Dana | 6 |
| 6 | Elly | 10 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use AVERAGE with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.