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

Question 1

What best describes the main purpose of a digital dashboard?

❌ To display all your charts in one location.
❌ To provide a static data-findings report of your business data.
✅ To display the most important or relevant information in a single place.
❌ To analyse different types of data.

Explanation:
A digital dashboard is designed to show key metrics and insights at a glance, helping users make quick, informed decisions.

Question 2

What did subject matter experts advise when building dashboards?

❌ Use numbers as much as possible to help focus users.
❌ Bright colors highlight key points.
❌ Having as many visualizations as possible helps define key points.
✅ Displaying too much information means your key points can get lost.

Explanation:
Experts emphasize simplicity and focus—too much information reduces clarity and impact.

Question 3

Which Excel feature lets you precisely control what information is shown in a chart?

❌ Sorting
✅ Filters
❌ Pivot Tables
❌ Sparklines

Explanation:
Filters allow you to include or exclude specific data, directly controlling what appears in a visualization.

Question 4

Which tasks should you perform before creating a dashboard? (Select all that apply)

✅ Format the data as a table first
✅ Remove blank data rows
❌ Format the data as a CSV file first
❌ Create visualizations

Explanation:
Clean, structured data (tables with no blanks) is essential before building dashboards. Visualizations come afterward.

🧾 Summary Table