
Excel Charts Worksheet
Authored by Carmen Fife
Business
10th Grade
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main benefit of using charts in Excel?
To store data more securely
To visually illustrate comparisons or trends in the data
To limit the amount of data visible
To make cell formatting more complex
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these is not a common Excel chart type mentioned in the GCFGlobal lesson?
Column chart
Pie chart
Radar chart
Line chart
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to change which data is shown on the horizontal (category) axis versus the vertical axis, which command do you use?
Switch Row/Column
Change Chart Type
Add Chart Element
Move Chart
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To keep a chart automatically updated when new rows of data are added (below the current range), you should first:
Format the data as a table
Change the chart type to “area”
Use the “Move Chart” command
Insert more chart elements
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type is best for showing the parts of a whole (percentages)?
Line chart
Column chart
Pie chart
Bar chart
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
6. The ________________ is the label that describes what the chart is showing.
chart title
legend
axis label
data series
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The ________________ displays which data sets each color or marker in the chart represents.
legend
axis
gridline
title
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?