MOS Excel: Charting Data 2 — Questions and Answers
Question 1: Which chart type is most appropriate for showing how individual parts contribute to a total across multiple categories?
- 100% Stacked Bar chart (Correct answer)
- Scatter chart
- Line chart
- Bubble chart
Correct answer: 100% Stacked Bar chart
A 100% Stacked Bar chart normalizes each bar to 100%, making it easy to compare proportional contributions across categories.
Question 2: What happens when you click 'Switch Row/Column' in the Chart Design tab?
- Excel transposes the chart's data series and category axes (Correct answer)
- Excel deletes the chart and recreates it from scratch
- Excel changes the chart type to a different style
- Excel swaps the chart's title and legend labels
Correct answer: Excel transposes the chart's data series and category axes
'Switch Row/Column' reassigns which dimension of your data table becomes the series versus the axis categories.
Question 3: A secondary axis is useful when a chart contains data series that:
- Have very different value scales (Correct answer)
- Use the same units but different colors
- Are in non-adjacent columns
- Contain blank cells
Correct answer: Have very different value scales
A secondary vertical axis lets you plot series with vastly different magnitudes (e.g., revenue in thousands and percentage rates) without one series appearing flat.
Question 4: In Excel, which keyboard shortcut inserts a chart on a new chart sheet using the default chart type?
- F11 (Correct answer)
- Alt+F1
- Ctrl+F1
- Ctrl+Shift+F11
Correct answer: F11
Pressing F11 creates an embedded chart on a dedicated chart sheet using Excel's default chart type.
Question 5: Which of the following correctly describes the 'Plot Area' of a chart?
- The rectangular region bounded by the axes where data is plotted (Correct answer)
- The entire chart including the title and legend
- The area containing the chart's axis labels
- The background color applied to the chart title
Correct answer: The rectangular region bounded by the axes where data is plotted
The plot area is the inner region bounded by the chart axes where the actual data markers, bars, or lines appear.
Question 6: To add a trendline to a chart, you must first:
- Select the data series in the chart (Correct answer)
- Select the entire chart area
- Click the chart title
- Open the Format Cells dialog
Correct answer: Select the data series in the chart
A trendline is added to a specific data series, so you must select that series before accessing the Add Trendline option.
Question 7: Which chart element do you format to change the interval between tick marks on the value axis?
- Format Axis pane — Axis Options (Correct answer)
- Format Data Series pane — Series Options
- Format Chart Area pane — Fill
- Format Legend pane — Legend Options
Correct answer: Format Axis pane — Axis Options
The Format Axis pane's Axis Options section lets you set the major and minor unit intervals that control tick mark spacing.
MOS Excel: Charting Data 2
Which chart type is most appropriate for showing how individual parts contribute to a total across multiple categories?