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