Question 1

You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?

Accepted Answer

A)  The PivotTable updates automatically when you make changes to the dataset.
B)  Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
C)  Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
D)  Excel deletes the PivotTable automatically so you can recreate it.

Question 2

Match between columns
                        Premises: Count
Min
Sum
Max
Product

Accepted Answer

The Answer of + and * or x and (1,2,3,4... is...

Question 3

You created a slicer on the field State.What items would you be most likely to see in the slicer?

Accepted Answer

A)  State 1,State 2
B)  AL,CA,GA,KY,MS,NC,OR,and VA
C)  Sales totals for each state
D)  A map of the US with the states represented as active.

Question 4

You cannot create custom calculations in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 5

Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable,how would you find out how many of each type of candy bar you have?

Accepted Answer

A)  Drag Item to both the VALUES and the ROWS area.
B)  Drag Price to the ROWS and Item to the VALUES area.
C)  Drag Item to the COLUMNS area.
D)  Drag Item to the ROWS areas.

Question 6

What does a + button indicate to the left of a row heading in an outline?

Accepted Answer

A)  You can expand the details of that category.
B)  The row has been modified.
C)  You can collapse the details of that category.
D)  There is a calculation in that cell.

Question 7

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

Question 8

If you are interested in finding what products people buy when they buy coffee,you would employ data warehousing techniques on supermarket sales data.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: VALUES area
FILTERS area
ROWS area
COLUMNS area
Slicer

Accepted Answer

The Answer of The field(s)used to organize a PivotTable along is...

Question 10

A PivotTable is limited to a single table of data.

Accepted Answer

A) True 
 B)False

Question 11

You can clear all fields from a PivotTable.

Accepted Answer

A) True 
 B)False

Question 12

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

Accepted Answer

A)  Click Expand Field in the Active Field Group on the Analyze tab.
B)  Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab.
C)  Click the - button to the left of the first category.
D)  You must move the second level out of the ROWS area.

Question 13

A PivotChart has live updates as you change the PivotTable.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ quickly formats a PivotTable with bold,fonts,shading,headers.

Accepted Answer

Style,Pivo...

Question 15

The ________ function is the default summary statistic for PivotTables.

Accepted Answer

A)  SUM
B)  AVERAGE
C)  MAX
D)  MIN

Question 16

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

Question 17

A PivotTable can only display one summary statistic at a time.

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: % of Grand Total
% of Parent Row Total
% of Column Total
No Calculation
% of Row Total

Accepted Answer

The Answer of Each value displays as a percentage of is...

Question 19

You are analyzing sales data and eating habits of students in a school cafeteria,you created a PivotTable with Date as a ROW and Extended Price as a summed VALUE.Which of the following Pivot Tables would demonstrate best what would happen if you added Category to the COLUMNS area?

Accepted Answer

A)   
B)   
C)   
D)

Question 20

Filters and Slicers are the same.

Accepted Answer

A) True 
 B)False

Exam 5: Subtotals, Pivot-tables, and Pivot-charts

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

Correct Answer
verified

Match each of the following PivotTable summary statistic functions to its mathematical operator or explanation:

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

Correct Answer
verified

A PivotTable is limited to a single table of data.

Correct Answer
verified

Match each of the following Show Value as Options to its best description:

A PivotChart has live updates as you change the PivotTable.

Correct Answer
verified

You are analyzing sales data and eating habits of students in a school cafeteria,you created a PivotTable with Date as a ROW and Extended Price as a summed VALUE.Which of the following Pivot Tables would demonstrate best what would happen if you added Category to the COLUMNS area?

Correct Answer
verified

Filters and Slicers are the same.

Correct Answer
verified

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

Correct Answer
verified

The ________ function is the default summary statistic for PivotTables.

Correct Answer
verified

You created a slicer on the field State.What items would you be most likely to see in the slicer?

Correct Answer
verified

Match each of the following terms to its description:

If you are interested in finding what products people buy when they buy coffee,you would employ data warehousing techniques on supermarket sales data.

Correct Answer
verified

Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable,how would you find out how many of each type of candy bar you have?

Correct Answer
verified

You cannot create custom calculations in a PivotTable.

Correct Answer
verified

You can clear all fields from a PivotTable.

Correct Answer
verified

A(n)________ quickly formats a PivotTable with bold,fonts,shading,headers.

Correct Answer
verified
Style,Pivo...
View Answer

You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?

Correct Answer
verified

A PivotTable can only display one summary statistic at a time.

Correct Answer
verified

What does a + button indicate to the left of a row heading in an outline?

Correct Answer
verified

Exam 5: Subtotals, Pivot-tables, and Pivot-charts

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

Correct AnswerverifiedShow Answer

Match each of the following PivotTable summary statistic functions to its mathematical operator or explanation:

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

Correct AnswerverifiedShow Answer

A PivotTable is limited to a single table of data.

Correct AnswerverifiedShow Answer

Match each of the following Show Value as Options to its best description:

A PivotChart has live updates as you change the PivotTable.

Correct AnswerverifiedShow Answer

You are analyzing sales data and eating habits of students in a school cafeteria,you created a PivotTable with Date as a ROW and Extended Price as a summed VALUE.Which of the following Pivot Tables would demonstrate best what would happen if you added Category to the COLUMNS area?

Correct AnswerverifiedShow Answer

Filters and Slicers are the same.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ________ function is the default summary statistic for PivotTables.

Correct AnswerverifiedShow Answer

You created a slicer on the field State.What items would you be most likely to see in the slicer?

Correct AnswerverifiedShow Answer

Match each of the following terms to its description:

If you are interested in finding what products people buy when they buy coffee,you would employ data warehousing techniques on supermarket sales data.

Correct AnswerverifiedShow Answer

Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable,how would you find out how many of each type of candy bar you have?

Correct AnswerverifiedShow Answer

You cannot create custom calculations in a PivotTable.

Correct AnswerverifiedShow Answer

You can clear all fields from a PivotTable.

Correct AnswerverifiedShow Answer

A(n)________ quickly formats a PivotTable with bold,fonts,shading,headers.

Correct AnswerverifiedStyle,Pivo...View AnswerShow Answer

You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?

Correct AnswerverifiedShow Answer

A PivotTable can only display one summary statistic at a time.

Correct AnswerverifiedShow Answer

What does a + button indicate to the left of a row heading in an outline?

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Style,Pivo...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified