← All Microsoft Excel Flashcard Decks

Data Visualization with 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 Data Visualization with Charts flashcards as text
  1. What chart type is best for showing trends over continuous time?

    Answer: Line chart

    Line charts connect data points across time intervals to show trends.

  2. When should you use a treemap instead of a pie chart?

    Answer: Hierarchical data with many categories

    Treemaps use nested rectangles to show hierarchy and proportion with many categories.

  3. What does the 'Gap Width' setting control in bar/column charts?

    Answer: Space between bars or columns

    Gap Width controls spacing between bars, expressed as a percentage of bar width.

  4. What is a box and whisker chart used for?

    Answer: Statistical distribution showing median, quartiles, and outliers

    Box plots display five-number summaries: min, Q1, median, Q3, max, plus outliers.

  5. How do you create in-cell data bars?

    Answer: Home > Conditional Formatting > Data Bars

    Data Bars are a conditional formatting option that adds proportional bars inside cells.

  6. What visualization shows distribution of a single continuous variable?

    Answer: Histogram

    Histograms group continuous data into bins and show frequency as bar height.

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