1. Question 1

Which statement best describes the main purpose of a digital dashboard?

• ❌ To display all your charts in one location.

• ❌ To provide a static data-findings report.

• ✅ To display the most important or relevant information in a single place.

• ❌ To analyse different types of data.

Explanation:
A dashboard highlights the most important insights at a glance, not everything or static reports.

---

2. Question 2

According to the video, what did subject matter experts advise when building dashboards?

• ❌ Bright colors highlight key points.

• ✅ Displaying too much information means your key points can get lost.

• ❌ Use many visualizations to define key points.

• ❌ Use numbers as much as possible.

Explanation:
Experts warn that overloading dashboards hides insights—simplicity is key.

---

3. Question 3

Which Excel feature lets you precisely control what data appears in a chart?

• ❌ Sorting

• ✅ Filters

• ❌ Pivot Tables

• ❌ Sparklines

Explanation:
Filters allow you to choose exactly which data appears in a visualization.

---

4. Question 4

Which tasks should be performed 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:
Before dashboard creation, ensure clean data: remove blanks and convert to an Excel Table for structure.

---

🧾 Summary Table

---