Question 1

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...

Question 2

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 3

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 4

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business), Area (i.e.Finance and Marketing), Units Sold, Wholesale Price, what column might Excel use as values?

Accepted Answer

A) Discipline 
B) Area 
C) Units Sold 
D) Both Discipline and Area 
A) Discipline 
B) Area 
C) Units Sold 
D) Both Discipline and Area

Question 5

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 6

________ apply different formatting and color schemes to a PivotChart.

Accepted Answer

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

Question 7

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 8

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 9

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

Accepted Answer

A) Commission Rate 
B) First Name 
C) Sales Person ID 
D) Price 
A) Commission Rate 
B) First Name 
C) Sales Person ID 
D) Price

Question 10

Where would you access the Manage Relationships dialog box to create a data model in Excel?

Accepted Answer

A) Relationships on the Data tab 
B) Data Models on the Analyze tab 
C) Layout on the Design tab 
D) Joins on the Data tab 
A) Relationships on the Data tab 
B) Data Models on the Analyze tab 
C) Layout on the Design tab 
D) Joins on the Data tab

Question 11

A relationship is an association between two tables where the tables contain a common field of data.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Quick Layout
Pivot Chart Styles
PivotTable Styles
PivotTable Layout
Change Colors

Accepted Answer

The Answer of Change the color scheme of a PivotChart is...

Question 13

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 14

Filters and Slicers are the same.

Accepted Answer

A) True 
 B)False

Question 15

________ 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 16

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 17

You can apply filters on dates to display summary statistics for data occurring during a particular time period.

Accepted Answer

A) True 
 B)False

Question 18

The calculation option which displays the values of a specific field from greatest to least is Rank ________.

Accepted Answer

The answer of The calculation option which displays the values...

Question 19

A PivotTable is limited to a single table of data.

Accepted Answer

A) True 
 B)False

Question 20

________ is an add-in that enables you to relate tables and external data from multiple sources.

Accepted Answer

The answer of ________ is an add-in that enables you...

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

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

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.

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business), Area (i.e.Finance and Marketing), Units Sold, Wholesale Price, what column might Excel use as values?

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

________ apply different formatting and color schemes to a PivotChart.

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

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

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

Where would you access the Manage Relationships dialog box to create a data model in Excel?

A relationship is an association between two tables where the tables contain a common field of data.

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

Filters and Slicers are the same.

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

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

You can apply filters on dates to display summary statistics for data occurring during a particular time period.

The calculation option which displays the values of a specific field from greatest to least is Rank ________.

A PivotTable is limited to a single table of data.

________ is an add-in that enables you to relate tables and external data from multiple sources.

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

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

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

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.

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business), Area (i.e.Finance and Marketing), Units Sold, Wholesale Price, what column might Excel use as values?

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

________ apply different formatting and color schemes to a PivotChart.

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

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

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

Where would you access the Manage Relationships dialog box to create a data model in Excel?

A relationship is an association between two tables where the tables contain a common field of data.

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

Filters and Slicers are the same.

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

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

You can apply filters on dates to display summary statistics for data occurring during a particular time period.

The calculation option which displays the values of a specific field from greatest to least is Rank ________.

A PivotTable is limited to a single table of data.

________ is an add-in that enables you to relate tables and external data from multiple sources.

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