NEW
Font size
WorksheetsSpreadsheets iGCSE
Total questions: 21
Worksheet time: 11mins
This is called ....
row
active cell
column
spreadsheet
A spreadsheet document is also named ...
a table
an active cell
a workbook
a cell
The cell reference of this cell is ...
A1
4C
C
C4
This is ...
The formula bar
The title bar
The cell name
The workbook name
This is ...
The formula bar
The title bar
The cell name
The workbook name
The selected cell range is ...
B
B3:B7
3:7
B3-B7
The selected cell range is ...
B3:B7-D3:D7
B3-D7
B:D
B3:D7
Where should you click to display this value as currency?
General
Formulas
Wrap text
Insert
Which data type should you use to display phone numbers correctly?
Integer
percentage
Number
Text
Which tool should you use to display correctly long pieces of data such as text?
Center text
Merge cell
wrap text
Add borders
They allow you to perform arithmetic operations on numeric data stored in cells
Formulae
Additions
active cells
replication
Which formulae would you type in D3 to add up the two cells 12 and 30 ?
B3+C3
=SUM(B3+C3)
=B3 + C3
=B3 ADD C3
Which formulae would you type in D3 to multiply the unit price with the quantity?
=D3xC3
= B3*C3
=B3 MULTIPLY C3
B3*C3
Which formulae would you type in D3 to work out the total take away the reduction?
B3-C3
= B3+C3
=SUBTRACT(B3-C3)
=B3-C3
Which formulae would you type in D3 to work out the price per person?
= B3/C3
= B3*C3
=B3-C3
=B3+C3
Which formulae would you type in D3 to work out the average of the two numbers?
= B3+C3/2
= (B3+C3)/2
=(B3+C3):2
=(B3-C3)/2
What happens if you click and drag the fill handle at the bottom right of an active cell?
The cell is enlarged
The formula is deleted
The formula is replicated
The formula will be recalculated
The formula in C3 has been replicated. Did it use relative or absolute cell referencing?
Relative
Absolute
Which formula should we enter in D3 to multiply each number by the given multiplicator?
=C3*A3
=C3*$A$3
=C3*A$3$
=$C$3*$A$3
When you don't want the celle reference in a formula to change when you replicate it, you have to use ...
Relative referencing
Absolute referencing
Adding the $ symbol in front of the row or column part of the cell reference will ...
make sure that it doesn't change when we replicate the formula
make sure that the calculation is displayed correctly
change the data type to currency
create a formula
