Question 1

When setting custom calculation options in a PivotTable,what does Running 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 values as running totals 
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 values as running totals 
D) Displays values as: (value for the item)/ (value for the parent
Item on rows)

Question 2

Which of the following is not a PivotTable Subtotals option?

Accepted Answer

A) Do Not Show Subtotals 
B) Show All Subtotals at Bottom of Group 
C) Do Not Include Filtered Items in Totals 
D) Include Filtered Items in Totals 
A) Do Not Show Subtotals 
B) Show All Subtotals at Bottom of Group 
C) Do Not Include Filtered Items in Totals 
D) Include Filtered Items in Totals

Question 3

What tool is best suited for incorporating manufacturing information from one table with shipping information from a related table within one PivotTable?

Accepted Answer

A) Slicers 
B) PowerPivot 
C) Pivot Charts 
D) Grouping 
A) Slicers 
B) PowerPivot 
C) Pivot Charts 
D) Grouping

Question 4

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 5

What tool is best suited for organizing a spreadsheet of rental cars by category in order to be collapsed or expanded?

Accepted Answer

A) Grouping 
B) PivotTables 
C) Slicers 
D) Outlines 
A) Grouping 
B) PivotTables 
C) Slicers 
D) Outlines

Question 6

What are the benefits of using PivotTables over traditional data tables?

Accepted Answer

PivotTables have more robust calculation

Question 7

A(n)________ is a powerful,interactive data-mining feature that enables you to summarize and analyze data,especially helpful when working with large datasets.

Accepted Answer

The answer of A(n)________ is a powerful,interactive data-mining feature that...

Question 8

The default numerical field calculation for PivotTables is SUM.

Accepted Answer

A) True 
 B)False

Question 9

Once applied,subtotals cannot be removed.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: 1
+
4
3
2

Accepted Answer

The Answer of Expand an outline group to see its is...

Question 11

________ is the process of joining rows or columns of related data together into a single entity.

Accepted Answer

The answer of ________ is the process of joining rows...

Question 12

Where are PivotTable formatting tools located?

Accepted Answer

A) PivotTable Tools Analysis tab 
B) Data tab 
C) PivotTable Tools Design tab 
D) Insert tab 
A) PivotTable Tools Analysis tab 
B) Data tab 
C) PivotTable Tools Design tab 
D) Insert tab

Question 13

Where is the Subtotal command located on the Ribbon?

Accepted Answer

A) Insert tab 
B) Data tab 
C) View tab 
D) Backstage 
A) Insert tab 
B) Data tab 
C) View tab 
D) Backstage

Question 14

Multiple filters can be applied to a PivotTable.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Columns Area
Rows Area
Filters Area
PivotTable Fields task pane
Values Area

Accepted Answer

The Answer of Organizes and groups data into categories on is...

Question 16

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 17

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 18

Once created,a PivotTable cannot be edited.

Accepted Answer

A) True 
 B)False

Question 19

When editing a PivotTable where are values field settings edited?

Accepted Answer

A) PivotTable Design tab 
B) Data tab 
C) PivotTable Fields task pane 
D) Formulas tab 
A) PivotTable Design tab 
B) Data tab 
C) PivotTable Fields task pane 
D) Formulas tab

Question 20

Once a slicer is inserted into a worksheet which of the following actions cannot be performed?

Accepted Answer

A) Move the slicer 
B) Append the slicer 
C) Filter data 
D) Remove a filter 
A) Move the slicer 
B) Append the slicer 
C) Filter data 
D) Remove a filter

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

When setting custom calculation options in a PivotTable,what does Running Total calculate?

Which of the following is not a PivotTable Subtotals option?

What tool is best suited for incorporating manufacturing information from one table with shipping information from a related table within one PivotTable?

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

What tool is best suited for organizing a spreadsheet of rental cars by category in order to be collapsed or expanded?

What are the benefits of using PivotTables over traditional data tables?

A(n)________ is a powerful,interactive data-mining feature that enables you to summarize and analyze data,especially helpful when working with large datasets.

The default numerical field calculation for PivotTables is SUM.

Once applied,subtotals cannot be removed.

________ is the process of joining rows or columns of related data together into a single entity.

Where are PivotTable formatting tools located?

Where is the Subtotal command located on the Ribbon?

Multiple filters can be applied to a PivotTable.

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

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

Once created,a PivotTable cannot be edited.

When editing a PivotTable where are values field settings edited?

Once a slicer is inserted into a worksheet which of the following actions cannot be performed?

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