Percentages and references
You can use cell references in any of the types of calculations that you saw in Chapter 1, including percentage calculations.
Using cell references means that you don't have to manually look up and enter values into each formula; you can instead use a cell reference to perform one calculation, then copy the reference to populate the remaining cells.
You're also not limited to using a single reference in a formula, you can perform calculations with multiple references as well, which you'll explore in this exercise.
This exercise is part of the course
Introduction to Google Sheets
Exercise instructions
- In
D2:D11, fill in the growth of the population in the past year, which you can assume grew by1.12%for each country. - In
E2:E11, use references to fill in the population density of each country, which is calculated by dividing thePopulationbyLand Area (km2).
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise