← My dashboard
SHEET 004
Rounded grades
Excel · Module 1 · ROUND+100 XP
Professor Owl · Treasury
The averages have too many decimals.
The report card shows the average of three exams, but with endless decimals. Calculate the average and round it to one decimal.
Goal · cells E2:E6
In E2:E6 calculate the average of the three exams rounded to 1 decimal.
Key facts
- Nested functions
- ROUND(number, decimals)
E2fx
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Student | Exam 1 | Exam 2 | Exam 3 | Average |
| 2 | Ada | 8 | 9.5 | 7 | |
| 3 | Bruno | 5.5 | 6 | 7.25 | |
| 4 | Clara | 9 | 9 | 10 | |
| 5 | Diego | 4 | 6.5 | 5 | |
| 6 | Elena | 7.75 | 8 | 6.5 |
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.