Copying references
Referencing becomes especially useful if you start copying the references around. When you copy formulas containing references to neighboring cells, the references will shift along by the corresponding amount.
This exercise is part of the course
Introduction to Google Sheets
Exercise instructions
- In
E2, create a cell reference toC2. - Copy the cell reference in
E2to populateE2:E11with thePopulationvalues. - Populate
F2:F11with theLand Area (km2)values by copying references.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise