KS3 Spreadsheet modelling test

Cells that run horizontally on a spreadsheet

• Row
• Column
• Workbook
• Range

Cells that run vertically on a spreadsheet

• Row
• Workbook
• Worksheet
• Column

The location of a cell on a spreadsheet. It is a column letter followed by a row number.

• Cell range
• Cell reference
• Active cell
• Row

The cell that is currently selected

• Cell reference
• Cell range
• Label
• Active cell

What does merging cells do?

• It links up two different cells together

• It combines the selected cells together to form one big cell

• It copies and pastes the information from one cell to another

Text, symbols, dates is a.....

• Value

• Label

• Function

• Formula

A number that is entered into a spreadsheet and used for calculations

• Value
• Label
• Function
• Formula

A group of cells in a spreadsheet

• Cell reference
• Cell range
• Active cells
• Formulas

The letter at the top of each column is called a:

• cell reference
• row header
• column header
• range

The number to the left of a row is called a:

• cell reference
• column header
• row header
• range