Question 1

Select PivotTable styles ________.

Accepted Answer

A) from the PivotTable wizard 
B) from options in the minitoolbar 
C) from thumbnails in a style gallery 
D) from the Font group 
A) from the PivotTable wizard 
B) from options in the minitoolbar 
C) from thumbnails in a style gallery 
D) from the Font group

Question 2

You cannot create custom calculations in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 3

A PivotTable can display no subtotals and no grand totals.

Accepted Answer

A) True 
 B)False

Question 4

In a PivotTable Fields task pane, the ________ filters the data to display results based on particular conditions you set.

Accepted Answer

The answer of In a PivotTable Fields task pane, the...

Question 5

Which of the following is not a valid method to remove a field from a PivotTable?

Accepted Answer

A) Click the field name in the Drag fields between areas below section and select Remove Field. 
B) Click the check box next to the field name to deselect it in the Choose fields to add to report section. 
C) Select the field to be removed in the PivotTable and press DELETE. 
D) Drag a field name in the Drag fields between areas below section outside the PivotTable Fields List. 
A) Click the field name in the Drag fields between areas below section and select Remove Field. 
B) Click the check box next to the field name to deselect it in the Choose fields to add to report section. 
C) Select the field to be removed in the PivotTable and press DELETE. 
D) Drag a field name in the Drag fields between areas below section outside the PivotTable Fields List.

Question 6

A PivotChart is similar to a regular chart, except it is based on the categories and structure of a(n)________.

Accepted Answer

The answer of A PivotChart is similar to a regular...

Question 7

A PivotTable Calculated field starts with ________.

Accepted Answer

=, equal s

Question 8

Match between columns
                        Premises: AVERAGE
SUM
MAX
COUNT
MIN

Accepted Answer

The Answer of Adds the values in the field together is...

Question 9

Match between columns
                        Premises: AXIS (CATEGORY)
Plot Area
FILTERS
LEGEND (SERIES)
VALUES

Accepted Answer

The Answer of FILTERS and ROWS and COLUMNS and PivotTable is...

Question 10

Displaying subtotals at the top or bottom of a section is controlled on the PivotTable styles gallery.

Accepted Answer

A) True 
 B)False

Question 11

The % Period Expense Column on this PivotTable uses a % of Parent Row Total calculation option.

Accepted Answer

A) True 
 B)False

Question 12

A PivotChart has no filters available.

Accepted Answer

A) True 
 B)False

Question 13

A slicer has a window with a button for each item in a field.

Accepted Answer

A) True 
 B)False

Question 14

Which function is not a Subtotal function?

Accepted Answer

A) MAX 
B) SUM 
C) AGGREGATE 
D) AVERAGE 
A) MAX 
B) SUM 
C) AGGREGATE 
D) AVERAGE

Question 15

A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary.What is the first step to subtotal departmental salaries?

Accepted Answer

A) Sort by Last Name 
B) Sort by Salary 
C) Sort by Rank 
D) Sort by Department 
A) Sort by Last Name 
B) Sort by Salary 
C) Sort by Rank 
D) Sort by Department

Question 16

PivotTables ________ or summarize large amounts of data for analysis

Accepted Answer

The answer of PivotTables ________ or summarize large amounts of...

Question 17

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

Accepted Answer

A) Click Expand Field in the Active Field Group on the Analyze tab. 
B) Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab. 
C) Click the - button to the left of the first category. 
D) You must move the second level out of the ROWS area. 
A) Click Expand Field in the Active Field Group on the Analyze tab. 
B) Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab. 
C) Click the - button to the left of the first category. 
D) You must move the second level out of the ROWS area.

Question 18

A(n)________ is an interactive table which uses calculations to consolidate and summarize information.

Accepted Answer

A) list 
B) PivotTable 
C) Table 
D) range 
A) list 
B) PivotTable 
C) Table 
D) range

Question 19

________ Analysis is the built-in tool which automatically builds a recommended pivot table based on your dataset.

Accepted Answer

Quick, Rec

Question 20

Match between columns
                        Premises: Max
Product
Min
Sum
Count

Accepted Answer

The Answer of * or x and + and < is...

Select PivotTable styles ________.

You cannot create custom calculations in a PivotTable.

A PivotTable can display no subtotals and no grand totals.

In a PivotTable Fields task pane, the ________ filters the data to display results based on particular conditions you set.

Which of the following is not a valid method to remove a field from a PivotTable?

A PivotChart is similar to a regular chart, except it is based on the categories and structure of a(n)________.

A PivotTable Calculated field starts with ________.

Displaying subtotals at the top or bottom of a section is controlled on the PivotTable styles gallery.

The % Period Expense Column on this PivotTable uses a % of Parent Row Total calculation option.

A PivotChart has no filters available.

A slicer has a window with a button for each item in a field.

Which function is not a Subtotal function?

A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary.What is the first step to subtotal departmental salaries?

PivotTables ________ or summarize large amounts of data for analysis

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

A(n)________ is an interactive table which uses calculations to consolidate and summarize information.

________ Analysis is the built-in tool which automatically builds a recommended pivot table based on your dataset.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 5: Subtotals, Pivottables, and Pivotcharts

Select PivotTable styles ________.

You cannot create custom calculations in a PivotTable.

A PivotTable can display no subtotals and no grand totals.

In a PivotTable Fields task pane, the ________ filters the data to display results based on particular conditions you set.

Which of the following is not a valid method to remove a field from a PivotTable?

A PivotChart is similar to a regular chart, except it is based on the categories and structure of a(n)________.

A PivotTable Calculated field starts with ________.

Displaying subtotals at the top or bottom of a section is controlled on the PivotTable styles gallery.

The % Period Expense Column on this PivotTable uses a % of Parent Row Total calculation option.

A PivotChart has no filters available.

A slicer has a window with a button for each item in a field.

Which function is not a Subtotal function?

A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary.What is the first step to subtotal departmental salaries?

PivotTables ________ or summarize large amounts of data for analysis

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

A(n)________ is an interactive table which uses calculations to consolidate and summarize information.

________ Analysis is the built-in tool which automatically builds a recommended pivot table based on your dataset.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters