Graded Quiz : Visualizing Data using Spreadsheets :Data Visualization and Dashboards with Excel and Cognos (IBM Business Analyst Professional Certificate) Answers 2025

Question 1

What is a capability of line charts?

❌ Compare the frequency of data sets
❌ Compare similar, unrelated data sets
✅ Compare different, but related data sets
❌ Compare different, unrelated data sets

Explanation:
Line charts are best for showing trends over time and comparing related datasets (e.g., sales of similar products over months).

Question 2

Each portion of a pie chart represents static values or categories. What is the sum equal to?

❌ 50%
✅ 100%
❌ 75%
❌ 99%

Explanation:
A pie chart always represents parts of a whole, and the total must equal 100%.

Question 3

Which chart is one of the most commonly used?

❌ Scatter chart
❌ Bubble chart
❌ Funnel chart
✅ Bar chart

Explanation:
Bar charts are among the most widely used charts because they are easy to read and compare values.

Question 4

Which two software programs were mentioned for highlighting important information?

✅ PowerPoint and Excel
❌ Db2 and SQL
❌ Google Docs and Word
❌ Google and Bing

Explanation:
The video highlighted Excel and PowerPoint as common tools for creating and presenting visual stories.

Question 5

Which chart shows the relative contribution of unit sales from Ford car models?

✅ Pie chart
❌ Bar chart
❌ Funnel chart
❌ Line chart

Explanation:
Pie charts are used to show proportions or contributions of categories to a whole.

Question 6

How does a pivot chart differ from a standard chart in Excel?

❌ Contains data series, categories, and axes
❌ Cannot be line, pie, or bar
✅ Uses data from a pivot table
❌ Always arranged in rows and columns

Explanation:
A pivot chart is directly linked to a Pivot Table and updates dynamically when the pivot table changes.

Question 7

What is the main difference between Area and Column charts?

❌ Column uses data points; area uses vertical bars
❌ Column uses data points; area uses vertical bars
❌ Area uses horizontal bars; column uses rows
✅ An area chart emphasizes trends and magnitude, while a column chart uses vertical bars to compare values

Explanation:

• Column charts compare values using vertical bars

• Area charts emphasize trends and the magnitude of change over time

🧾 Summary Table