Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

The ________ is text that displays in the header at the top of the slicer window.

Accepted Answer

The answer of The ________ is text that displays in...

Question 5

A(n)________ should be performed before subtotaling data.

Accepted Answer

The answer of A(n)________ should be performed before subtotaling data....

Question 6

When formatting the data to compile a PivotTable,meaningful ________ should be used.

Accepted Answer

The answer of When formatting the data to compile a...

Question 7

You must sort in order to properly execute a subtotal.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

Match between columns
                        Premises: Calculated Field
PivotChart
Slicer
Slicer caption
Filter

Accepted Answer

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

Question 11

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 12

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 13

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 14

PowerPivot in an Excel add-in.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not true about a PivotChart?

Accepted Answer

A) They function independently from the PivotTable 
B) They can be formatted similar to a regular chart 
C) They update as the PivotTable updates 
D) They can be placed on a separate worksheet 
A) They function independently from the PivotTable 
B) They can be formatted similar to a regular chart 
C) They update as the PivotTable updates 
D) They can be placed on a separate worksheet

Question 16

Once grouped,columns cannot be ungrouped.

Accepted Answer

A) True 
 B)False

Question 17

More than one function can be applied per field in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 18

From which of the following locations can you create a PivotTable?

Accepted Answer

A) Data tab 
B) Quick Analysis gallery 
C) Backstage 
D) Formulas tab 
A) Data tab 
B) Quick Analysis gallery 
C) Backstage 
D) Formulas tab

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Exam 22: Excel: Subtotals, Pivot-tables, and Pivot-charts

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

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

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

The ________ is text that displays in the header at the top of the slicer window.

A(n)________ should be performed before subtotaling data.

When formatting the data to compile a PivotTable,meaningful ________ should be used.

You must sort in order to properly execute a subtotal.

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

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

Which of the following is not true regarding data mining?

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

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

PowerPivot in an Excel add-in.

Which of the following is not true about a PivotChart?

Once grouped,columns cannot be ungrouped.

More than one function can be applied per field in a PivotTable.

From which of the following locations can you create a PivotTable?

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

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

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