WorksheetsCharts & Graphs in Spreadsheet
Total questions: 20
Worksheet time: 10mins
This part of the chart is usually vertical and contains data.
Y axis
X axis
Legend
Chart title
This part of the chart is usually horizontal and contains categories.
X axis
Y axis
Legend
Chart title
If you want to select two columns that are NOT next to each other to create a chart, hold down the ____ key on your keyboard.
Ctrl (Control)
Alt (Alternate)
Shift
Fn (Function)
According to this chart, which type of pork do people prefer most?
Bacon
Ribs
Ham
Other
According to this chart, in which month are produce sales the highest?
June
March
November
May
According to this chart, which band sold the most albums?
Doug and the Slugs
Gails and the Snails
Sherm and the Worms
Marva and the Larva
__________ is a area that holds all the elements of a chart.
Plot Area
Chart Title
Chart Area
Legends
The lines that run across the plot area are known as _______
Sparklines
Slice
Cross lines
Gridlines
What type of chart is this?
Pie Chart
Bar Chart
Doughnut Chart
Scatter Chart
Can you change the appearance of a chart after it is created?
Yes
No
Which is the best chart for displaying scientific data?
Scatter Plot
Pie Chart
Area Chart
Doughnut Chart
Chart layout is
set of elements and the location of those elements
a visual representation of numeric data
the cells that contain values and labels to be graphed
a group of data points or values
