Using absolute references
The references you've used up until now are called relative references because they change when copied into other cells.
Absolute references don't change when you copy them. This behavior can be really useful, as it allows you to continually refer to single values in your cell formulas, which will update automatically if the referenced cell is changed.
In this exercise, you'll use absolute references to calculate the population of each country relative to the worldwide population as a percentage.
Deze oefening maakt deel uit van de cursus
Introductie tot Google Sheets
Oefeninstructies
- In
D2, calculate the percentage of the world population that lives inChinaby dividing the Chinese population by the world population, then multiplying by100; use an absolute reference to the world population. - Populate the remaining cells in
D2:D11by copying cellD2.
Interactieve oefening met praktijkervaring
Zet theorie om in actie met een van onze interactieve oefeningen
Begin oefening