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.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026