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.

Este exercício faz parte do curso

Introdução ao Google Sheets

Ver Curso

Instruções de exercício

  • 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).

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Comece o exercício