NEW
Font size
WorksheetsPivot Tables
Total questions: 10
Worksheet time: 5mins
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
organizing
implementing
sorting
filtering
You can have more than 1 Field in each Area Box.
True
False
What is a Pivot Table?
A table containing data that is organized horizontally.
A table used to calculate financial pivot values.
A tool used to summarize data.
A table containing only black, grey and white formatting
Pivot Table fields are listed in the order of the original data source?
True
False
Which ribbon is visible when a PivotTable is selected, and allows a user to utilize several tools?
Layout
Options
Design
Pivot Table Analyze
What is the first step for creating a Pivot Table?
Clicking on the Insert Tab and inserting a Pivot Table.
Create or select data that needs to be analyzed.
Selecting your data and searching for recommended Pivot Tables
Which of the following is NOT a box in the PivotTable Fields List?
Column
Report Filter
Values
Formulas
A ____ is an interactive chart that displays visuals based on your PivotTable.
SlicerChart
PivotChart
TrendChart
2-D Column chart
What can you use to easily filter pivot tables interactively with buttons in a worksheet?
Slicer
Filter Field
Division
Group/Ungroup
