Font size
WorksheetsIntroduction to spreadsheets
Total questions: 9
Worksheet time: 5mins
Which of these statements are true about spreadsheets? (Tick all that apply)
When using formulas with cell references, changing one cell can change another
Calculations can be used on any data type in a spreadsheet
Data can be calculated using different operations within the spreadsheet
Charts can be produced using the data held in spreadsheets
Below is an example section of a spreadsheet. How much does one kiwi cost?
£3
£9.50
£0.80
£2.40
Which of the following is the correct cell reference for the subtotal of grapefruit?
D5
A5
£1.00
D1
Which formula is the correct formula to calculate the subtotal for bananas?
=B3xC3
=B3*C3
=C3*D3
=C3xD3
What does this operator mean in a spreadsheet / ?
Divide
Multiply
Add
Subtract
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)
Cost
£4.62
Apples
Item
Which number format has been applied to this piece of data?
12:05:00
Date
Italics
Duration
Currency
What does this SUM function calculate?
=SUM(A1:A4)
The total cost of items
The total of A1, A2, A3, and A4
The total of A1 and A4
A data heading
The subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to alter the value shown in D2?
A2
B2
£8.00
D1
