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
What is a combo chart in Excel?
Answer: Uses two or more chart types in a single chart
Combo charts combine different chart types like columns and lines in one chart.
How do you create a reusable chart template?
Answer: Right-click chart, Save as Template (.crtx file)
Right-click > Save as Template saves formatting as a .crtx file for reuse.
What does the 'Select Data Source' dialog control?
Answer: Adding, editing, removing data series and modifying axis labels
It manages which data series appear, their ranges, order, and axis labels.
How do trendlines help with data analysis?
Answer: They fit mathematical models and can project future values
Trendlines fit equations to data and can forecast forward or backward.
What is a waterfall chart used for?
Answer: Displaying how an initial value changes through sequential gains and losses
Waterfall charts show cumulative effects of positive and negative values on a starting amount.
How do you display data labels from a different cell range?
Answer: Select labels, click 'Value From Cells' in Label Options, specify range
Excel lets you use custom cell values as data labels via the 'Value From Cells' option.