DAC Data Tools and Visualization 3 — Questions and Answers
Question 1: What does a boxplot primarily communicate about a dataset?
- Distribution, median, and outliers (Correct answer)
- Geographic location
- Time-series trend
- Categorical proportions
Correct answer: Distribution, median, and outliers
A boxplot shows the median, quartiles, spread, and outliers of a distribution.
Question 2: In Excel, which feature creates an interactive summary table that can be quickly re-arranged by dragging fields?
- PivotTable (Correct answer)
- VLOOKUP
- Conditional formatting
- Data validation
Correct answer: PivotTable
A PivotTable summarizes and reorganizes data interactively by dragging fields.
Question 3: Which Python library is most commonly used for statistical data visualization built on top of matplotlib?
- Seaborn (Correct answer)
- NumPy
- Requests
- Flask
Correct answer: Seaborn
Seaborn builds on matplotlib to simplify statistical visualizations.
Question 4: A stacked bar chart is best used to show what?
- Precise part-to-whole comparisons across many segments
- Composition of a total across categories (Correct answer)
- Correlation between variables
- Exact geographic distance
Correct answer: Composition of a total across categories
Stacked bars show how a total is composed of subcategories across categories.
Question 5: In dashboard design, what does the term 'data-ink ratio' encourage?
- Maximizing decorative elements
- Removing non-essential visual clutter (Correct answer)
- Adding more colors
- Using 3D effects
- Increasing font sizes
Correct answer: Removing non-essential visual clutter
A high data-ink ratio means removing clutter so ink represents actual data.
Question 6: Which visualization best shows how a value flows and splits between stages or categories?
- Sankey diagram (Correct answer)
- Pie chart
- Line chart
- Histogram
Correct answer: Sankey diagram
A Sankey diagram uses proportional flows to show movement and splitting between stages.
Question 7: In Power BI, what is the purpose of a slicer?
- To provide an on-canvas visual filter for viewers (Correct answer)
- To join tables
- To create measures
- To publish reports
Correct answer: To provide an on-canvas visual filter for viewers
A slicer is an on-canvas control that lets viewers filter visuals interactively.
DAC Data Tools and Visualization 3
What does a boxplot primarily communicate about a dataset?