Using cell references
Cell references allow you to point to another cell in the spreadsheet and retrieve its value, which will help you avoid much of the manual work you have had to do up to this point. In this exercise, you'll replace hard-coded values with cell references and explore the extra functionality cell references provide.
Throughout this chapter, you'll be working with demographical and geographical data for the top ten most populous countries in the world.
This exercise is part of the course
Introduction to Google Sheets
Exercise instructions
- Set
B2
to the cell reference,B10
. - Update the value in
B10
toEurope
and notice what happens toB2
. - Change
B5
to point to theContinent
information forIndia
using a cell reference.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
