Question 1

PivotTables automatically refresh data.

Accepted Answer

A) True 
 B)False  False

Question 2

What are the benefits of using PivotTables over traditional data tables?

Accepted Answer

PivotTables have more robust calculation and viewing options than traditional data tables.The concept of "pivot" refers to their ability to present the same data from multiple angles,giving the user the ability to gain additional insight on the data.

Question 3

________ is a built-in add-in program in Excel 2013 that enables you to import millions of
rows of data from multiple data sources,create a relationship between two or more related
tables within one workbook,and maintain connections.

Accepted Answer

PowerPivot

Question 4

Which of the following is not an area of the PivotTable Fields task pane?

Accepted Answer

A) Filters Area 
B) Columns Area 
C) Data Area 
D) Rows Area 
A) Filters Area 
B) Columns Area 
C) Data Area 
D) Rows Area

Question 5

Connections are automatically created in PowerPivot.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Match between columns
                        Premises: header row
total row
first column
banded row
banded column

Accepted Answer

The Answer of formats even columns differently than odd columns is...

Question 8

A(n)________ is a user-defined field that does not exist in the original dataset.

Accepted Answer

The answer of A(n)________ is a user-defined field that does...

Question 9

Which of the following calculations cannot be completed with subtotal?

Accepted Answer

A) Average 
B) Standard Deviation 
C) Sum 
D) Max 
A) Average 
B) Standard Deviation 
C) Sum 
D) Max

Question 10

The default numerical field calculation for PivotTables is SUM.

Accepted Answer

A) True 
 B)False

Question 11

Custom calculated fields will not update if the data source changes.

Accepted Answer

A) True 
 B)False

Question 12

When setting custom calculation options in a PivotTable,what does % of Parent Row Total calculate?

Accepted Answer

A) Displays each value as a percentage of the grand total 
B) Displays each value as a percentage of the respective column
Total.The values in each column total 100% 
C) Displays each value as a percentage of the respective row
Total.The values in each row total 100% 
D) Displays values as: (value for the item)/ (value for the parent
Item on rows) 
A) Displays each value as a percentage of the grand total 
B) Displays each value as a percentage of the respective column
Total.The values in each column total 100% 
C) Displays each value as a percentage of the respective row
Total.The values in each row total 100% 
D) Displays values as: (value for the item)/ (value for the parent
Item on rows)

Question 13

Filters can only be applied to PivotTables one at a time.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: Move Up
Move Down
Move to Beginning
Move to End
Move to Report Filter

Accepted Answer

The Answer of To the end of the Report Filter is...

Question 15

Once created,a PivotTable cannot be edited.

Accepted Answer

A) True 
 B)False

Question 16

Once completed,fields in PivotTables can be rearranged.

Accepted Answer

A) True 
 B)False

Question 17

PivotTables can be created from the ________ gallery.

Accepted Answer

The answer of PivotTables can be created from the ________...

Question 18

Custom slicers can be imported into other workbooks.

Accepted Answer

A) True 
 B)False

Question 19

What tool is best suited for incorporating manufacturing information from one table with shipping information from a related table within one PivotTable?

Accepted Answer

A) Slicers 
B) PowerPivot 
C) Pivot Charts 
D) Grouping 
A) Slicers 
B) PowerPivot 
C) Pivot Charts 
D) Grouping

Question 20

Multiple subtotals can be applied to one data set.

Accepted Answer

A) True 
 B)False

Exam 5: Subtotals Pivot-tables and Pivot-charts

PivotTables automatically refresh data.

What are the benefits of using PivotTables over traditional data tables?

________ is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections.

Which of the following is not an area of the PivotTable Fields task pane?

Connections are automatically created in PowerPivot.

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

A(n)________ is a user-defined field that does not exist in the original dataset.

Which of the following calculations cannot be completed with subtotal?

The default numerical field calculation for PivotTables is SUM.

Custom calculated fields will not update if the data source changes.

When setting custom calculation options in a PivotTable,what does % of Parent Row Total calculate?

Filters can only be applied to PivotTables one at a time.

Once created,a PivotTable cannot be edited.

Once completed,fields in PivotTables can be rearranged.

PivotTables can be created from the ________ gallery.

Custom slicers can be imported into other workbooks.

What tool is best suited for incorporating manufacturing information from one table with shipping information from a related table within one PivotTable?

Multiple subtotals can be applied to one data set.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters