Question 1

Match between columns
                        Premises: Expand
Subtotal
Collapse
Summary statistics
Grand total

Accepted Answer

The Answer of The full summary of all items in is...

Question 2

A relationship is an association between two tables where the tables contain a common field of data.

Accepted Answer

A) True 
 B)False

Question 3

A slicer has a window with a button for each item in a field.

Accepted Answer

A) True 
 B)False

Question 4

A PivotTable Calculated field starts with ________.

Accepted Answer

The answer of A PivotTable Calculated field starts with ________....

Question 5

________ Analysis is the built-in tool which automatically builds a recommended pivot table based on your dataset.

Accepted Answer

Quick,Reco

Question 6

The calculation option which displays the values of a specific field from greatest to least is Rank ________.

Accepted Answer

The answer of The calculation option which displays the values...

Question 7

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 8

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

Accepted Answer

The Answer of First in ROWS and Second in VALUES is...

Question 9

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

Question 10

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

Accepted Answer

A) Commission Rate 
B) First Name 
C) Sales Person ID 
D) Price 
A) Commission Rate 
B) First Name 
C) Sales Person ID 
D) Price

Question 11

Grouping is ________.

Accepted Answer

A) using a VLOOKUP function to categorize data 
B) joining rows or columns of related data into a single entity for analysis 
C) the top level in an outline 
D) joining unrelated data for analysis 
A) using a VLOOKUP function to categorize data 
B) joining rows or columns of related data into a single entity for analysis 
C) the top level in an outline 
D) joining unrelated data for analysis

Question 12

In a PivotTable Fields task pane,the ________ filters the data to display results based on particular conditions you set.

Accepted Answer

The answer of In a PivotTable Fields task pane,the ________...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

You can apply filters on dates to display summary statistics for data occurring during a particular time period.

Accepted Answer

A) True 
 B)False

Question 17

A worksheet of faculty members at your university contains these columns in this sequence:
Rank,Last Name,First Name,Department,and Salary.What is the first step to subtotal departmental salaries?

Accepted Answer

A) Sort by Last Name 
B) Sort by Salary 
C) Sort by Rank 
D) Sort by Department 
A) Sort by Last Name 
B) Sort by Salary 
C) Sort by Rank 
D) Sort by Department

Question 18

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 19

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.

Question 20

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

Accepted Answer

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

A relationship is an association between two tables where the tables contain a common field of data.

A slicer has a window with a button for each item in a field.

A PivotTable Calculated field starts with ________.

________ Analysis is the built-in tool which automatically builds a recommended pivot table based on your dataset.

The calculation option which displays the values of a specific field from greatest to least is Rank ________.

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

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

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

Grouping is ________.

In a PivotTable Fields task pane,the ________ filters the data to display results based on particular conditions you set.

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

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?

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

You can apply filters on dates to display summary statistics for data occurring during a particular time period.

A worksheet of faculty members at your university contains these columns in this sequence: Rank,Last Name,First Name,Department,and Salary.What is the first step to subtotal departmental salaries?

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

Which is not true of filters in a PivotTable?

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

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 relationship is an association between two tables where the tables contain a common field of data.

A slicer has a window with a button for each item in a field.

A PivotTable Calculated field starts with ________.

________ Analysis is the built-in tool which automatically builds a recommended pivot table based on your dataset.

The calculation option which displays the values of a specific field from greatest to least is Rank ________.

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

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

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

Grouping is ________.

In a PivotTable Fields task pane,the ________ filters the data to display results based on particular conditions you set.

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

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?

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

You can apply filters on dates to display summary statistics for data occurring during a particular time period.

A worksheet of faculty members at your university contains these columns in this sequence: Rank,Last Name,First Name,Department,and Salary.What is the first step to subtotal departmental salaries?

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

Which is not true of filters in a PivotTable?

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

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