Get startedGet started for free

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

View Course

Exercise instructions

  • Change the values of the cell range B2:C3 to 130, 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

Start Exercise