Question 1

Once applied,subtotals cannot be removed.

Accepted Answer

A) True 
 B)False

Question 2

What does a slicer caption do?

Accepted Answer

A) Provides feedback on slicers that are engaged 
B) Provides access to slicer options 
C) Displays text in the header at the top of the slicer window 
D) Creates caption meta data 
A) Provides feedback on slicers that are engaged 
B) Provides access to slicer options 
C) Displays text in the header at the top of the slicer window 
D) Creates caption meta data

Question 3

What are the benefits of using Slicers over traditional filters?

Accepted Answer

Slicers work similar to traditional filt

Question 4

Which of the following is not true regarding data mining?

Accepted Answer

A) Analyzes large amounts of data 
B) Uses advanced statistical techniques 
C) Identifies trends 
D) Exports data 
A) Analyzes large amounts of data 
B) Uses advanced statistical techniques 
C) Identifies trends 
D) Exports data

Question 5

When subtotals are applied,outline button number ________ displays the entire list.

Accepted Answer

The answer of When subtotals are applied,outline button number ________...

Question 6

Which of the following is the best tool for analyzing employee performance over a period of time?

Accepted Answer

A) Data table 
B) PivotTable 
C) Subtotals 
D) Outline 
A) Data table 
B) PivotTable 
C) Subtotals 
D) Outline

Question 7

Match between columns
                        Premises: Update Link
Edit Link
Open Link
Linked Object
Paste Link

Accepted Answer

The Answer of can make modifications within Word and retrieves is...

Question 8

Match between columns
                        Premises: Round function
IsNull function
IIF function
Nesting functions

Accepted Answer

The Answer of using one function within another function and is...

Question 9

Match the following grouping button with the corresponding description:
I.1
II.2
III.3
IV.4
V.+
A.Collapse outline to display the grand total only.
B.Displays subtotals by the main subtotal category,the secondary subtotal category,and the grand total.
C.Expand an outline group to see its details.
D.Display the entire list.
E.Display subtotals by the main subtotal category and the grand total.

Accepted Answer

The answer of Match the following grouping button with the...

Question 10

What is the default summary statistic for numerical fields in a PivotTable?

Accepted Answer

A) Average 
B) COUNT 
C) SUM 
D) STDEV 
A) Average 
B) COUNT 
C) SUM 
D) STDEV

Question 11

By default,PivotTables display aggregated data for each category.

Accepted Answer

A) True 
 B)False

Question 12

Match the following calculated field settings with the corresponding description:
I.Slicer
II.Filter
III.Calculated Field
IV.PivotChart
V.Slicer caption
A.An interactive graphical representation of the data in a PivotTable
B.Text that displays in the header at the top of the slicer window
C.A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
D.A user-defined field that does not exist in the original dataset
E.Excludes particular categories or values

Accepted Answer

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

Question 13

Once applied,slicers cannot be removed.

Accepted Answer

A) True 
 B)False

Question 14

Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force?

Accepted Answer

A) % of Column Total 
B) % of Row Total 
C) Running Total 
D) % of Grand Total 
A) % of Column Total 
B) % of Row Total 
C) Running Total 
D) % of Grand Total

Question 15

In a PivotTable Fields task pane,the ________ subdivides data into one or more additional categories.

Accepted Answer

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

Question 16

Which of the following is not a calculation that can be completed with the SUBTOTAL function?

Accepted Answer

A) Average 
B) Count 
C) Min 
D) Index 
A) Average 
B) Count 
C) Min 
D) Index

Question 17

________ is the process of analyzing large volumes of data,using advanced statistical techniques,and
identifying trends and patterns in the data.

Accepted Answer

The answer of ________ is the process of analyzing large...

Question 18

The Subtotal feature creates a(n)________,a hierarchical structure of data.

Accepted Answer

The answer of The Subtotal feature creates a(n)________,a hierarchical structure...

Question 19

Which is the best tool for managing multiple filters within a PivotTable?

Accepted Answer

A) Slicers 
B) Refreshing the data 
C) PivotChart 
D) Sorting 
A) Slicers 
B) Refreshing the data 
C) PivotChart 
D) Sorting

Question 20

A(n)________ could be used to determine the most productive employee over an extended period of time.

Accepted Answer

The answer of A(n)________ could be used to determine the...

Exam 5: Subtotals Pivot-tables and Pivot-charts

Once applied,subtotals cannot be removed.

What does a slicer caption do?

What are the benefits of using Slicers over traditional filters?

Which of the following is not true regarding data mining?

When subtotals are applied,outline button number ________ displays the entire list.

Which of the following is the best tool for analyzing employee performance over a period of time?

What is the default summary statistic for numerical fields in a PivotTable?

By default,PivotTables display aggregated data for each category.

Once applied,slicers cannot be removed.

Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force?

In a PivotTable Fields task pane,the ________ subdivides data into one or more additional categories.

Which of the following is not a calculation that can be completed with the SUBTOTAL function?

________ is the process of analyzing large volumes of data,using advanced statistical techniques,and identifying trends and patterns in the data.

The Subtotal feature creates a(n)________,a hierarchical structure of data.

Which is the best tool for managing multiple filters within a PivotTable?

A(n)________ could be used to determine the most productive employee over an extended period of time.

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