Font size
S
M
L
XL
WorksheetsY6 - Data - Introduction to Spreadsheets
Total questions: 12
Worksheet time: 6mins
Name
Class
Date
1.
Name
4 lines
2.
1. Which of these statements are true about spreadsheets? (Tick two)
a)
Calculations can be used on any data type (i.e. text, numbers) in a spreadsheet
b)
Data can be calculated using different operations within the spreadsheet
c)
Charts can be produced using the data held in spreadsheets
3.
2. Here is an example section of a spreadsheet. How much does 1 Kiwi cost?
a)
A: £3
b)
B: £9.50
c)
C: £0.80
d)
D: £2.40
4.
3. Using the spreadsheet in the previous question, which of the following is the correct cell reference for the subtotal of grapefruit?
a)
D5
b)
A5
c)
£1.00
5.
4. Using the same spreadsheet, which formula is the correct formula to calculate the subtotal for bananas?
a)
=B3xC3
b)
=B3*C3
c)
=C3*D3
6.
5. What does this operator mean in a spreadsheet / ?
a)
Divide
b)
Multiply
c)
Add
d)
Subtract
7.
6. Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)
a)
Cost
b)
£4.62
c)
Apples
d)
Item
8.
7. Which number format has been applied to this piece of data?
12:05:00
a)
Italics
b)
Duration
c)
Currency
9.
8. What does this SUM function calculate?
=SUM(A1:A4)
a)
The total of A1, A2, A3 and A4
b)
The total of A1 and A4
c)
A data heading
10.
9. The Subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to change the value shown in D2?
a)
A2
b)
B2
c)
D1
11.
10. Some children want to show the headteacher how much cheaper the school heating bill is if the doors are left closed at playtime. Should they show their data in a spreadsheet table or a graph?
a)
Spreadsheet table
b)
Graph / Chart
12.
11. Explain why you think this is the best way for the children to present their data to the headteacher.
4 lines
Reset
