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

Question 1

What do treemaps use to represent hierarchical data categories?

❌ Treemaps use interconnected circles.
✅ Treemaps use color, size, and closeness of shapes.
❌ Treemaps use different shapes.
❌ Treemaps use data points on a line.

Explanation:
Treemaps visualize hierarchical data by using rectangles whose size and color represent values, and their placement shows hierarchy and relationships.

Question 2

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

❌ Bar charts use horizontal bars.
❌ Histograms use bins.
✅ Bar charts compare data and histograms display the distribution of data.
❌ Histograms use Axis Options to display different bin sizes.

Explanation:
Bar charts compare categories, while histograms show the distribution of numerical data across ranges (bins).

Question 3

What kind of data works best with filled map charts?

❌ Complicated data
❌ Raw data
✅ Data containing geographical regions
❌ Scientific data

Explanation:
Filled map charts are ideal for geographic data (countries, states, regions) to show values by location.

Question 4

What are sparklines typically used for?

✅ To show data trends.
❌ To show regional information.
❌ To contrast numerical values.
❌ To highlight a data range.

Explanation:
Sparklines are small, in-cell charts used to quickly show trends over time.

🧾 Summary Table