NEW
Font size
WorksheetsEE Pivot Tables
Total questions: 15
Worksheet time: 8mins
A ____ is an interactive view of worksheet data.
PivotChart report
PivotTable report
2-D column chart
trendline
In PivotTables, ____ fields correspond to columns in the original data.
row
index
summary
category
In a PivotTable, ____ fields correspond to summary values of original data across categories.
category
index
data
summary
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
organizing
implementing
sorting
filtering
The summary function that calculates the number of data values in a PivotTable report is ____.
Count
Product
Var
Count Nums
The summary function that calculates the smallest data value in a PivotTable report is ____.
Varp
Min
Max
Average
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
A powerful feature in excel that calculates, summarizes,, analyze data and lets you see comparisons, patterns, and trends in your data.
Visual Basic
Pivot Table
Consolidate Data
Index Match
Slicers are available for use only after you create a:
sparkline.
PivotTable.
line chart.
formatted table.
Which is a graphical representation that fails to depict all of the exact data in the worksheet?
chart
dual-axis chart
template
trendline
Which is an example of a trendline option in Excel?
bar
exponential
radar
stock
