WorksheetsYear 7 Spreadsheets L3 - Data and Information
Total questions: 14
Worksheet time: 8mins
The location of a cell, made up of a column name and a row number
Cell reference
Data that somebody else collected and that you are using
Secondary Source Data
Facts and figures
Data
Facts and figures that have been organised so that they have meaning
Information
Data that you have collected and that you are using yourself
Primary source data
What is the cell range of the cells highlighted in blue?
(a)
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
A workbook contains one or more spreadsheets.
True
False
What column contains the days of the week?
A
B
1
2
After you edit a cell's data, you can press this key to place it back in the cell.
Return
Backspace
Delete
Escape (ESC)
This area of a worksheet displays what you type.
cell identifier
formula bar
status bar
scroll bar
