Question 1

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

Accepted Answer

The Answer of Fields added to this area have a is...

Question 2

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  False

Question 3

Which is not true of filters in a PivotTable?

Accepted Answer

A) Filters show a subset of the dataset. 
B) Summary statistics do not change to reflect the values selected in the slicer. 
C) You may apply filters on multiple fields. 
D) An icon with a picture of a funnel appears when a PivotTable has a filter applied. 
A) Filters show a subset of the dataset. 
B) Summary statistics do not change to reflect the values selected in the slicer. 
C) You may apply filters on multiple fields. 
D) An icon with a picture of a funnel appears when a PivotTable has a filter applied. B

Question 4

If you want to turn off grand totals for columns on a PivotTable, select this option in the Grand Totals options.

Accepted Answer

A) On for Rows Only 
B) On for Columns Only 
C) Off for Rows and Columns 
D) On for Rows and Columns 
A) On for Rows Only 
B) On for Columns Only 
C) Off for Rows and Columns 
D) On for Rows and Columns

Question 5

A subtotal row must contain at least one ________ function.

Accepted Answer

A) financial 
B) sort 
C) aggregate 
D) sum 
A) financial 
B) sort 
C) aggregate 
D) sum

Question 6

You cannot change the label of a value.

Accepted Answer

A) True 
 B)False

Question 7

What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?

Accepted Answer

A) Select Product. 
B) Select Number Format and choose Currency in the list of options and then click OK. 
C) Click the Show Values As tab and select Currency in this list and then click OK. 
D) Click cancel and select the cells and then format as Currency on the Home tab. 
A) Select Product. 
B) Select Number Format and choose Currency in the list of options and then click OK. 
C) Click the Show Values As tab and select Currency in this list and then click OK. 
D) Click cancel and select the cells and then format as Currency on the Home tab.

Question 8

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 9

If you would like to show a subtotal of the wholesale price of a number of items of clothing on a PivotTable of data of both men and women.You have the following fields: Gender, Item and Price.Sum of Price is in the VALUES area.Gender is in the ROWS area.How do you get a subtotal of shirts and pants to display for each gender?

Accepted Answer

A) Drag the Item field to VALUES. 
B) Drag the Item field above Gender in ROWS. 
C) Drag the Gender field off the ROWS. 
D) Drag the Item field beneath Gender in ROWS. 
A) Drag the Item field to VALUES. 
B) Drag the Item field above Gender in ROWS. 
C) Drag the Gender field off the ROWS. 
D) Drag the Item field beneath Gender in ROWS.

Question 10

If you have related data stored in multiple tables, create a(n)________ to create a PivotTable on the combined data

Accepted Answer

A) Access link 
B) data collection 
C) Excel table 
D) data model 
A) Access link 
B) data collection 
C) Excel table 
D) data model

Question 11

Using the % of Grand Total Calculation Option will display the value as ________.

Accepted Answer

A) a percentage of the grand total 
B) a percentage of the column total 
C) a percentage of the row total 
D) a percentage of the parent level row 
A) a percentage of the grand total 
B) a percentage of the column total 
C) a percentage of the row total 
D) a percentage of the parent level row

Question 12

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

Accepted Answer

The Answer of Default value shows the raw summary of is...

Question 13

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 14

You can clear all fields from a PivotTable.

Accepted Answer

A) True 
 B)False

Question 15

How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?

Accepted Answer

A) remove Date from any PivotTable area 
B) drag Date to the ROWS area and group it. 
C) drag the Date field to the FILTERS area. 
D) You must use a slicer with dates. 
A) remove Date from any PivotTable area 
B) drag Date to the ROWS area and group it. 
C) drag the Date field to the FILTERS area. 
D) You must use a slicer with dates.

Question 16

Build a PivotChart in the PivotChart wizard on the PivotTable Tools Design tab.

Accepted Answer

A) True 
 B)False

Question 17

What dictates the order of hierarchy of fields in the rows of a PivotTable?

Accepted Answer

A) alphabetical order 
B) the order of the fields in the ROWS area. 
C) the order of the fields in the COLUMNS area 
D) the rank in the sort order dialog box. 
A) alphabetical order 
B) the order of the fields in the ROWS area. 
C) the order of the fields in the COLUMNS area 
D) the rank in the sort order dialog box.

Question 18

The four areas for organizing fields in a PivotTable are ROWS, COLUMNS, ________ and VALUES.

Accepted Answer

The answer of The four areas for organizing fields in...

Question 19

Creating a data model in Excel is very similar to creating relationships between tables in Access.

Accepted Answer

A) True 
 B)False

Question 20

Moving one of two fields from the ROWS area to the COLUMNS area of a PivotTable would ________.

Accepted Answer

A) divide the values by the number of columns 
B) consolidate data and remove redundant labels 
C) have no impact on the outcome 
D) make the table twice as long 
A) divide the values by the number of columns 
B) consolidate data and remove redundant labels 
C) have no impact on the outcome 
D) make the table twice as long

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

Which is not true of filters in a PivotTable?

If you want to turn off grand totals for columns on a PivotTable, select this option in the Grand Totals options.

A subtotal row must contain at least one ________ function.

You cannot change the label of a value.

What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?

The ________ function is the default summary statistic for PivotTables.

If you have related data stored in multiple tables, create a(n)________ to create a PivotTable on the combined data

Using the % of Grand Total Calculation Option will display the value as ________.

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 can clear all fields from a PivotTable.

How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?

Build a PivotChart in the PivotChart wizard on the PivotTable Tools Design tab.

What dictates the order of hierarchy of fields in the rows of a PivotTable?

The four areas for organizing fields in a PivotTable are ROWS, COLUMNS, ________ and VALUES.

Creating a data model in Excel is very similar to creating relationships between tables in Access.

Moving one of two fields from the ROWS area to the COLUMNS area of a PivotTable would ________.

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

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 5: Subtotals, Pivottables, and Pivotcharts

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

Which is not true of filters in a PivotTable?

If you want to turn off grand totals for columns on a PivotTable, select this option in the Grand Totals options.

A subtotal row must contain at least one ________ function.

You cannot change the label of a value.

What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?

The ________ function is the default summary statistic for PivotTables.

If you have related data stored in multiple tables, create a(n)________ to create a PivotTable on the combined data

Using the % of Grand Total Calculation Option will display the value as ________.

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 can clear all fields from a PivotTable.

How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?

Build a PivotChart in the PivotChart wizard on the PivotTable Tools Design tab.

What dictates the order of hierarchy of fields in the rows of a PivotTable?

The four areas for organizing fields in a PivotTable are ROWS, COLUMNS, ________ and VALUES.

Creating a data model in Excel is very similar to creating relationships between tables in Access.

Moving one of two fields from the ROWS area to the COLUMNS area of a PivotTable would ________.

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

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters