Font size
WorksheetsTopic 1 (HW 2): Spreadsheets
Total questions: 15
Worksheet time: 9mins
A (a) is used to represent data visually in a spreadsheet?
Select all examples of graphs in a spreadsheet
Pie Chart
Bar Chart
Line Chart
Wood Chart
This is an example of a ______
Bar Chart
Pie Chart
Scatter Chart
Line Chart
This is an example of a ______
Bar Chart
Pie Chart
Scatter Chart
Line Chart
This is an example of a bar chart
True
False
Select the correct axis for this graph
X Axis: Years
Y Axis: Population Number
X Axis: Population Number
Y Axis: Years
The Y axis of a graph is vertical (up/down)
True
False
What feature is missing from this graph?
Title
X Axis
Y Axis
Data
It is not possible to change the height or width of a cell in a spreadsheet
True
False
Type in the correct cell reference for the yellow cell
(a)
The / symbol is used to represent ______ in a spreadsheet formula
Addition
Subtraction
Division
Multiplication
Select the correct formula to display the total of the values in these cells
=sum(B3:D4)
=sum(3B:4D)
=count(B3:D4)
=count(3B:4D)
Select the correct formula to display how many cells contain data in the range from B3 to D6
=count(B3:D6)
=countA(B3:D6)
Select the correct formula to display how many cells contain number data in the range from B3 to D6
=count(B3:D6)
=countA(B3:D6)
Which spreadsheet feature has been used here?
Auto-Fill
Sum
Count
