Creating and Managing Charts Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Creating and Managing Charts flashcards as text
Which chart type best shows composition of a whole at a single point in time?
Answer: Pie chart
Pie charts show how parts contribute to a whole using proportional slices.
How do you add a secondary axis to an Excel chart?
Answer: Right-click data series, Format Data Series, choose Secondary Axis
Right-click the data series, choose Format Data Series, and select Secondary Axis.
What is a sparkline in Excel?
Answer: A tiny chart within a single cell showing data trends
Sparklines are miniature charts that fit inside a single cell.
How do you create a dynamic chart title linked to a cell?
Answer: Click the title, click formula bar, type = and click the cell
Click the chart title, then use the formula bar to link it to a cell reference.
What is the purpose of error bars in charts?
Answer: Displaying variability or uncertainty of data points
Error bars represent variability, uncertainty, or margin of error in data.
Which chart shows the relationship between two numerical variables?
Answer: Scatter (XY) chart
Scatter charts plot data points using X and Y coordinates to reveal relationships.