Question 1

Which option would clear a PivotTable filter on a State field?

Accepted Answer

A) Select the filter arrow on the Rows header and select clear filter. 
B) Select the filter arrow on the Columns header and select clear filter. 
C) Drag the State field off the FILTERS area. 
D) Click the funnel icon to the right of the State filter and then select All and then click OK. 
A) Select the filter arrow on the Rows header and select clear filter. 
B) Select the filter arrow on the Columns header and select clear filter. 
C) Drag the State field off the FILTERS area. 
D) Click the funnel icon to the right of the State filter and then select All and then click OK. D

Question 2

A PivotTable time line can filter dates by all of these,except ________.

Accepted Answer

A) decade. 
B) day. 
C) quarter. 
D) year. 
A) decade. 
B) day. 
C) quarter. 
D) year. A

Question 3

Which of the following is true about creating a blank PivotTable?

Accepted Answer

A) A PivotTable may only be created from a table. 
B) A PivotTable may not be created from a range. 
C) A PivotTable may not be created on a connection to an external dataset. 
D) A PivotTable may be created on the same worksheet as the source data. 
A) A PivotTable may only be created from a table. 
B) A PivotTable may not be created from a range. 
C) A PivotTable may not be created on a connection to an external dataset. 
D) A PivotTable may be created on the same worksheet as the source data. D

Question 4

The first step in using the subtotal feature in Excel is to ________ the data.

Accepted Answer

The answer of The first step in using the subtotal...

Question 5

________ is the process of analyzing large amounts of data to identify trends and patterns in the data.

Accepted Answer

The answer of ________ is the process of analyzing large...

Question 6

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 7

The row level above the row you are working with in a PivotTable is the ________ row.

Accepted Answer

The answer of The row level above the row you...

Question 8

A primary benefit of creating a PivotTable is that you can rearrange or ________ fields to view and summarize data from different perspectives.

Accepted Answer

The answer of A primary benefit of creating a PivotTable...

Question 9

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

Accepted Answer

A) True 
 B)False

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

What field is in the ROWS area of the PivotTable that built this PivotChart?

Accepted Answer

A) Expenses 
B) Category 
C) Regular Meal 
D) Lunch Expenses 
A) Expenses 
B) Category 
C) Regular Meal 
D) Lunch Expenses

Question 12

Match between columns
                        Premises: AVERAGE
MIN
SUM
COUNT
MAX

Accepted Answer

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

Question 13

The option to display a value as a percentage of the whole rather than a raw calculation is found on the ________ tab of the Value Field Settings dialog box.

Accepted Answer

Show Value

Question 14

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

Accepted Answer

A) Select the appropriate cell in the PivotTable and type =AVERAGE(Price). 
B) Click the AVERAGE button on the Analyze tab. 
C) Right click the appropriate cell and select AVERAGE from the mini-tool bar. 
D) Click the field's arrow in the VALUES area and select Value Field Settings. 
A) Select the appropriate cell in the PivotTable and type =AVERAGE(Price). 
B) Click the AVERAGE button on the Analyze tab. 
C) Right click the appropriate cell and select AVERAGE from the mini-tool bar. 
D) Click the field's arrow in the VALUES area and select Value Field Settings.

Question 15

A(n)________ is a hierarchical structure used to group and summarize related data.

Accepted Answer

The answer of A(n)________ is a hierarchical structure used to...

Question 16

A Recommended PivotTable creates a PivotTable on a new worksheet.

Accepted Answer

A) True 
 B)False

Question 17

Using the % of Grand Total Calculation Option will display the value as ________.

Accepted Answer

A) a percentage of the grand total 
B) a percentage of the column total 
C) a percentage of the row total 
D) a percentage of the parent level row 
A) a percentage of the grand total 
B) a percentage of the column total 
C) a percentage of the row total 
D) a percentage of the parent level row

Question 18

________ display the total values for each particular row or column in a PivotTable.

Accepted Answer

The answer of ________ display the total values for each...

Question 19

What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?

Accepted Answer

A) Select Product. 
B) Select Number Format and choose Currency in the list of options and then click OK. 
C) Click the Show Values As tab and select Currency in this list and then click OK. 
D) Click cancel and select the cells and then format as Currency on the Home tab. 
A) Select Product. 
B) Select Number Format and choose Currency in the list of options and then click OK. 
C) Click the Show Values As tab and select Currency in this list and then click OK. 
D) Click cancel and select the cells and then format as Currency on the Home tab.

Question 20

A PivotChart has no filters available.

Accepted Answer

A) True 
 B)False

Which option would clear a PivotTable filter on a State field?

A PivotTable time line can filter dates by all of these,except ________.

Which of the following is true about creating a blank PivotTable?

The first step in using the subtotal feature in Excel is to ________ the data.

________ is the process of analyzing large amounts of data to identify trends and patterns in the data.

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

The row level above the row you are working with in a PivotTable is the ________ row.

A primary benefit of creating a PivotTable is that you can rearrange or ________ fields to view and summarize data from different perspectives.

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

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

What field is in the ROWS area of the PivotTable that built this PivotChart?

The option to display a value as a percentage of the whole rather than a raw calculation is found on the ________ tab of the Value Field Settings dialog box.

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

A(n)________ is a hierarchical structure used to group and summarize related data.

A Recommended PivotTable creates a PivotTable on a new worksheet.

Using the % of Grand Total Calculation Option will display the value as ________.

________ display the total values for each particular row or column in a PivotTable.

What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?

A PivotChart has no filters available.

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

Office 2016 Common Features

Filters

Exam 5: Subtotals, Pivot-tables, and Pivot-charts

Which option would clear a PivotTable filter on a State field?

A PivotTable time line can filter dates by all of these,except ________.

Which of the following is true about creating a blank PivotTable?

The first step in using the subtotal feature in Excel is to ________ the data.

________ is the process of analyzing large amounts of data to identify trends and patterns in the data.

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

The row level above the row you are working with in a PivotTable is the ________ row.

A primary benefit of creating a PivotTable is that you can rearrange or ________ fields to view and summarize data from different perspectives.

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

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

What field is in the ROWS area of the PivotTable that built this PivotChart?

The option to display a value as a percentage of the whole rather than a raw calculation is found on the ________ tab of the Value Field Settings dialog box.

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

A(n)________ is a hierarchical structure used to group and summarize related data.

A Recommended PivotTable creates a PivotTable on a new worksheet.

Using the % of Grand Total Calculation Option will display the value as ________.

________ display the total values for each particular row or column in a PivotTable.

What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?

A PivotChart has no filters available.

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

Office 2016 Common Features

Filters