MOS Excel: Charting Data 5 — Questions and Answers
Question 1: Which tab appears on the Ribbon only when a chart is selected?
- Chart Design and Format (contextual tabs) (Correct answer)
- Data tab
- Review tab
- Developer tab
Correct answer: Chart Design and Format (contextual tabs)
Excel shows the contextual 'Chart Design' and 'Format' tabs under 'Chart Tools' only when a chart object or chart sheet is active.
Question 2: A Waterfall chart is most commonly used to visualize:
- Cumulative effect of sequential positive and negative values (Correct answer)
- Distribution of a dataset across equal intervals
- Relationship between two continuous numeric variables
- Comparison of values across discrete geographic regions
Correct answer: Cumulative effect of sequential positive and negative values
Waterfall charts show how an initial value increases or decreases through a series of intermediate steps to reach a final total.
Question 3: To link a chart title directly to a cell value so it updates automatically, you should:
- Select the chart title, type = in the formula bar, then click the source cell (Correct answer)
- Type the cell reference directly into the chart title text box
- Use the Define Name feature to name the title range
- Right-click the title and choose 'Link to Cell'
Correct answer: Select the chart title, type = in the formula bar, then click the source cell
After selecting the chart title, typing = in the formula bar and clicking a cell creates a live reference that keeps the title synchronized with that cell.
Question 4: Which chart element visually connects the data marker to its data label when the label is positioned away from the marker?
- Leader line (Correct answer)
- Drop line
- High-low line
- Series line
Correct answer: Leader line
Leader lines are thin lines that connect displaced data labels back to their corresponding data markers for clarity.
Question 5: What is the effect of setting the 'Gap Width' to 0% on a Column chart?
- The columns touch each other with no space between them (Correct answer)
- The columns are hidden and only the axis remains visible
- Each column expands to double its normal width
- The chart switches to a Histogram layout automatically
Correct answer: The columns touch each other with no space between them
Gap Width controls the space between column clusters; 0% removes all spacing so adjacent columns are flush against one another.
Question 6: Which of the following chart types CANNOT display negative values meaningfully?
- Pie chart (Correct answer)
- Bar chart
- Column chart
- Line chart
Correct answer: Pie chart
A Pie chart represents parts of a whole using slice angles, and negative values have no logical representation in this format.
Question 7: When you apply a 'Quick Layout' from the Chart Design tab, what does it change?
- The arrangement of chart elements such as titles, legends, and data labels (Correct answer)
- The color scheme and font used throughout the chart
- The chart type while keeping the same data source
- The size and position of the chart on the worksheet
Correct answer: The arrangement of chart elements such as titles, legends, and data labels
Quick Layouts are predefined arrangements that add, remove, or reposition chart elements like axes, titles, and legends in one click.
MOS Excel: Charting Data 5
Which tab appears on the Ribbon only when a chart is selected?