Question 1

PivotTables can be created from the ________ gallery.

Accepted Answer

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

Question 2

After basic creation,various formatting styles can be applied to a PivotTable.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following calculations cannot be completed with subtotal?

Accepted Answer

A) Average 
B) Standard Deviation 
C) Sum 
D) Max 
A) Average 
B) Standard Deviation 
C) Sum 
D) Max

Question 4

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

Accepted Answer

A) True 
 B)False

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

________ is a built-in add-in program in Excel 2013 that enables you to import millions of
rows of data from multiple data sources,create a relationship between two or more related
tables within one workbook,and maintain connections.

Accepted Answer

The answer of ________ is a built-in add-in program in...

Question 7

Filters can only be applied to PivotTables one at a time.

Accepted Answer

A) True 
 B)False

Question 8

Once applied,slicers cannot be removed.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: Slicer Styles
Arrange
Size
Slicer
Buttons

Accepted Answer

The Answer of Applies a style to the slicer by is...

Question 10

In a PivotTable Fields task pane,the ________ subdivides data into one or more additional categories.

Accepted Answer

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

Question 11

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 12

Once slicers are created additional Slicer Styles can be applied.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: Subtotal
Outline
Collapse
Expand
Grouping

Accepted Answer

The Answer of A hierarchical structure of data and A is...

Question 14

What is the default summary statistic for numerical fields in a PivotTable?

Accepted Answer

A) Average 
B) COUNT 
C) SUM 
D) STDEV 
A) Average 
B) COUNT 
C) SUM 
D) STDEV

Question 15

Connections are automatically created in PowerPivot.

Accepted Answer

A) True 
 B)False

Question 16

What does the Filters 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 17

Where is the command to insert a PivotTable located in the Ribbon?

Accepted Answer

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

Question 18

A(n)________ could be used to determine the most productive employee over an extended period of time.

Accepted Answer

The answer of A(n)________ could be used to determine the...

Question 19

The default numerical field calculation for a PivotTable is ________.

Accepted Answer

The answer of The default numerical field calculation for a...

Question 20

Which is the best tool for managing multiple filters within a PivotTable?

Accepted Answer

A) Slicers 
B) Refreshing the data 
C) PivotChart 
D) Sorting 
A) Slicers 
B) Refreshing the data 
C) PivotChart 
D) Sorting

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

PivotTables can be created from the ________ gallery.

After basic creation,various formatting styles can be applied to a PivotTable.

Which of the following calculations cannot be completed with subtotal?

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

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

________ is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections.

Filters can only be applied to PivotTables one at a time.

Once applied,slicers cannot be removed.

In a PivotTable Fields task pane,the ________ subdivides data into one or more additional categories.

Which of the following is not true about PivotTables?

Once slicers are created additional Slicer Styles can be applied.

What is the default summary statistic for numerical fields in a PivotTable?

Connections are automatically created in PowerPivot.

What does the Filters Area of a PivotTable do?

Where is the command to insert a PivotTable located in the Ribbon?

A(n)________ could be used to determine the most productive employee over an extended period of time.

The default numerical field calculation for a PivotTable is ________.

Which is the best tool for managing multiple filters within 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