WorksheetsSpreadsheet Graphs
Total questions: 32
Worksheet time: 32mins
To combine adjacent cells into one large cell and center the data is called ____.
chart
merge and center
cell reference
A mathematical operation in a spreadsheet is called a _____.
formula
range
label
graph
Which of the following is an example of an addition formula?
=B4+D7
=2+3+6=11
=F3*G7
=B9/B6
Which of the following is an example of a multiplication formula?
=L3 * C7
=B2 + B3/ C4
=B4 x B6
=46 x 39
Which of the following is an example of division formula?
=A1-B2
=£14.00 - £5.00=£9.00
=B9/B6
=C11 - B11
Which image below would you select to merge and center?
Identify the type of graph represented in the picture.
Pie
Scatter
Line
Column
What type of graph is this?
Step graph
Line graph
column graph
picture graph
What is the title of this column graph?
Wildlife
Orange and Blue
Dolphin Whales
Wildlife Population
What was the recorded population of dolphins in 2018?
60
78
110
65
What was the population of whales in 2019?
100
10
99
32
In what year was the highest population of whales recorded?
2017
2022
2019
2020
2021
In what year was the lowest population of whales recorded?
2017
2020
2019
2022
2018
In what year was the highest population of dolphins recorded?
2019
2020
2022
2017
In what year was the lowest population of dolphins recorded?
2022
2021
2020
2019
2018
Which type of graph is shown?
Column graph
horizontal bar graph
pie chart
pictograph
Every graph must have a
Pet
Candy bar
Title
Chromebook
How many total people took the survey?
50
150
100
200
What is the dependent variable on the graph (y-axis)?
Metro Bicycle Shop Weekly Sales
Bicycles Sold
Types of Bicycles
What is the independent variable on the graph (x-axis)?
Metro Bicycle Shop Weekly Sales
Bicycles Sold
Types of Bicycles
