Question 1

Match between columns
                        Premises: Count
Min
Sum
Max
Product

Accepted Answer

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

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

A PivotTable is limited to a single table of data.

Accepted Answer

A) True 
 B)False

Question 6

You can clear all fields from a PivotTable.

Accepted Answer

A) True 
 B)False

Question 7

You cannot create custom calculations in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 8

Filters and Slicers are the same.

Accepted Answer

A) True 
 B)False

Question 9

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

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

Accepted Answer

Style,Pivo

Question 11

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

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

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

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 15

A PivotChart has live updates as you change the PivotTable.

Accepted Answer

A) True 
 B)False

Question 16

The ________ function is the default summary statistic for PivotTables.

Accepted Answer

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

Question 17

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)    
A)    
B)    
C)    
D)

Question 18

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 19

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

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

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

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

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?

A PivotTable is limited to a single table of data.

You can clear all fields from a PivotTable.

You cannot create custom calculations in a PivotTable.

Filters and Slicers are the same.

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?

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

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

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

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

A PivotChart has live updates as you change the PivotTable.

The ________ function is the default summary statistic for PivotTables.

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?

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

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

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

Office 2016 Common Features

Filters

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

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

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

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?

A PivotTable is limited to a single table of data.

You can clear all fields from a PivotTable.

You cannot create custom calculations in a PivotTable.

Filters and Slicers are the same.

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?

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

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

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

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

A PivotChart has live updates as you change the PivotTable.

The ________ function is the default summary statistic for PivotTables.

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?

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

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

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

Office 2016 Common Features

Filters