Year 7 Spreadsheets L3 - Data and Information

Match the following

• Cell reference

• Facts and figures that have been organised so that they have meaning

• Primary source data

• Facts and figures

• Data

• Data that somebody else collected and that you are using

• Information

• The location of a cell, made up of a column name and a row number

• Secondary Source Data

• Data that you have collected and that you are using yourself

What is the cell range of the cells highlighted in blue?

What are spreadsheets used for? (select all that apply)

• To perform powerful calculations

• Make graphs and charts

• Analyse patterns in the data

• To store information and data

A specific location such as A4:C16 that refers to a group of adjacent cells is known as ______

• cell address

• cell range

• columns

• rows

Rows are identified by what?

• Letters of the alphabet

• Numbers

• Roman numerals

What is the name of this part of a Spreadsheet?

• Row

• Column

• Letters

• Cell

• Spreadsheet

What are written in cell range E4:E7?

• The item numbers

• The quantities

• The unit prices

When you write a formula, you start it with one of these to identify it as a formula.

• letter

• number

• symbol

• function

The cell that is selected is known as what?

• The active cell

• The cell range

• The row

What is the cell range of the item numbers?

• A4:A7

• A4-A7

• C3:C7