1. Question 1

What should you remove before making a Pivot Table?

• ✅ Blank rows, columns, and cells

• ❌ Row labels, columns, data fields

• ❌ Date fields, value fields, and cells

• ❌ Value fields and row labels

Explanation:
PivotTables need clean, continuous data with no blank rows/columns that break the dataset.

---

2. Question 2

What is automatically added after formatting data as a table?

• ❌ Column headers at the top of columns

• ❌ Alternate light/dark rows at the bottom

• ❌ Data bars at the top

• ✅ Filter drop-downs at the top of columns

Explanation:
Excel Tables automatically add filter arrows to each column header.

---

3. Question 3

After creating a PivotTable and selecting it, what pane appears on the right?

• ❌ Additional pivot table examples

• ❌ PivotTable Metadata pane

• ❌ PivotTable Properties pane

• ✅ PivotTable Fields pane

Explanation:
The Fields pane lets you drag fields into Rows, Columns, Values, and Filters.

---

4. Question 4

What do Timelines provide in PivotTables?

• ❌ Show details of actions performed

• ❌ Preview views of different filters

• ❌ Set pivot table to an earlier view

• ✅ Let you filter specifically on date-related data

Explanation:
Timelines give a visual date filter (years, quarters, months, days).

---

5. Question 5

What is one way to remove a slicer or timeline?

• ❌ Remove all filters

• ❌ Create a new one

• ❌ Press CTRL+Z

• ✅ Right-click it and select Cut

Explanation:
Right-click → Cut removes the slicer/timeline from the worksheet.

---

🧾 Summary Table

---