Year 7 Spreadsheets L3 - Data and Information

Match the following

• Data

• Data that somebody else collected and that you are using

• Cell reference

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

• Secondary Source Data

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

• Primary source data

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

• Information

• Facts and figures

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