Excel Pivot Table Quiz

What is the recommended format for data before creating a pivot table in Excel?

• Graphical format

• Linear format

• Tabular format

• Circular format

What is the first step to insert a pivot table in Excel?

• Click on 'Data'

• Click on 'Home'

• Click on 'File'

• Click on 'Insert'

Which area do you drag a field to if you want to calculate the total revenue in a pivot table?

• Rows

• Columns

• Filters

• Values

How can you change the summary method of a field in a pivot table?

• By changing the worksheet

• By dragging the field to 'Rows'

• By right-clicking and selecting 'Summarize Values By'

• By clicking 'Insert'

What is the purpose of using filters in a pivot table?

• To change the color of the table

• To sort data alphabetically

• To view specific subsets of data

• To add new data

How can you view the percentage of total revenue for each salesperson in a pivot table?

• By inserting a new pivot table

• By changing the data source

• By adding a new worksheet

• By using 'Show Values As' and selecting 'Percent of Column Total'

What feature allows you to visualize pivot table data as a chart?

• Insert a filter

• Insert a table

• Insert a chart

• Insert a slicer

What is the function of a slicer in a pivot chart?

• To filter data visually

• To add new data

• To change the chart type

• To delete data

What must you do to update a pivot table when new data is added?

• Change the chart type

• Delete the old data

• Click 'Refresh' in the Pivot Table Analyze tab

• Recreate the pivot table

Which tab allows you to adjust the look and feel of a pivot table?

• Data

• Home

• Insert

• Design