Microsoft Excel 2021365 - Beginner to Advanced - Show Values As and Summarize Values By

The video tutorial covers the use of 'Show Values As' and 'Summarise Values By' options in Excel pivot tables. It demonstrates how to display data as percentages, running totals, and other formats. The tutorial also explores advanced data summarization techniques, including using multiple fields and applying number formatting. Practical examples illustrate how to count, sum, and average data, providing a comprehensive guide to effectively using Excel's pivot table features.

What can you do with the 'Show Values As' option in a pivot table?

• Change the color of the pivot table

• Remove columns from the pivot table

• Display values as a percentage of the grand total

• Add new data to the pivot table

How can collapsible and expandable menus help in analyzing pivot table data?

• They delete unnecessary data from the table

• They change the data format to currency

• They automatically calculate the average of the data

• They allow you to hide or show details for better data analysis

What does the 'Running Total' option do in a pivot table?

• It adds the previous total to the current total

• It subtracts the current total from the previous total

• It multiplies the current total by the previous total

• It divides the current total by the previous total

What does Excel do when you drag a field to the values area?

• It deletes the field from the table

• It automatically selects a summary method like sum or count

• It changes the field to a text format

• It duplicates the field in the table

How can you display both the count and sum of a product in a pivot table?

• By using the 'Insert' menu

• By dragging the same field into the values area multiple times

• By changing the table layout

• By deleting other fields

What should you do if the number formatting resets in a pivot table?

• Restart Excel

• Change the data source

• Delete the pivot table

• Reapply the number formatting manually

How can you see the average of sales across different countries in a pivot table?

• By using the 'Data' menu

• By changing the pivot table to a chart

• By removing all other fields

• By dragging the sales field into the values area and selecting 'Average'