NEW
Font size
S
M
L
XL
Worksheets8th Excel charts1
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
Identify this chart.
a)
Pie
b)
Line
c)
Bar
d)
Column
2.
Identify this chart.
a)
Line
b)
Bar
c)
Column
d)
Pie
3.
Identify this chart.
a)
Column
b)
Bar
c)
Line
d)
Pie
4.
Tells you what each part of the chart represents.
a)
Legend
b)
Vertical axis
c)
Horizontal axis
d)
Chart title
5.
According to this chart, which type of pork do people prefer most?
a)
Bacon
b)
Ribs
c)
Ham
d)
Other
6.
This describes what is charted. It can be placed above or below the chart.
a)
Chart title
b)
chart area
c)
bar chart
d)
pie chart
7.
Once you have created a chart you cannot add another data series.
a)
True
b)
False
8.
A chart can be moved to a separate sheet.
a)
True
b)
False
9.
When charts are pasted into a word file, they are no longer linked to the excel chart.
a)
True
b)
False
c)
It depends how the chart is pasted.
10.
Part of a pie chart that represents one value from the series.
a)
axis
b)
data
c)
slice
d)
chart
11.
John wants to identify the exact value that each column in his chart represents. Which option should he choose?
a)
Gridelines
b)
Arrows
c)
Pictures
d)
Labels
12.
What ribbon contains the commands used to create a chart in Excel?
a)
Home Ribbon
b)
Insert Ribbon
c)
Formulas Ribbon
d)
Data Ribbon
13.
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
a)
Style
b)
Design
c)
Format
d)
Layout
14.
What is typically included in the range of data selected to create a chart?
a)
Titles only
b)
Numeric data and totals only
c)
Numeric data, totals, and titles
d)
Numeric data and titles
15.
On our X and Y axis we must always
a)
insert axis titles
b)
leave these blank
c)
fill them in with numbers
d)
remove them
Reset
