WhatsApp
Skip to content
10.30.6
-
1.
How do you handle duplicate entries or incorrect data in a pivot table?
-
2.
How can you display data as percentages of row, column, or grand total?
-
3.
How do you hide or show subtotals and grand totals in pivot tables?
-
4.
How can you prevent pivot tables from showing blank or zero values?
-
5.
What is the difference between refreshing a single pivot table and all pivot tables in a workbook?
-
6.
How can you refresh a pivot table after updating source data?
-
7.
How do timelines work in pivot tables?
-
8.
What are slicers, and how do they improve pivot table interactivity?
-
9.
How can you filter pivot table data using labels or values?
-
10.
How can you sort data within a pivot table?
-
11.
How can calculated items differ from calculated fields?
-
12.
How do you create a calculated field in a pivot table?
-
13.
What is a calculated field in a pivot table?
-
14.
How do you group dates in a pivot table (by month, quarter, year)?
-
15.
How do you group numeric data in a pivot table?
-
16.
How can you change the summary function (SUM, COUNT, AVERAGE) in a pivot table?
-
17.
How do you add fields to the Rows, Columns, Values, and Filters areas?
-
18.
What is the difference between a pivot table and a regular table?
-
19.
How do you create a pivot table from a dataset?
-
20.
What is a pivot table in Excel, and why is it used?