Question 1

What is the best option for adding a calculation to a PivotTable that does not already exist?

Accepted Answer

A) Custom function 
B) Calculated field 
C) Function 
D) PivotTool Calculation 
A) Custom function 
B) Calculated field 
C) Function 
D) PivotTool Calculation B

Question 2

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

Accepted Answer

PivotTable Fields task pane

Question 3

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

Accepted Answer

relationship

Question 4

________ 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 5

To update the data in a PivotTable click ________ in the Data group.

Accepted Answer

The answer of To update the data in a PivotTable...

Question 6

Slicers can only be removed from the Analyze tab in the Ribbon.

Accepted Answer

A) True 
 B)False

Question 7

Custom slicers can be created in Excel.

Accepted Answer

A) True 
 B)False

Question 8

By default,PivotTables display aggregated data for each category.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

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

Question 11

Multiple subtotals can be applied to one data set.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following tools is best suited for complex cross referenced subtotals?

Accepted Answer

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

Question 13

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 14

Adding ________ to a preexisting data set can help you identify which disciplines and which areas contribute the highest revenue for a company and which disciplines and areas produce the lowest revenue.

Accepted Answer

The answer of Adding ________ to a preexisting data set...

Question 15

A PivotTable can be created from the Quick Analysis gallery.

Accepted Answer

A) True 
 B)False

Question 16

In a PivotTable Fields task pane,the ________ filters the data to display results based on particular conditions you set.

Accepted Answer

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

Question 17

When using subtotal,what does the 4th button of the outline levels do?

Accepted Answer

A) Collapses the outline to display the grand total only 
B) Displays subtotals by the main subtotal category and the grand total 
C) Displays the entire list 
D) Displays subtotals by the main subtotal category,the secondary
Subtotal category,and the grand total 
A) Collapses the outline to display the grand total only 
B) Displays subtotals by the main subtotal category and the grand total 
C) Displays the entire list 
D) Displays subtotals by the main subtotal category,the secondary
Subtotal category,and the grand total

Question 18

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 19

A(n)________ is a user-defined field that does not exist in the original dataset.

Accepted Answer

The answer of A(n)________ is a user-defined field that does...

Question 20

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

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

What is the best option for adding a calculation to a PivotTable that does not already exist?

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

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

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

To update the data in a PivotTable click ________ in the Data group.

Slicers can only be removed from the Analyze tab in the Ribbon.

Custom slicers can be created in Excel.

By default,PivotTables display aggregated data for each category.

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

Multiple subtotals can be applied to one data set.

Which of the following tools is best suited for complex cross referenced subtotals?

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

Adding ________ to a preexisting data set can help you identify which disciplines and which areas contribute the highest revenue for a company and which disciplines and areas produce the lowest revenue.

A PivotTable can be created from the Quick Analysis gallery.

In a PivotTable Fields task pane,the ________ filters the data to display results based on particular conditions you set.

When using subtotal,what does the 4th button of the outline levels do?

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

A(n)________ is a user-defined field that does not exist in the original dataset.

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

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