
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - create and summarize a PivotTable
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first task mentioned in the video for working with advanced pivot tables?
Add a slicer
Export data to columns
Create a dynamic chart title
Create a pivot table from service desk data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Where should the pivot table be placed according to the instructions?
In the helper tab
In columns H and I
On the chart worksheet
On a new worksheet
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What should be turned off after summarizing the pivot table data?
Row labels
Data filters
Grand totals
Column headers
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of adding a slicer to the pivot table?
To add a new data column
To create a chart
To export data
To filter data by status
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How should the slicer layout be configured?
In multiple rows
With a visible header
All on one row
With a custom background
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why is data exported from the pivot table to columns H and I?
To format the pivot table
To delete unnecessary data
To add more data
To create a field map chart
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What type of chart is created using the exported data?
Pie chart
Field map chart
Bar chart
Line chart
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?