1.
What is the primary function of a Pivot Table in Excel?
2.
What type of chart is best used to show percentage contributions of different categories?
3.
What is the purpose of using "Value Filters" in Pivot Tables?
4.
Which type of Pivot Table layout allows you to compare multiple categories across rows?
5.
How can you remove a slicer from a Pivot Table in Excel?
6.
In Excel, which feature is used to show trends over time?
7.
What can you use to analyze data by time intervals like months or years in a Pivot Table?
8.
Which Excel feature allows you to quickly apply filters to your data?
9.
In Excel, what is the first step to create a Pivot Table?
10.
To analyze the top performing products in Excel, which filter would you apply?