Have an account?
Skip to Content
Build your own quiz
Computers
9th -
12thgrade
Module 9 Excel Working with Charts Review
17 questions
Show Answers
See Preview
- 1. Multiple ChoiceAnother name for the vertical (or y) axis is the ____ axis.categorydatavaluetitle
- 2. Multiple ChoiceOnce you have decided on the chart type that best conveys your meaning, you might want to arrange your ____ so that the chart data illustrates the points you want to make.values and categoriesrows and columnsmarkers and legendsplots and series
- 3. Multiple Choice
The Switch Row/Column button is in the ____ group on the Chart Tools Design tab.
Chart
Data
Tools
Number
- 4. Multiple ChoiceA chart is a visual representation of worksheet data.truefalse
- 5. Multiple Choice
To format an object, you first must select it.
true
false
- 6. Multiple ChoiceA chart style is a predefined set of chart colors and fills.truefalse
- 7. Multiple ChoiceA(n) ____________________ is a sequence of related numbers that shows a trend.sparklinedata serieslegendclustered column
- 8. Multiple ChoiceA(n) ____________________ chart is an effective tool for comparing the relative value of parts to a whole.piecolumnbarsparkline
- 9. Multiple Choice
A data marker represents one value in a data series.
True
False
- 10. Multiple Choice
____ are vertical and horizontal lines in a chart that help to identify the value for each data series.
Data lines
Data markers
Gridlines
Grid markers
- 11. Multiple Choice
The Move Chart button is in the ____ group on the Chart Tools Design tab.
Location
Move
Copy/Move
Copy/Paste
- 12. Multiple Choice
You can move the legend of a chart to a new location using the Chart Elements menu.
True
False
- 13. Multiple Choice
Tiny charts that fit into one cell and show a trend are known as ____.
mini charts
micro charts
sparklines
scatterlines
- 14. Multiple Choice
The chart area includes the entire chart and all the chart elements.
True
False
- 15. Multiple Choice
The horizontal axis is also known as the y-axis.
True
False
- 16. Multiple Choice
The ________ identifies what each data series represents
legend
data marker
data tile
gridline
- 17. Multiple Choice
If data labels on a chart are too small to read you can increase their ____ size before printing the chart.
text
font
letter
form
- Answer choicesTagsAnswer choicesTags