NEW
Font size
WorksheetsSpreadsheets Year 7
Total questions: 12
Worksheet time: 6mins
What is a spreadsheet?
A sheet of paper.
A Computer Game.
An electronic document where data is organized in rows and columns.
A PowerPoint.
Which is the correct arithmetic operator for multiplication?
+
*
/
-
Which is the correct arithmetic operator for Division?
-
*
+
/
Which is the correct arithmetic operator for subtraction?
+
-
*
&
Which is the correct formula to work out a grand total?
=sum(D3:D8)
D3:D8
=AverageD3:D8)
total = add up
Which is the correct cell reference for the Ruler?
A1
A2
A3
A4
Which item would be selected if we used cell reference A3?
Pen
Ruler
Items
Pencil
Which symbol do we use to make an cell an absolute cell (Stays the same)?
%
£
$
!
SUM, AVERAGE, MAX and IF are examples of what?
Functions
Tools
Options
Statistical Tools
When you key a formula in a spreadsheet what do you key in first?
+
*
=
%
To restrict the data that can be entered into a cell e.g. Gender = "M" or "F", is called?
Calculations
Search
Sorting
Data Validation
Changing the appearance of a cell based on a rule is called?
Conditional Formatting
Data Validation
User Input
Sorting
