How to perform a calculation using SUM and AVERAGE functions in MS Excel:
Assuming you have a data set of exam scores in cells A1:A10:
1. Select cell B1 (where you want to display the total score)
2. Type: =SUM(A1:A10)
3. Press Enter
This will calculate the total score: ∑(A1:A10) = ?
1. Select cell B2 (where you want to display the average score)
2. Type: =AVERAGE(A1:A10)
3. Press Enter
This will calculate the average score: Average(A1:A10) = ?
Example:
| Exam Score | Total Score | Average Score |
| — | — | — |
| 80 | | |
| 70 | | |
| 90 | | |
| 85 | | |
| 75 | | |
| 95 | | |
| 80 | | |
| 70 | | |
| 85 | | |
| | =SUM(A1:A10) | =AVERAGE(A1:A10) |
Result:
| Exam Score | Total Score | Average Score |
| — | — | — |
| 80 | 805 | 80.5 |
| 70 | | |
| 90 | | |
| 85 | | |
| 75 | | |
| 95 | | |
| 80 | | |
| 70 | | |
| 85 | | |
In this example, the total score is 805, and the average score is 80.5