Exercises / Foundations · 2 of 12
Average two exam scores
Excel follows maths rules: brackets first, then * and /, then + and -. So =2+4/2 is 4, not 3. Brackets make Excel do the part you want first.
Your taskIn D2, work out the average of the two exam scores in B2 and C2 with + and /: add them, then divide by 2.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Student | Exam 1 | Exam 2 | Average | ||
| 2 | Lena | 78 | 86 | |||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 |