Deck 1 : Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Question 1

A(n)________ allows you to summarize and examine data such as analyzing book sales by categories.

A)PowerPivot
B)Table Analysis
C)PivotTable
D)Aggregate Analysis

Answer 1

C

Question 2

Slicer styles are located on the ________ tab.

A)VIEW
B)INSERT
C)DESIGN
D)OPTIONS

Answer 2

D

Question 3

PivotTable styles are located on the ________ tab.

A)DESIGN
B)ANALYZE
C)INSERT
D)OPTIONS

Answer 3

A

Question 4

Which of the following is NOT an area used when creating a PivotTable?

A)COLUMNS
B)TABLES
C)ROWS
D)VALUES

Question 5

Changes made to a PivotChart are automatically reflected in the corresponding PivotTable.

Question 6

You can use a maximum of ________ numbered button(s)in addition to the + and - buttons to expand and collapse an outline.

A)one
B)two
C)three
D)four

Question 7

You can move a field from one PivotTable area to another by just dragging it.

Question 8

________ is used to exclude particular categories or values from a PivotTable.

A)Mining
B)Grouping
C)Outlining
D)Filtering

Question 9

To remove a field from a PivotTable,you select it and press Delete.

Question 10

You can use subtotals in a dataset to calculate subtotals of groups such as sales of books within a discipline.

Question 11

When creating a calculated field in a PivotTable,range names and cell references outside the PivotTable CANNOT be used.

Question 12

A ________ is a series of buttons that allows users to filter a PivotTable.

A)PivotChart
B)slicer
C)PowerPivot
D)data mine

Question 13

A ________ is used to graphically represent the data in a PivotTable.

A)PivotChart
B)PowerPivot
C)Scatter Chart
D)PivotGraph

Question 14

To apply an outline to columns,you must ________ the desired columns.

A)cluster
B)group
C)aggregate
D)condense

Question 15

To properly have two levels of subtotals,you must subtotal the secondary category first and then add a subtotal for your primary category.

Question 16

Changes made to the original worksheet are automatically reflected in the PivotTable.