Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - working with PivotTables

This video tutorial guides viewers through creating and customizing a pivot table in Excel. It begins with setting up the pivot table using a clean data set, followed by adding categories, towns, and sales data. The tutorial covers renaming labels, turning off Grand Totals, applying currency formatting, and filtering the top five sales items. Finally, it demonstrates naming the pivot table for clarity.

What is the first step in creating a pivot table from the Store_sales data?

• Add a new worksheet

• Rename the Excel table

• Summarize with Pivot Table

• Apply currency formatting

Which fields should be added to the pivot table columns, rows, and values respectively?

• Category, Sales, Town

• Sales, Town, Category

• Town, Category, Sales

• Category, Town, Sales

How can you turn off Grand Totals in a pivot table?

• By selecting the data range

• Using the filter option

• Through the Pivot Table design ribbon

• By renaming the labels

What formatting should be applied to the pivot table values?

• General with 1 decimal place

• Currency with 0 decimal places

• Text format

• Percentage with 2 decimal places

What is the purpose of applying a top five filter by sum of sales?

• To reduce data for better chart visualization

• To display the lowest selling categories

• To rename the pivot table

• To add more data to the pivot table