Skip to content

Graded Quiz: Updating Advanced Charts :Data Visualization and Dashboards with Excel and Cognos (IBM Data Analyst Professional Certificate) Answers 2025

1. Question 1

What do treemaps use to represent hierarchical data categories?

  • ❌ Treemaps use data points on a line.

  • Treemaps use color, size, and closeness of shapes.

  • ❌ Treemaps use interconnected circles.

  • ❌ Treemaps use different shapes.

Explanation:
Treemaps visualize hierarchy using nested rectangles whose size and color reflect data values.


2. Question 2

Histograms can look like bar charts—what’s the key difference?

  • ❌ Bar charts use horizontal bars.

  • ❌ Histograms use bins. (true but incomplete)

  • ❌ Histograms use Axis Options to change bin sizes.

  • Bar charts compare data, and histograms show the distribution of data.

Explanation:
A histogram displays frequency distribution across bins, while bar charts compare categories.


3. Question 3

What kind of data works best with filled map charts?

  • ❌ Raw data

  • Data containing geographical regions

  • ❌ Scientific data

  • ❌ Complicated data

Explanation:
A filled map chart requires location-based data (states, countries, regions, ZIP codes).


4. Question 4

What are sparklines typically used for?

  • ❌ To contrast numerical values

  • ❌ To highlight a data range

  • To show data trends

  • ❌ To show regional information

Explanation:
Sparklines are mini-charts inside a cell that show trends over time at a glance.


🧾 Summary Table

Q# Correct Answer Key Concept
1 Color, size, closeness of shapes Treemaps show hierarchy
2 Bar = compare categories; Histogram = distribution Difference between histogram & bar chart
3 Data with geographic regions Filled map chart requirement
4 Show data trends Sparkline purpose