開始使用免費開始

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.

本練習屬於課程

Google Sheets 入門

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習