Question 1

Match between columns
                        Premises: Quick Analysis gallery
PivotTable Fields task pane
PivotTable
Data mining
Subtotal

Accepted Answer

The Answer of Contains two sections that allow for the is...

Question 2

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 3

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

Accepted Answer

The Answer of To the end of all fields in is...

Question 4

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 5

Where are PowerPivot tools located on the Ribbon?

Accepted Answer

A) Insert tab 
B) Formulas tab 
C) Data tab 
D) Review tab 
A) Insert tab 
B) Formulas tab 
C) Data tab 
D) Review tab

Question 6

How are grouped columns ungrouped?

Accepted Answer

A) Select the entire worksheet and click Ungroup in the Subtotal group 
B) Select one cell in the grouped columns and click Ungroup in the Outline group 
C) Select all grouped columns and click Ungroup in the Outline group 
D) Right-click and select Ungroup 
A) Select the entire worksheet and click Ungroup in the Subtotal group 
B) Select one cell in the grouped columns and click Ungroup in the Outline group 
C) Select all grouped columns and click Ungroup in the Outline group 
D) Right-click and select Ungroup

Question 7

PivotTables can be created from the ________ tab in the Ribbon.

Accepted Answer

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

Question 8

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 9

When subtotals are applied the + that appears above the worksheet is the ________ button.

Accepted Answer

The answer of When subtotals are applied the + that...

Question 10

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 11

Match between columns
                        Premises: % of Column Total
% of Grand Total
% of Row Total
% of Parent Row Total
Running Total

Accepted Answer

The Answer of Displays values as running totals and Displays is...

Question 12

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...

Question 13

When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).

Accepted Answer

The answer of When the calculation options of a PivotTable...

Question 14

Slicer captions can be used to provide instructions to users.

Accepted Answer

A) True 
 B)False

Question 15

PivotTables automatically refresh data.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which of the following appears in the PivotTable Fields task pane?

Accepted Answer

A) Choose fields to add to report 
B) Filter area 
C) Plot area 
D) Rows area 
A) Choose fields to add to report 
B) Filter area 
C) Plot area 
D) Rows area

Question 18

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 19

Once completed,fields in PivotTables can be rearranged.

Accepted Answer

A) True 
 B)False

Question 20

Match between columns
                        Premises: Slicer caption
Calculated field
PivotTable Styles
Quick Analysis gallery
PivotTable Fields task pane

Accepted Answer

The Answer of Text that displays in the header at is...

Exam 22: Excel: 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 is the best tool for analyzing employee performance over a period of time?

Where are PowerPivot tools located on the Ribbon?

How are grouped columns ungrouped?

PivotTables can be created from the ________ tab in the Ribbon.

Which of the following is not a benefit of PowerPivot?

When subtotals are applied the + that appears above the worksheet is the ________ button.

What does a slicer caption do?

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

When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).

Slicer captions can be used to provide instructions to users.

PivotTables automatically refresh data.

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

Which of the following appears in the PivotTable Fields task pane?

What does the Values Area of a PivotTable do?

Once completed,fields in PivotTables can be rearranged.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters