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.
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of Percentage Calculations
0/4The same formula in the other shapes it takes at work.
- Percentage Calculations
Calculate percentages using basic arithmetic.
CoreIntermediate - Percentage change
New minus old, divided by old — and why the order matters.
Intermediate - Add a percentage to a price
Price × (1 + rate), with the rate kept in one cell.
Beginner - Take a percentage back out
Recover the net price from a gross one — and why subtracting 20% is wrong.
Intermediate
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 teachesMay contain 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.