Question 1

To update the data in a PivotTable click ________ in the Data group.

Accepted Answer

The answer of To update the data in a PivotTable...

Question 2

When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).

Accepted Answer

The answer of When the calculation options of a PivotTable...

Question 3

The default numerical field calculation for a PivotTable is ________.

Accepted Answer

The answer of The default numerical field calculation for a...

Question 4

A(n)________ is a user-defined field that does not exist in the original dataset.

Accepted Answer

The answer of A(n)________ is a user-defined field that does...

Question 5

A(n)________ is an association between two related tables where both tables contain a related field of data,such as IDs.

Accepted Answer

The answer of A(n)________ is an association between two related...

Question 6

The ________ is text that displays in the header at the top of the slicer window.

Accepted Answer

The answer of The ________ is text that displays in...

Question 7

________ is a built-in add-in program in Excel 2013 that enables you to import millions of
rows of data from multiple data sources,create a relationship between two or more related
tables within one workbook,and maintain connections.

Accepted Answer

The answer of ________ is a built-in add-in program in...

Question 8

________ provide visual representations of data filters that are active in a PivotTable.

Accepted Answer

The answer of ________ provide visual representations of data filters...

Question 9

A(n)________ is an interactive graphical representation of the data in a PivotTable.

Accepted Answer

The answer of A(n)________ is an interactive graphical representation of...

Question 10

A(n)________ is a small window containing one button for each unique item in a field so that you can filter the PivotTable quickly.

Accepted Answer

The answer of A(n)________ is a small window containing one...

Question 11

What are the benefits of using PivotTables over traditional data tables?

Accepted Answer

The answer of What are the benefits of using PivotTables...

Question 12

What are the benefits of using Slicers over traditional filters?

Accepted Answer

The answer of What are the benefits of using Slicers...

Question 13

In what situations would you change the default data field calculations settings of a PivotTable?

Accepted Answer

The answer of In what situations would you change the...

Question 14

Match between columns
                        Premises: Subtotal
Outline
Collapse
Expand
Grouping

Accepted Answer

The Answer of A hierarchical structure of data and A is...

Question 15

Match between columns
                        Premises: 1
+
4
3
2

Accepted Answer

The Answer of Expand an outline group to see its is...

Question 16

Match between columns
                        Premises: Quick Analysis gallery
PivotTable Fields task pane
PivotTable
Data mining
Subtotal

Accepted Answer

The Answer of Contains two sections that allow for the is...

Question 17

Match between columns
                        Premises: Columns Area
Rows Area
Filters Area
PivotTable Fields task pane
Values Area

Accepted Answer

The Answer of Organizes and groups data into categories on is...

Question 18

Match between columns
                        Premises: Move to Report Filter
Move to Beginning
Move Up
Move Down
Move to End

Accepted Answer

The Answer of To the end of all fields in is...

Question 19

Match between columns
                        Premises: Calculated Field
PivotChart
Slicer
Slicer caption
Filter

Accepted Answer

The Answer of Text that displays in the header at is...

Question 20

Match between columns
                        Premises: Slicer Styles
Arrange
Size
Slicer
Buttons

Accepted Answer

The Answer of Applies a style to the slicer by is...

Quiz 22: Excel: Subtotals, Pivot-tables, and Pivot-charts

To update the data in a PivotTable click ________ in the Data group.

When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).

The default numerical field calculation for a PivotTable is ________.

A(n)________ is a user-defined field that does not exist in the original dataset.

A(n)________ is an association between two related tables where both tables contain a related field of data,such as IDs.

The ________ is text that displays in the header at the top of the slicer window.

________ is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections.

________ provide visual representations of data filters that are active in a PivotTable.

A(n)________ is an interactive graphical representation of the data in a PivotTable.

A(n)________ is a small window containing one button for each unique item in a field so that you can filter the PivotTable quickly.

What are the benefits of using PivotTables over traditional data tables?

What are the benefits of using Slicers over traditional filters?

In what situations would you change the default data field calculations settings of a PivotTable?

Match the following terms to their meanings:

Match the following grouping button with the corresponding description:

Match the following calculated field settings with the corresponding description:

Match the following PivotTable areas with the corresponding description

Match the following Pivot Table move options with the corresponding description:

Match the following calculated field settings with the corresponding description:

Match each Slicer Tools command group with the corresponding description: