Question 1

Match between columns
                        Premises: PowerPivot
Relationship
Add-in
PivotChart
Slicer

Accepted Answer

The Answer of A small window containing one button for is...

Question 2

When setting custom calculation options in a PivotTable,what does Running 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 values as running totals 
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 values as running totals 
D) Displays values as: (value for the item)/ (value for the parent
Item on rows)

Question 3

Multiple filters can be applied to a PivotTable.

Accepted Answer

A) True 
 B)False

Question 4

Match the following calculated field settings with the corresponding description:
I.% of Grand Total
II.% of Column Total
III.% of Row Total
IV.% of Parent Row Total
V.Running Total
A.Displays values as:
(value for the item)/ (value for the parent item on rows)
B.Displays each value as a percentage of the respective row total.The values in each row total 100%
C.Displays each value as a percentage of the respective column total.The values in each column total 100%
D.Displays values as running totals
E.Displays each value as a percentage of the grand total

Accepted Answer

The answer of Match the following calculated field settings with...

Question 5

What does the Values Area of a PivotTable do?

Accepted Answer

A) Subdivides data into one or more additional categories 
B) Filters the data to display results based on particular conditions you set 
C) Organizes and groups data into categories on the left side.Each group
Name occupies a single row 
D) Displays summary statistics,such as totals or averages 
A) Subdivides data into one or more additional categories 
B) Filters the data to display results based on particular conditions you set 
C) Organizes and groups data into categories on the left side.Each group
Name occupies a single row 
D) Displays summary statistics,such as totals or averages

Question 6

When modifying a PivotTable,the ________ appears on the right side of the window.

Accepted Answer

PivotTable

Question 7

A(n)________ is a powerful,interactive data-mining feature that enables you to summarize and analyze data,especially helpful when working with large datasets.

Accepted Answer

The answer of A(n)________ is a powerful,interactive data-mining feature that...

Question 8

Which of the following tools is best suited to analyze the most productive students in a school district over a period of time?

Accepted Answer

A) PivotTable 
B) Subtotal 
C) Pie Chart 
D) Slicer 
A) PivotTable 
B) Subtotal 
C) Pie Chart 
D) Slicer

Question 9

________ provide visual representations of data filters that are active in a PivotTable.

Accepted Answer

The answer of ________ provide visual representations of data filters...

Question 10

What tool is best suited for organizing a spreadsheet of rental cars by category in order to be collapsed or expanded?

Accepted Answer

A) Grouping 
B) PivotTables 
C) Slicers 
D) Outlines 
A) Grouping 
B) PivotTables 
C) Slicers 
D) Outlines

Question 11

Match between columns
                        Premises: layer
fill
grid
rotate
flip

Accepted Answer

The Answer of shift an object in a particular direction is...

Question 12

Match between columns
                        Premises: PivotTable Fields task pane
Filters Area
Columns Area
Rows Area
Values Area

Accepted Answer

The Answer of Organizes and groups data into categories on is...

Question 13

What is the best PowerPivot tool when attempting to link to tables with a common related field?

Accepted Answer

A) Pivot 
B) Relationships 
C) Links 
D) External references 
A) Pivot 
B) Relationships 
C) Links 
D) External references

Question 14

The default numerical field calculation for a PivotTable is ________.

Accepted Answer

The answer of The default numerical field calculation for a...

Question 15

Match between columns
                        Premises: data validation
validation rule
input mask
lookup field

Accepted Answer

The Answer of enables you to restrict the data being is...

Question 16

The Quick Analysis gallery is the only method to create a PivotTable.

Accepted Answer

A) True 
 B)False

Exam 5: Subtotals Pivot-tables and Pivot-charts

When setting custom calculation options in a PivotTable,what does Running Total calculate?

Multiple filters can be applied to a PivotTable.

What does the Values Area of a PivotTable do?

When modifying a PivotTable,the ________ appears on the right side of the window.

A(n)________ is a powerful,interactive data-mining feature that enables you to summarize and analyze data,especially helpful when working with large datasets.

Which of the following tools is best suited to analyze the most productive students in a school district over a period of time?

________ provide visual representations of data filters that are active in a PivotTable.

What tool is best suited for organizing a spreadsheet of rental cars by category in order to be collapsed or expanded?

What is the best PowerPivot tool when attempting to link to tables with a common related field?

The default numerical field calculation for a PivotTable is ________.

The Quick Analysis gallery is the only method to create a PivotTable.

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