Question 1

A(n)________ is a hierarchical structure used to group and summarize related data.

Accepted Answer

The answer of A(n)________ is a hierarchical structure used to...

Question 2

A(n)________ is the association between tables where both tables contain a common field.

Accepted Answer

A) link 
B) data model 
C) relationship 
D) share point 
A) link 
B) data model 
C) relationship 
D) share point

Question 3

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

Accepted Answer

The Answer of Where data is stored in a data is...

Question 4

A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

The Answer of Hierarchical structure and A tool to organize is...

Question 7

A PivotTable time line can filter dates by all of these, except ________.

Accepted Answer

A) decade. 
B) day. 
C) quarter. 
D) year. 
A) decade. 
B) day. 
C) quarter. 
D) year.

Question 8

Match between columns
                        Premises: Category (Regular Meal, Snacks, etc.)
Item (Pizza Slice, Cookies, Water, etc.)
Extended Price (unit price * quantity of item sold)
Quantity (quantity of item sold)
Date (date of the purchase)

Accepted Answer

The Answer of FILTERS or not used, at all and is...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

A(n)________ hides some values from a field in a PivotTable.

Accepted Answer

The answer of A(n)________ hides some values from a field...

Question 12

Excel is able to group data both by rows and by columns in a subtotal.

Accepted Answer

A) True 
 B)False

Question 13

The first step in using the subtotal feature in Excel is to ________ the data.

Accepted Answer

The answer of The first step in using the subtotal...

Question 14

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 15

Which of the following is not controlled by a PivotTable style?

Accepted Answer

A) row and column shading 
B) borders 
C) bold fonts 
D) subtotal calculations 
A) row and column shading 
B) borders 
C) bold fonts 
D) subtotal calculations

Question 16

When the underlying data changes, a PivotTable automatically updates.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following would be an effective calculated field labeled Retail Price to calculate a retail price that is 300% of wholesale price (for example, the wholesale price is $3 and retail price is $9)from a Wholesale Price field?

Accepted Answer

A) * Wholesale Price * 3 and accept default Name in the Insert Calculated Field dialog box 
B) = Wholesale Price * 300 with a Name of Retail Price in the Insert Calculated Field dialog box 
C) = Wholesale Price * 3 with a Name of Retail Price in the Insert Calculated Field dialog box 
D) Wholesale Price *300 with a Name of Retail Price in the Insert Calculated Field dialog box 
A) * Wholesale Price * 3 and accept default Name in the Insert Calculated Field dialog box 
B) = Wholesale Price * 300 with a Name of Retail Price in the Insert Calculated Field dialog box 
C) = Wholesale Price * 3 with a Name of Retail Price in the Insert Calculated Field dialog box 
D) Wholesale Price *300 with a Name of Retail Price in the Insert Calculated Field dialog box

Question 18

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

Accepted Answer

Style, Piv

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

A Recommended PivotTable creates a PivotTable on a new worksheet.

Accepted Answer

A) True 
 B)False

A(n)________ is a hierarchical structure used to group and summarize related data.

A(n)________ is the association between tables where both tables contain a common field.

A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.

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

A PivotTable time line can filter dates by all of these, except ________.

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

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

A(n)________ hides some values from a field in a PivotTable.

Excel is able to group data both by rows and by columns in a subtotal.

The first step in using the subtotal feature in Excel is to ________ the data.

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

Which of the following is not controlled by a PivotTable style?

When the underlying data changes, a PivotTable automatically updates.

Which of the following would be an effective calculated field labeled Retail Price to calculate a retail price that is 300% of wholesale price (for example, the wholesale price is $3 and retail price is $9)from a Wholesale Price field?

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

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

A Recommended PivotTable creates a PivotTable on a new worksheet.

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

A(n)________ is a hierarchical structure used to group and summarize related data.

A(n)________ is the association between tables where both tables contain a common field.

A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.

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

A PivotTable time line can filter dates by all of these, except ________.

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

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

A(n)________ hides some values from a field in a PivotTable.

Excel is able to group data both by rows and by columns in a subtotal.

The first step in using the subtotal feature in Excel is to ________ the data.

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

Which of the following is not controlled by a PivotTable style?

When the underlying data changes, a PivotTable automatically updates.

Which of the following would be an effective calculated field labeled Retail Price to calculate a retail price that is 300% of wholesale price (for example, the wholesale price is $3 and retail price is $9)from a Wholesale Price field?

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

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

A Recommended PivotTable creates a PivotTable on a new worksheet.

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