← All Microsoft Excel Flashcard Decks

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
  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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 , 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

  1. store.certiport.com — Fees, retake fee · verified Nov 2026
  2. certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
  3. learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026