Cells and ranges
Exercise 1 of 5
Each cell has an address: its column letter, then its row number. Click the cell that holds the price of apples.
About this lesson
Every cell has an address made of its column letter and row number, and a block of cells is a range like A1:B3. Here you select them on the sheet: click a cell, drag over a range, and pick whole columns.
In this lesson
- Each cell has an address: its column letter, then its row number. Click the cell that holds the price of apples.
- A range is a block of cells, written as the first cell, a colon and the last cell. Drag from the first price to the last to select the prices of all three items.
- A range is a block of cells, written as the first cell, a colon and the last cell. How many cells are in
B2:C5? Drag over it on the sheet to count. - Select the whole of column A by clicking its letter at the top of the sheet.
- Select two rows at once: apples (A2:B2) and milk (A4:B4). Select the first, then hold Ctrl (Cmd on a Mac) while you drag over the second.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Click a cell, or drag over a range. It is checked as soon as the selection is right.