Basic Functions
Intermediate
Percentage Calculations
Calculate percentages using basic arithmetic.
Task:
You are analyzing student scores and need to determine each student's contribution to the total score. Calculate what percentage each student's score is of the total score in column C to understand individual performance relative to the whole.
Learning Objectives:
- Learn percentage calculations
- Understand absolute vs relative references
- Practice formula copying
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Percentage |
| 2 | John | 85 | |
| 3 | Mary | 92 | |
| 4 | Tom | 78 | |
| 5 | Sarah | 95 | |
| 6 | Total | 350 |
What this exercise teaches (contains the answer)
Percentage calculations involve dividing a part by the whole. Using absolute references ($) is crucial when a part of the formula (like the total) should remain fixed when copying the formula to other cells.