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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

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.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the process of applying a top five filter by sum of sales in the pivot table.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the final name given to the pivot table and how is it set?

Evaluate responses using AI:

OFF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?