← My dashboard
SHEET 003
The semester summary
Excel · Module 1 · SUM · AVERAGE · MAX+75 XP
Professor Owl · Treasury
Six months of fees in three numbers.
The Academy board wants a summary of the fees collected each month: the total, the average and the best month.
Task 1 of 3 · cells E2
In E2 calculate the total fees for the semester.
Key facts
- Data range: B2:B7
- Three questions in a row
E2fx
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Month | Fees | |||
| 2 | January | 1250 | Total | ||
| 3 | February | 980 | Average | ||
| 4 | March | 1430 | Best month | ||
| 5 | April | 1120 | |||
| 6 | May | 1610 | |||
| 7 | June | 870 |
The cells with a dotted border are the ones you must fill in. Separate arguments with , or ;
🎯 Each marked cell has to be a formula that calculates the correct result.