1. Question 1

What is a capability of line charts?

• ❌ Compare similar, unrelated datasets

• ❌ Compare the frequency of datasets

• ✅ Compare different, but related datasets

• ❌ Compare different, unrelated datasets

Explanation:
Line charts show trends over time between related data series.

---

2. Question 2

Each piece of a pie chart represents part of a whole. What must the total equal?

• ❌ 50%

• ❌ 75%

• ✅ 100%

• ❌ 99%

Explanation:
A pie chart represents percentages that always sum to 100%.

---

3. Question 3

According to the “Introduction to Charts” video, which chart is one of the most commonly used?

• ❌ Scatter chart

• ✅ Bar chart

• ❌ Funnel chart

• ❌ Bubble chart

Explanation:
Bar charts are universally used for comparing categories.

---

4. Question 4

In the “Expert Viewpoints” video, which two software programs were mentioned?

• ❌ Db2 and SQL

• ❌ Google and Bing

• ❌ Google Docs and Word

• ✅ PowerPoint and Excel

Explanation:
Experts mentioned using Excel for analysis and PowerPoint to highlight insights.

---

5. Question 5

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

• ✅ Pie chart

• ❌ Bar chart

• ❌ Funnel chart

• ❌ Line chart

Explanation:
A pie chart shows how much each model contributes to the total.

---

6. Question 6

How does a pivot chart differ from a standard chart?

• ❌ Contains data series/categories/axes (both do)

• ❌ Cannot be line/pie/bar (it can)

• ❌ Always arranged in columns/rows

• ✅ A pivot chart uses data from a pivot table

Explanation:
Pivot charts dynamically reflect the structure of their pivot table source.

---

7. Question 7

Main difference between Area and Column charts?

• ❌ Area chart makes sense of complicated data; column shows axes

• ❌ Column uses data points, area uses vertical bars

• ❌ Area uses horizontal bars, column uses rows

• ✅ A column chart uses vertical bars, and an area chart uses data points (with filled areas)

Explanation:

• Column chart: vertical bars

• Area chart: line chart style with areas filled below the line

---

🧾 Summary Table

---