Graded Quiz :Excel Basics for Data Analysis (IBM Business Analyst Professional Certificate) Answers 2025

Question 1

What should you remove before making a Pivot Table?

✅ Blank rows, columns, and cells
❌ Row labels, columns, data fields
❌ Value fields and row labels
❌ Date fields, value fields, and cells

Explanation:
Pivot Tables work best with clean, continuous data. Blank rows or columns can break ranges and cause incorrect results.

Question 2

What is automatically added after formatting data as a table?

✅ Filter drop-downs at the top of columns
❌ Alternate light/dark rows at the bottom
❌ Data bars presented at the top
❌ Column headers at the top of columns

Explanation:
When you format data as a table, Excel automatically adds filter drop-downs to each column header.

Question 3

After creating and selecting a Pivot Table, what pane appears on the right?

✅ The PivotTable Fields pane
❌ The PivotTable Metadata pane
❌ Additional pivot table examples
❌ The PivotTable Properties pane

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

Question 4

What do Timelines provide in Pivot Tables?

❌ Preview views of different filters
❌ Details of all actions during a period
❌ Set the pivot table to an earlier view
✅ Let you filter specifically on date-related data

Explanation:
Timelines are visual filters designed specifically for date fields (year, quarter, month).

Question 5

What is one way to remove a slicer or timeline?

❌ Remove all filters from the pivot table
❌ Create a new one
✅ Right-click it and select Cut
❌ Press CTRL+Z

Explanation:
You can remove a slicer or timeline by right-clicking and choosing Cut (or Delete).

🧾 Summary Table