Question 1

________ apply different formatting and color schemes to a PivotChart.

Accepted Answer

The answer of ________ apply different formatting and color schemes...

Question 2

A slicer can be formatted so the ________ display in one or many columns.

Accepted Answer

The answer of A slicer can be formatted so the...

Question 3

When the underlying data changes,a PivotTable automatically updates.

Accepted Answer

A) True 
 B)False

Question 4

In a Subtotaled Worksheet,this is a correct example of a subtotal function in cell B90 which sums B80:
B89 :
 =SUBTOTAL(9,B80:
B89).

Accepted Answer

A) True 
 B)False

Question 5

A subtotal row must contain at least one ________ function.

Accepted Answer

A) financial 
B) sort 
C) aggregate 
D) sum 
A) financial 
B) sort 
C) aggregate 
D) sum

Question 6

Which is not true about Slicers?

Accepted Answer

A) Aggregate values do not respond to slicers. 
B) You can filter data by a single value. 
C) You can move a slicer so it does not cover a PivotTable. 
D) You can filter data by multiple values. 
A) Aggregate values do not respond to slicers. 
B) You can filter data by a single value. 
C) You can move a slicer so it does not cover a PivotTable. 
D) You can filter data by multiple values.

Question 7

You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?

Accepted Answer

A) Add sales to the VALUES area once and select both AVERAGE and SUM functions. 
B) Add sales to the COLUMNS area. 
C) Add sales to the ROWS area and then choose Average. 
D) Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat,allowing it to default to SUM. 
A) Add sales to the VALUES area once and select both AVERAGE and SUM functions. 
B) Add sales to the COLUMNS area. 
C) Add sales to the ROWS area and then choose Average. 
D) Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat,allowing it to default to SUM.

Question 8

If you want to turn off grand totals for columns on a PivotTable,select this option in the Grand Totals options.

Accepted Answer

A) On for Rows Only 
B) On for Columns Only 
C) Off for Rows and Columns 
D) On for Rows and Columns 
A) On for Rows Only 
B) On for Columns Only 
C) Off for Rows and Columns 
D) On for Rows and Columns

Question 9

A(n)________ is the tool which appears in a separate window and displays all available options to show or hide data for a field.

Accepted Answer

The answer of A(n)________ is the tool which appears in...

Question 10

A(n)________ is a user-defined field that derives its value by performing calculations on other fields in a PivotTable

Accepted Answer

A) value function 
B) dataset variable 
C) user field 
D) calculated field 
A) value function 
B) dataset variable 
C) user field 
D) calculated field

Question 11

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

Accepted Answer

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

Question 12

A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.

Accepted Answer

A) True 
 B)False

Question 13

Auto Outline creates an outline based on the data structure.

Accepted Answer

A) True 
 B)False

Question 14

Excel is able to group data both by rows and by columns in a subtotal.

Accepted Answer

A) True 
 B)False

Question 15

What dictates the order of hierarchy of fields in the rows of a PivotTable?

Accepted Answer

A) alphabetical order 
B) the order of the fields in the ROWS area. 
C) the order of the fields in the COLUMNS area 
D) the rank in the sort order dialog box. 
A) alphabetical order 
B) the order of the fields in the ROWS area. 
C) the order of the fields in the COLUMNS area 
D) the rank in the sort order dialog box.

Question 16

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 17

PivotTables ________ or summarize large amounts of data for analysis

Accepted Answer

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

Question 18

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 19

You would find the Group and Ungroup buttons in the Outline group on the ________ tab.

Accepted Answer

The answer of You would find the Group and Ungroup...

Question 20

If the underlying data for a PivotTable changes,you must ________ the PivotTable to show the changes.

Accepted Answer

The answer of If the underlying data for a PivotTable...

________ apply different formatting and color schemes to a PivotChart.

A slicer can be formatted so the ________ display in one or many columns.

When the underlying data changes,a PivotTable automatically updates.

In a Subtotaled Worksheet,this is a correct example of a subtotal function in cell B90 which sums B80: B89 : =SUBTOTAL(9,B80: B89).

A subtotal row must contain at least one ________ function.

Which is not true about Slicers?

You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?

If you want to turn off grand totals for columns on a PivotTable,select this option in the Grand Totals options.

A(n)________ is the tool which appears in a separate window and displays all available options to show or hide data for a field.

A(n)________ is a user-defined field that derives its value by performing calculations on other fields in a PivotTable

A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.

Auto Outline creates an outline based on the data structure.

Excel is able to group data both by rows and by columns in a subtotal.

What dictates the order of hierarchy of fields in the rows of a PivotTable?

Select PivotTable styles ________.

PivotTables ________ or summarize large amounts of data for analysis

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

You would find the Group and Ungroup buttons in the Outline group on the ________ tab.

If the underlying data for a PivotTable changes,you must ________ the PivotTable to show the changes.

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

________ apply different formatting and color schemes to a PivotChart.

A slicer can be formatted so the ________ display in one or many columns.

When the underlying data changes,a PivotTable automatically updates.

In a Subtotaled Worksheet,this is a correct example of a subtotal function in cell B90 which sums B80: B89 : =SUBTOTAL(9,B80: B89).

A subtotal row must contain at least one ________ function.

Which is not true about Slicers?

You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?

If you want to turn off grand totals for columns on a PivotTable,select this option in the Grand Totals options.

A(n)________ is the tool which appears in a separate window and displays all available options to show or hide data for a field.

A(n)________ is a user-defined field that derives its value by performing calculations on other fields in a PivotTable

A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.

Auto Outline creates an outline based on the data structure.

Excel is able to group data both by rows and by columns in a subtotal.

What dictates the order of hierarchy of fields in the rows of a PivotTable?

Select PivotTable styles ________.

PivotTables ________ or summarize large amounts of data for analysis

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

You would find the Group and Ungroup buttons in the Outline group on the ________ tab.

If the underlying data for a PivotTable changes,you must ________ the PivotTable to show the changes.

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