Pivot Table

Question 1

Task: Create a One-Dimensional Pivot Table

Answer 1

📘 Description: Summarizes data by one field.
🧮 Example: Total Sales by Region.

Question 2

Task: Create a Two-Dimensional Pivot Table

Answer 2

📘 Description: Summarizes data by two fields.
🧮 Example: Total Sales by Region and Product.

Question 3

Task: Create a Frequency Distribution

Answer 3

📘 Description: Counts how often values occur in categories.
🧮 Example: Number of orders in different price ranges.

Question 4

Task: Create a Pivot Chart

Answer 4

📘 Description: Visual chart linked to a Pivot Table.
🧮 Example: Bar chart showing total sales per region.