Question 1

What is the name of the tab that appears in the Ribbon when a PivotTable is selected?

Accepted Answer

A) PivotTable Options 
B) PivotTable 
C) PivotTable Tools 
D) Analysis 
A) PivotTable Options 
B) PivotTable 
C) PivotTable Tools 
D) Analysis

Question 2

Which of the following tools is best suited for data mining and summarizing data?

Accepted Answer

A) Subtotal 
B) PivotTable 
C) Column chart 
D) Data table 
A) Subtotal 
B) PivotTable 
C) Column chart 
D) Data table

Question 3

Label filters such as "Does Not Equal" can be applied to a PivotTable.

Accepted Answer

A) True 
 B)False

Question 4

Where are the Expand Field and Collapse Field buttons located within the PivotTable Tools tab?

Accepted Answer

A) Filter group 
B) Calculations group 
C) Data group 
D) Active Field group 
A) Filter group 
B) Calculations group 
C) Data group 
D) Active Field group

Question 5

Which of the following tools is best suited for maximum control when creating an outline?

Accepted Answer

A) Subtotals 
B) PivotTable 
C) Grouping 
D) Slicers 
A) Subtotals 
B) PivotTable 
C) Grouping 
D) Slicers

Question 6

Which of the following is not true about PivotTables?

Accepted Answer

A) PivotTables are dynamic 
B) PivotTables can arrange data in columns or rows 
C) PivotTables can summarize data 
D) PivotTables can Auto Refresh data 
A) PivotTables are dynamic 
B) PivotTables can arrange data in columns or rows 
C) PivotTables can summarize data 
D) PivotTables can Auto Refresh data

Question 7

Match between columns
                        Premises: SmartArt
WordArt
pull quote
drawing shapes
Link two text boxes

Accepted Answer

The Answer of add three-dimensional effects and a sentence to is...

Question 8

Match the following calculated field settings with the corresponding description
I.PivotTable Styles
II.Calculated field
III.Slicer caption
IV.PivotTable Fields task pane
V.Quick Analysis gallery
A.A user-defined field that does not exist in the original dataset
B.Contains two sections that allow for the editing of a PivotTable
C.A method of creating a PivotTable within a worksheet
D.Text that displays in the header at the top of the slicer window
E.Controls bold formatting,font colors,shading colors,and border lines of a PivotTable.

Accepted Answer

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

Question 9

Match between columns
                        Premises: Date arithmetic
Date formatting
Date function
DatePart function

Accepted Answer

The Answer of affects the date's display without changing the is...

Question 10

Once grouped,columns cannot be ungrouped.

Accepted Answer

A) True 
 B)False

Question 11

In what situations would you change the default data field calculations settings of a PivotTable?

Accepted Answer

The ability to vary data field calculati

Question 12

A(n)________ is an association between two related tables where both tables contain a related field of data,such as IDs.

Accepted Answer

The answer of A(n)________ is an association between two related...

Question 13

Which of the following is not a benefit of PowerPivot?

Accepted Answer

A) Import data from multiple sources 
B) Create relationships 
C) Create web queries 
D) Maintain connections 
A) Import data from multiple sources 
B) Create relationships 
C) Create web queries 
D) Maintain connections

Question 14

A(n)________ is an interactive graphical representation of the data in a PivotTable.

Accepted Answer

The answer of A(n)________ is an interactive graphical representation of...

Question 15

Match between columns
                        Premises: Copy and Paste
Copy and Paste Special will be moved into Word
Drag and Drop
Display as icon option in Paste Special
Create New tab in the Object dialog box

Accepted Answer

The Answer of allows access to the Paste link option is...

Question 16

Which tool is best suited for use with PivotTables when the data is based on multiple tables?

Accepted Answer

A) PivotCharts 
B) Slicers 
C) Sorting 
D) Filters 
A) PivotCharts 
B) Slicers 
C) Sorting 
D) Filters

Question 17

Which of the following is not one of the rules regarding good table design?

Accepted Answer

A) Use meaningful column labels 
B) Ensure data accuracy 
C) Avoid blank rows 
D) Insert rows to separate data 
A) Use meaningful column labels 
B) Ensure data accuracy 
C) Avoid blank rows 
D) Insert rows to separate data

Question 18

PowerPivot in an Excel add-in.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following options is the best tool when using a PivotTable that contains more data than you currently need?

Accepted Answer

A) Sorting 
B) Removing a value field 
C) Filtering 
D) Refreshing the data 
A) Sorting 
B) Removing a value field 
C) Filtering 
D) Refreshing the data

Question 20

A(n)________ is a small window containing one button for each unique item in a field so that you can filter the PivotTable quickly.

Accepted Answer

The answer of A(n)________ is a small window containing one...

Exam 5: Subtotals Pivot-tables and Pivot-charts

What is the name of the tab that appears in the Ribbon when a PivotTable is selected?

Which of the following tools is best suited for data mining and summarizing data?

Label filters such as "Does Not Equal" can be applied to a PivotTable.

Where are the Expand Field and Collapse Field buttons located within the PivotTable Tools tab?

Which of the following tools is best suited for maximum control when creating an outline?

Which of the following is not true about PivotTables?

Once grouped,columns cannot be ungrouped.

In what situations would you change the default data field calculations settings of a PivotTable?

A(n)________ is an association between two related tables where both tables contain a related field of data,such as IDs.

Which of the following is not a benefit of PowerPivot?

A(n)________ is an interactive graphical representation of the data in a PivotTable.

Which tool is best suited for use with PivotTables when the data is based on multiple tables?

Which of the following is not one of the rules regarding good table design?

PowerPivot in an Excel add-in.

Which of the following options is the best tool when using a PivotTable that contains more data than you currently need?

A(n)________ is a small window containing one button for each unique item in a field so that you can filter the PivotTable quickly.

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