Cell ranges
In the previous exercise, you identified individual cells using their cell addresses, and changed the contents of the cells. Often in Google Sheets, you'll interact with groups of cell, and to do this effectively, you'll need to use and understand cell ranges.
In this exercise, you'll identify groups of cells using cell ranges, and modify their contents.
This exercise is part of the course
Introduction to Google Sheets
Exercise instructions
- Change the values of the cell range
B2:C3
to130
,200
,135
,500
(from left to right then top to bottom). - Change
E4:E5
dollar amounts to$2.50
and$0.25
(from top to bottom).
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
