Excel: Charting Data Flashcards

Which tab appears on the Ribbon only when a chart is selected?

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.

A Waterfall chart is most commonly used to visualize:

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.

To link a chart title directly to a cell value so it updates automatically, you should:

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.

Which chart element visually connects the data marker to its data label when the label is positioned away from the marker?

Answer: Leader line

Leader lines are thin lines that connect displaced data labels back to their corresponding data markers for clarity.

What is the effect of setting the 'Gap Width' to 0% on a Column chart?

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.

Which of the following chart types CANNOT display negative values meaningfully?

Answer: Pie chart

A Pie chart represents parts of a whole using slice angles, and negative values have no logical representation in this format.

When you apply a 'Quick Layout' from the Chart Design tab, what does it change?

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.