Question 1

PivotTable styles are located on the ________ tab.

Accepted Answer

A)  DESIGN
B)  ANALYZE
C)  INSERT
D)  OPTIONSE) A) and B)
F) A) and C)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  PowerPivot
B)  Table Analysis
C)  PivotTable
D)  Aggregate AnalysisE) B) and C)
F) A) and D) C

Question 6

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

Accepted Answer

A) True 
 B)False  False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  one
B)  two
C)  three
D)  fourE) A) and B)
F) A) and D)

Question 9

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

Accepted Answer

A)  COLUMNS
B)  TABLES
C)  ROWS
D)  VALUESE) A) and B)
F) A) and C)

Question 10

Slicer styles are located on the ________ tab.

Accepted Answer

A)  VIEW
B)  INSERT
C)  DESIGN
D)  OPTIONSE) B) and C)
F) None of the above

Question 11

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

Accepted Answer

A)  PivotChart
B)  slicer
C)  PowerPivot
D)  data mineE) A) and D)
F) All of the above

Question 12

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

Accepted Answer

A)  cluster
B)  group
C)  aggregate
D)  condenseE) A) and C)
F) C) and D)

Question 13

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

Accepted Answer

A)  Mining
B)  Grouping
C)  Outlining
D)  FilteringE) None of the above
F) A) and B)

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False  False

Question 16

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

Accepted Answer

A)  PivotChart
B)  PowerPivot
C)  Scatter Chart
D)  PivotGraphE) A) and B)
F) A) and C)

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

PivotTable styles are located on the ________ tab.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
C

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

Correct Answer
verified
False

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Slicer styles are located on the ________ tab.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
False

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

Correct Answer
verified

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

PivotTable styles are located on the ________ tab.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Slicer styles are located on the ________ tab.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified