Question 1

A PivotChart is similar to a regular chart,except it is based on the categories and structure of a(n)________.

Accepted Answer

The answer of A PivotChart is similar to a regular...

Question 2

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 3

A calculated field must be built in the original data set.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Sum is the default action of a numerical VALUES field in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 6

You cannot change the label of a value.

Accepted Answer

A) True 
 B)False

Question 7

A(n)________ is a collection of related tables forming a database.

Accepted Answer

The answer of A(n)________ is a collection of related tables...

Question 8

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 9

Match between columns
                        Premises: Data mining
Outline
Dataset
Data model
Group

Accepted Answer

The Answer of Evaluating a large dataset looking for trends is...

Question 10

Which function is not a Subtotal function?

Accepted Answer

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

Question 11

A PivotChart ________.

Accepted Answer

A) is not altered by filters and slicers 
B) represents the consolidated data of a PivotTable visually 
C) does not use a PivotTable's COLUMNS area fields 
D) displays fields from the VALUES area on the legend 
A) is not altered by filters and slicers 
B) represents the consolidated data of a PivotTable visually 
C) does not use a PivotTable's COLUMNS area fields 
D) displays fields from the VALUES area on the legend

Question 12

What does applying a banded row format do to a Pivot Table?

Accepted Answer

A) Puts a band around subtotals 
B) Shades odd and even rows differently 
C) Keeps totals together 
D) Puts a line between each row 
A) Puts a band around subtotals 
B) Shades odd and even rows differently 
C) Keeps totals together 
D) Puts a line between each row

Question 13

A(n)________ associates matching fields between 2 tables.

Accepted Answer

The answer of A(n)________ associates matching fields between 2 tables....

Question 14

Match between columns
                        Premises: Pivot Chart Styles
Change Colors
PivotTable Styles
Quick Layout
PivotTable Layout

Accepted Answer

The Answer of Determine which totals and subtotals show and is...

Question 15

Which category or categories display in the PivotTable,if you see this slicer?

Accepted Answer

A) A La Carte,Drinks,and Snacks 
B) Regular Meal 
C) All categories 
D) No categories 
A) A La Carte,Drinks,and Snacks 
B) Regular Meal 
C) All categories 
D) No categories

Question 16

If you create a Recommended PivotTable on a group of data about book sales with theses columns:
Discipline (i.e.Business),Area (i.e.Finance and Marketing),Units Sold,Wholesale Price,what column might Excel use as values?

Accepted Answer

A) Discipline 
B) Area 
C) Units Sold 
D) Both Discipline and Area 
A) Discipline 
B) Area 
C) Units Sold 
D) Both Discipline and Area

Question 17

A PivotTable can display no subtotals and no grand totals.

Accepted Answer

A) True 
 B)False

Question 18

The ________ area is replaced with the AXIS (CATEGORY)in PivotChart task pane.

Accepted Answer

The answer of The ________ area is replaced with the...

Question 19

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 20

Match between columns
                        Premises: Related field
VLOOKUP
Table
Relationship
Data model

Accepted Answer

The Answer of The link between the fields with matching is...

A PivotChart is similar to a regular chart,except it is based on the categories and structure of a(n)________.

A calculated field must be built in the original data set.

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

Sum is the default action of a numerical VALUES field in a PivotTable.

You cannot change the label of a value.

A(n)________ is a collection of related tables forming a database.

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

Which function is not a Subtotal function?

A PivotChart ________.

What does applying a banded row format do to a Pivot Table?

A(n)________ associates matching fields between 2 tables.

Which category or categories display in the PivotTable,if you see this slicer?

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business),Area (i.e.Finance and Marketing),Units Sold,Wholesale Price,what column might Excel use as values?

A PivotTable can display no subtotals and no grand totals.

The ________ area is replaced with the AXIS (CATEGORY)in PivotChart task pane.

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

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

A PivotChart is similar to a regular chart,except it is based on the categories and structure of a(n)________.

A calculated field must be built in the original data set.

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

Sum is the default action of a numerical VALUES field in a PivotTable.

You cannot change the label of a value.

A(n)________ is a collection of related tables forming a database.

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

Which function is not a Subtotal function?

A PivotChart ________.

What does applying a banded row format do to a Pivot Table?

A(n)________ associates matching fields between 2 tables.

Which category or categories display in the PivotTable,if you see this slicer?

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business),Area (i.e.Finance and Marketing),Units Sold,Wholesale Price,what column might Excel use as values?

A PivotTable can display no subtotals and no grand totals.

The ________ area is replaced with the AXIS (CATEGORY)in PivotChart task pane.

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

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