Spreadsheet rows, columns and cells

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which way do columns run in a spreadsheet?

A Down the sheet, labelled with letters

B Across the sheet, labelled with numbers

2. Which way do rows run in a spreadsheet?

A Across the sheet, labelled with numbers

B Down the sheet, labelled with letters

3. What is a cell in a spreadsheet?

A The whole grid of columns and rows

B The box where a column and a row meet

4. Which cell is where column B meets row 3?

A B3

B 3B

5. Which one is a column heading?

A 4

B D

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1B		AA1
23		BA column letter - it names a column that runs down the grid
3A cell is where a column and a row meet, and its name is the column letter then the row number		CA row number - it names a row that runs across the grid
4The very first cell in a worksheet is in column A and row 1		DThe row number was written before the column letter. A cell name puts the column letter first, so it should be C4.
5Cell 4C		EThe letters and numbers are swapped. Columns have letters (A, B, C) and rows have numbers (1, 2, 3).
6Rows have letters and columns have numbers		FB3

Definitions

spreadsheet

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Columns run down and are named with _______

Rows run across and are named with _______

Column B and row 3 meet in cell __

A ____ is where a column and a row meet

Each _________ holds one grid of cells

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Columns run across: A, B, C

B Rows run across: 1, 2, 3

C Cell = column + row

D Example cell: B3

Question 2

A Rows have letters: A, B, C

B Rows run across the sheet

C Columns have letters: A, B

D Cell C2 is column C, row 2

Question 3

A Column B holds the names

B Row 1 holds the headings

C Cell B1 is row B, column 1

Question 4

A Column C runs down the sheet

B Row 4 runs across the sheet

C Cell C4 is in column 4, row C

Question 5

A Worksheet: Class Scores

B Column A: student names

C Column B: scores

D Each worksheet has many grids

Answer Key

Spreadsheet rows, columns and cells

Section A: Quick Questions

A — Down the sheet, labelled with letters

A — Across the sheet, labelled with numbers

B — The box where a column and a row meet

A — B3

B — D

Section B: Match the Pairs

B → A column letter - it names a column that runs down the grid

3 → A row number - it names a row that runs across the grid

A cell is where a column and a row meet, and its name is the column letter then the row number → B3

The very first cell in a worksheet is in column A and row 1 → A1

Cell 4C → The row number was written before the column letter. A cell name puts the column letter first, so it should be C4.

Rows have letters and columns have numbers → The letters and numbers are swapped. Columns have letters (A, B, C) and rows have numbers (1, 2, 3).

Section C: Definitions

spreadsheet — A grid of columns (letters, running down) and rows (numbers, running across). A cell is where a column and row meet, like B3. Each worksheet holds one grid.

Section D: Fill in the Blanks

Columns run down and are named with letters

Rows run across and are named with numbers

Column B and row 3 meet in cell B3

A cell is where a column and a row meet

Each worksheet holds one grid of cells

Section E: Spot the Error

A — Columns run down the sheet, not across. Rows are the ones that run across. Line 1 should say: Columns run down: A, B, C.

A — Rows are labelled with numbers (1, 2, 3). Letters are used for columns. Line 1 should say: Rows have numbers: 1, 2, 3.

C — In a cell name the letter is the column and the number is the row. B1 is column B, row 1, not row B, column 1.

C — Columns have letters and rows have numbers. Cell C4 is in column C and row 4, where the two meet.

D — Each worksheet holds just one grid of columns, rows and cells. The line should say: Each worksheet holds one grid.