NEW
Font size
WorksheetsSPREADSHEET-GRAPHS AND CHARTS
Total questions: 35
Worksheet time: 34mins
When you open a Google Sheet the file is called a
Document
Slideshow
Spreadsheet
Publication
A ________________is a visual representation of data.
table
chart
border
spreadsheet
To delete a chart, click once on the chart to select it and then ____________.
click the X in the top window
press the delete key on the keyboard
click and drag the chart off the spreadsheet
press the X key on the keyboard
In most charts, each data series is assigned a color or pattern to uniquely identify it. Which type of chart assigns a color to each data point instead of series?
pie
area
column
scatter
Which of the following charts uses horizontal bars to display data?
Pie
Bar
Column
Scatter
Which programs are used to calculate spreadsheets?
Microsoft publisher & Google templates
Microsoft excel & Google sheets
Microsoft powerpoint & Google slides
Microsoft word & Office 365
What symbol does a formula have to start with in order for it to work?
#
$
=
@
Which is NOT a type of chart?
pie
column
bar
axis
What is the first thing you have to do in a spreadsheet before you can create a chart/graph?
click insert charts/graphs
go to file, print
highlight the data with your mouse
bold all the information
Which chart would you use to show trends or changes over time?
stacked bar chart
pie chart
bar chart
line chart
A pie chart is used to do what?
show trends over time
represent only one series of data
show the correlation of two or more sets of data
show how many pieces you can eat
Which is Graph and Chart Icon in Spreadsheet?
This is an example of ______________.
pie chart
bar graph
diagram
This is an example of ____________.
line graph
diagram
table
This is an example of _____________________.
pie chart
diagram
table
This is an example of ________________.
pie chart
table
diagram
This is an example of a _________________________ .
line graph
bar chart
pie chart
This is a __________________________ trend.
modest increase
downward trend
upward trend
The sales have ___________________________.
slightly increased
rocketed
fall drastically
This is an example of _____________________.
a bar chart
a table
a line graph
Charts and graphs are __________________________ representations of data.
graphical
simple
inaccurate
This is an example of _________________________.
line graph
bar chart
pie chart
What is name of the chart pictured below?
Pictograph
Pie Chart
Tally Chart
Line Plot
Which are components of a graph?
Y & X axis
Data markers & data series
Plot area & tick mark
Gridline
All of the Above
What percentage of respondents say that plain whole milk is their favorite?
5.2
9
14
27
Which city has the lowest average temperature in March?
Tokyo
New York
Berlin
London
Which day of the week has the most traffic accidents for New York City?
Tuesday
Thursday
Saturday
Sunday
Which day of the week has roughly 125 accidents on average?
Tuesday
Wednesday
Thursday
Friday
Look at the bar graph. Can you tell what the bar graph measures?
Kilowatts used by appliances per day
Average Hours appliances were used per day
Number of hours each appliance was used per day
Hours appliance used monthly
What percentage does a whole pie chart represent?
360%
90%
50%
100%
