NEW
Font size
WorksheetsExcel - Pop Quiz - 3
Total questions: 10
Worksheet time: 5mins
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
Study the screenshot above. Under which tab and in which function group will you find the option to insert a Pivot Table?
Under the Insert tab in the Tables group.
Under the Formulas tab in the Data Analysis group.
In the Data group in the Pivot Tables group.
In the Data group in the Tables group.
Where is a Pivot Table inserted?
Below the last row of data in your worksheet.
Next to the last column of data in your worksheet.
It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.
Which of the following is NOT a box in the PivotTable Fields List?
Column Labels
Report Filter
Values
Formulas
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.
Deciding on which fields (column and row labels) to use to analyze the data.
What is being created here?
Pivot table
Converting a table as an excel table
A graph
A pivot chart
There are four categories to add in the pivot table editor:
Value, table, chart and information
Filter, query, header and footer
Index, appendix, term and value
Row, column, value and filter
You can change the view of a PivotTable report depending on what you want to analyze.
True
False
You can use a formula in a pivot table?
True
False
