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.