Question 1

Which of the following is the path to the 'Add Chart Element' button?

Accepted Answer

A)  (PIVOTCHART TOOLS DESIGN tab | Analysis group) 
B)  (PIVOTCHART TOOLS DESIGN tab | Chart Layouts group) 
C)  (PIVOTCHART TOOLS FORMAT tab | Analysis group) 
D)  (PIVOTCHART TOOLS FORMAT tab | Options group) 
A)  (PIVOTCHART TOOLS DESIGN tab | Analysis group) 
B)  (PIVOTCHART TOOLS DESIGN tab | Chart Layouts group) 
C)  (PIVOTCHART TOOLS FORMAT tab | Analysis group) 
D)  (PIVOTCHART TOOLS FORMAT tab | Options group)

Question 2

In a PivotTable,____ fields correspond to summary values of original data across categories.

Accepted Answer

A)  category 
B)  index 
C)  data 
D)  summary 
A)  category 
B)  index 
C)  data 
D)  summary

Question 3

Which of the following is the path to the Move Chart button?

Accepted Answer

A)  (PIVOTCHART TOOLS LAYOUT tab | Location group) 
B)  (PIVOTCHART TOOLS FORMAT tab | Location group) 
C)  (PIVOTCHART TOOLS DESIGN tab | Location group) 
D)  (PIVOTCHART TOOLS OPTIONS tab | Location group) 
A)  (PIVOTCHART TOOLS LAYOUT tab | Location group) 
B)  (PIVOTCHART TOOLS FORMAT tab | Location group) 
C)  (PIVOTCHART TOOLS DESIGN tab | Location group) 
D)  (PIVOTCHART TOOLS OPTIONS tab | Location group)

Question 4

Which are types of fields used by PivotTables?

Accepted Answer

A)  summary 
B)  data 
C)  category 
D)  index 
A)  summary 
B)  data 
C)  category 
D)  index

Question 5

When you add a trendline to a chart,you can set the number of periods to forecast forward or backward in time.

Accepted Answer

A) True 
 B)False

Question 6

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

Accepted Answer

A)  SlicerChart 
B)  PivotChart 
C)  TrendChart 
D)  2-D Column chart 
A)  SlicerChart 
B)  PivotChart 
C)  TrendChart 
D)  2-D Column chart

Question 7

All summary functions are available from the shortcut menu of a cell in the PivotTable report.

Accepted Answer

A) True 
 B)False

Question 8

Using ____,a user with little knowledge of formulas,functions,and ranges can complete powerful what-if analyses of a set of data.

Accepted Answer

A)  trendlines 
B)  PivotTables 
C)  PivotCharts 
D)  slicers 
A)  trendlines 
B)  PivotTables 
C)  PivotCharts 
D)  slicers

Question 9

Which of the following is the path to the PivotChart menu?

Accepted Answer

Question 10

To create a PivotChart report directly from data,click the ____ button in the Charts group on the INSERT tab.

Accepted Answer

A)  Data Analysis 
B)  PivotTable 
C)  Charting 
D)  PivotChart 
A)  Data Analysis 
B)  PivotTable 
C)  Charting 
D)  PivotChart

Question 11

When you create a PivotTable report,Excel creates and associates a PivotChart with that PivotTable report.

Accepted Answer

A) True 
 B)False

Question 12

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

Accepted Answer

A)  PIVOTCHART TOOLS LAYOUT tab 
B)  PIVOTTABLE TOOLS DESIGN tab 
C)  PIVOTTABLE TOOLS LAYOUT tab 
D)  PIVOTCHART TOOLS DESIGN tab 
A)  PIVOTCHART TOOLS LAYOUT tab 
B)  PIVOTTABLE TOOLS DESIGN tab 
C)  PIVOTTABLE TOOLS LAYOUT tab 
D)  PIVOTCHART TOOLS DESIGN tab

Question 13

PivotTable fields can be one of three types: data,summary,and category.

Accepted Answer

A) True 
 B)False

Question 14

To add data to a PivotTable,select field check boxes in the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

Question 15

Using a(n)trendline on certain Excel charts allows you to illustrate an underlying tendency of how one set of data is changing in relation to another set of data._________________________

Accepted Answer

A) True 
 B)False

Question 16

You can filter the PivotTable report by ____.

Accepted Answer

A)  Total 2014 Sales 
B)  Revenue Venue 
C)  Total 2015 Sales 
D)  Average 2014 Sales 
A)  Total 2014 Sales 
B)  Revenue Venue 
C)  Total 2015 Sales 
D)  Average 2014 Sales

Question 17

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

Accepted Answer

A)  Sum 
B)  Varp 
C)  StdDev 
D)  Product 
A)  Sum 
B)  Varp 
C)  StdDev 
D)  Product

Question 18

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

Accepted Answer

A)  Slicers 
B)  Trenders 
C)  Charters 
D)  Markers 
A)  Slicers 
B)  Trenders 
C)  Charters 
D)  Markers

Question 19

Charts with ____ are often reformatted to start the vertical axis at a number other than zero.

Accepted Answer

A)  data layouts 
B)  indices 
C)  trendlines 
D)  baselines 
A)  data layouts 
B)  indices 
C)  trendlines 
D)  baselines

Question 20

Which of the following is the path to the Field List button?

Accepted Answer

Which of the following is the path to the 'Add Chart Element' button?

In a PivotTable,____ fields correspond to summary values of original data across categories.

Which of the following is the path to the Move Chart button?

Which are types of fields used by PivotTables?

When you add a trendline to a chart,you can set the number of periods to forecast forward or backward in time.

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

All summary functions are available from the shortcut menu of a cell in the PivotTable report.

Using ____,a user with little knowledge of formulas,functions,and ranges can complete powerful what-if analyses of a set of data.

Which of the following is the path to the PivotChart menu?

To create a PivotChart report directly from data,click the ____ button in the Charts group on the INSERT tab.

When you create a PivotTable report,Excel creates and associates a PivotChart with that PivotTable report.

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

PivotTable fields can be one of three types: data,summary,and category.

To add data to a PivotTable,select field check boxes in the PivotTable Fields task pane.

Using a(n)trendline on certain Excel charts allows you to illustrate an underlying tendency of how one set of data is changing in relation to another set of data._________________________

You can filter the PivotTable report by ____.

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

Charts with ____ are often reformatted to start the vertical axis at a number other than zero.

Which of the following is the path to the Field List button?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 8: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Which of the following is the path to the 'Add Chart Element' button?

In a PivotTable,____ fields correspond to summary values of original data across categories.

Which of the following is the path to the Move Chart button?

Which are types of fields used by PivotTables?

When you add a trendline to a chart,you can set the number of periods to forecast forward or backward in time.

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

All summary functions are available from the shortcut menu of a cell in the PivotTable report.

Using ____,a user with little knowledge of formulas,functions,and ranges can complete powerful what-if analyses of a set of data.

Which of the following is the path to the PivotChart menu?

To create a PivotChart report directly from data,click the ____ button in the Charts group on the INSERT tab.

When you create a PivotTable report,Excel creates and associates a PivotChart with that PivotTable report.

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

PivotTable fields can be one of three types: data,summary,and category.

To add data to a PivotTable,select field check boxes in the PivotTable Fields task pane.

Using a(n)trendline on certain Excel charts allows you to illustrate an underlying tendency of how one set of data is changing in relation to another set of data._________________________

You can filter the PivotTable report by ____.

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

Charts with ____ are often reformatted to start the vertical axis at a number other than zero.

Which of the following is the path to the Field List button?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters