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