Font size
Worksheets7.5 Spreadsheets End of Unit
Total questions: 25
Worksheet time: 16mins
What is a spreadsheet?
An application used to store, organise and analyse data
An application used to create presentations
An application used to write text documents
An application used to create computer games
What is the cell reference for this cell?
A4
4B
B2
B4
What is the cell reference for this cell?
B5
A5
A1:A5
5A
What is the cell reference for this cell?
2C
D2
C2
B2
What is the cell reference for these cells?
3A:3D
A3+B3+C3+D3
A3
A3:D3
What will you find in cell C6?
17
37
46
38
What will you find in cell A4?
China
Great Britain
Russia
26
What cell reference has the number of gold medals that Great Britain won?
B3
A3
C3
D4
Pick 3 options for formatting a spreadsheet:
Cell colour
Borders
Cell size
Formulas and Functions
Which is the correct formula to add these 2 cells together?
=B2+C2
58
=25+33
B2+C2
Which is the correct formula to multiply these 2 cells together?
=B2+C2
=B2/C2
=B2-C2
=B2*C2
Which is the correct formula to divide these 2 cells together?
=B2+C2
=B2/C2
=B2-C2
=B2*C2
Which is the correct formula to subtract these 2 cells?
=B2+C2
=B2/C2
=B2-C2
=B2*C2
Write the formula that will provide the correct value in cell E3:
(a)
Write the formula that will provide the correct value in cell E4:
(a)
Write the function that will add the answers together and provide the correct value in cell E8:
(a)
Write the function that will find the largest value from the answers and provide the correct value in cell E9:
(a)
Write the function that will find the smallest value from the answers and provide the correct value in cell E10:
(a)
Write the function that will find the average of the answers and provide the correct value in cell E11:
(a)
What result will the function =COUNTBLANK(B3:F6) return?
6
8
4
10
If you want to count all the cells between A1 and A10 that contain a value above 5, which would be the correct function?
=COUNTIF(A1:A10,"<=5")
=COUNTBLANK(A1:A10)
=COUNTA(A1:A10)
=COUNTIF(A1:A10,">5")
What kind of chart is this?
Bar Chart
Pie Chart
Line Graph
Histogram
Which is a benefit of a bar chart?
Each segment represents a fraction of the whole
Plots data over time
Quick and easy to compare values
Which is a benefit of a line graph?
Each segment represents a fraction of the whole
Plots data over time
Quick and easy to compare values by height
Which is a benefit of a pie chart?
Each segment displays a fraction of the whole
Plots data over time
Can handle large amounts of data
