DAC Data Tools and Visualization 3

Question 1

What does a boxplot primarily communicate about a dataset?

Accepted Answer

Distribution, median, and outliers

Answer

Geographic location

Answer

Time-series trend

Answer

Categorical proportions

Question 2

In Excel, which feature creates an interactive summary table that can be quickly re-arranged by dragging fields?

Accepted Answer

PivotTable

Answer

VLOOKUP

Answer

Conditional formatting

Answer

Data validation

Question 3

Which Python library is most commonly used for statistical data visualization built on top of matplotlib?

Accepted Answer

Seaborn

Answer

NumPy

Answer

Requests

Answer

Flask

Question 4

A stacked bar chart is best used to show what?

Accepted Answer

Composition of a total across categories

Answer

Precise part-to-whole comparisons across many segments

Answer

Correlation between variables

Answer

Exact geographic distance

Question 5

In dashboard design, what does the term 'data-ink ratio' encourage?

Accepted Answer

Removing non-essential visual clutter

Answer

Maximizing decorative elements

Answer

Adding more colors

Answer

Using 3D effects

Answer

Increasing font sizes

Question 6

Which visualization best shows how a value flows and splits between stages or categories?

Accepted Answer

Sankey diagram

Answer

Pie chart

Answer

Line chart

Answer

Histogram

Question 7

In Power BI, what is the purpose of a slicer?

Accepted Answer

To provide an on-canvas visual filter for viewers

Answer

To join tables

Answer

To create measures

Answer

To publish reports