Question 1

Which of the following are NOT supported by PivotCharts?

Accepted Answer

A)  3-D cylinder 
B)  stock 
C)  XY (scatter) 
D)  bubble 
A)  3-D cylinder 
B)  stock 
C)  XY (scatter) 
D)  bubble B,C,D

Question 2

Which of the following chart types cannot include trendlines?

Accepted Answer

A)  pie 
B)  line 
C)  doughnut 
D)  column 
A)  pie 
B)  line 
C)  doughnut 
D)  column A,C

Question 3

All types of Excel charts can have a trendline added to them.

Accepted Answer

A) True 
 B)False  False

Question 4

When you need to analyze the data presented in PivotTables and PivotCharts,use a trendline to select the data to display and summarize.

Accepted Answer

A) True 
 B)False

Question 5

Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.

Accepted Answer

A) True 
 B)False

Question 6

A ____ is a visual way to show how two variables relate to each other.

Accepted Answer

A)  pivotline 
B)  guideline 
C)  timeline 
D)  trendline 
A)  pivotline 
B)  guideline 
C)  timeline 
D)  trendline

Question 7

Which of the following is the path to the Refresh button?

Accepted Answer

Question 8

The ____ value is a number from 0 to 1 that measures the strength of a trend.

Accepted Answer

A)  A-squared 
B)  P-squared 
C)  R-squared 
D)  T-squared 
A)  A-squared 
B)  P-squared 
C)  R-squared 
D)  T-squared

Question 9

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

Accepted Answer

A)  organizing 
B)  implementing 
C)  sorting 
D)  filtering 
A)  organizing 
B)  implementing 
C)  sorting 
D)  filtering

Question 10

A(n)____ is most often thought about in terms of how a value changes over time,but can also describe the relationship between two variables.

Accepted Answer

A)  trend 
B)  change 
C)  alignment 
D)  arrangement 
A)  trend 
B)  change 
C)  alignment 
D)  arrangement

Question 11

PivotTables are ____ by nature.

Accepted Answer

A)  static 
B)  inactive 
C)  attractive 
D)  dynamic 
A)  static 
B)  inactive 
C)  attractive 
D)  dynamic

Question 12

Excel treats ____ as graphic objects that can be moved,resized,and formatted.

Accepted Answer

A)  slicers 
B)  PivotTables 
C)  data markers 
D)  PivotCharts 
A)  slicers 
B)  PivotTables 
C)  data markers 
D)  PivotCharts

Question 13

In PivotTables,____ fields correspond to columns in the original data.

Accepted Answer

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

Question 14

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

Accepted Answer

A)  Add Slicer 
B)  Apply Slicer 
C)  Insert Slicer 
D)  Process Slicer 
A)  Add Slicer 
B)  Apply Slicer 
C)  Insert Slicer 
D)  Process Slicer

Question 15

Filtering cannot happen independently of cell selection.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  (PIVOTTABLE TOOLS DESIGN tab | Create Chart group) 
B)  (PIVOTTABLE TOOLS ANALYZE tab | Tools group) 
C)  (PivotChart Tools Options tab | Show group) 
D)  (PIVOTCHART TOOLS DESIGN tab | Create Chart group) 
A)  (PIVOTTABLE TOOLS DESIGN tab | Create Chart group) 
B)  (PIVOTTABLE TOOLS ANALYZE tab | Tools group) 
C)  (PivotChart Tools Options tab | Show group) 
D)  (PIVOTCHART TOOLS DESIGN tab | Create Chart group)

Question 17

You can change the view of a PivotTable report depending on what you want to analyze.

Accepted Answer

A) True 
 B)False

Question 18

You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is the path to the PivotTable button?

Accepted Answer

Question 20

You can add a trendline to all of the following EXCEPT a(n)____ chart.

Accepted Answer

A)  inventory 
B)  pie 
C)  scatter 
D)  bubble 
A)  inventory 
B)  pie 
C)  scatter 
D)  bubble

Which of the following are NOT supported by PivotCharts?

Which of the following chart types cannot include trendlines?

All types of Excel charts can have a trendline added to them.

When you need to analyze the data presented in PivotTables and PivotCharts,use a trendline to select the data to display and summarize.

Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.

A ____ is a visual way to show how two variables relate to each other.

Which of the following is the path to the Refresh button?

The ____ value is a number from 0 to 1 that measures the strength of a trend.

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

A(n)____ is most often thought about in terms of how a value changes over time,but can also describe the relationship between two variables.

PivotTables are ____ by nature.

Excel treats ____ as graphic objects that can be moved,resized,and formatted.

In PivotTables,____ fields correspond to columns in the original data.

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

Filtering cannot happen independently of cell selection.

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

You can change the view of a PivotTable report depending on what you want to analyze.

You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box.

Which of the following is the path to the PivotTable button?

You can add a trendline to all of the following EXCEPT a(n)____ chart.

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 are NOT supported by PivotCharts?

Which of the following chart types cannot include trendlines?

All types of Excel charts can have a trendline added to them.

When you need to analyze the data presented in PivotTables and PivotCharts,use a trendline to select the data to display and summarize.

Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.

A ____ is a visual way to show how two variables relate to each other.

Which of the following is the path to the Refresh button?

The ____ value is a number from 0 to 1 that measures the strength of a trend.

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

A(n)____ is most often thought about in terms of how a value changes over time,but can also describe the relationship between two variables.

PivotTables are ____ by nature.

Excel treats ____ as graphic objects that can be moved,resized,and formatted.

In PivotTables,____ fields correspond to columns in the original data.

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

Filtering cannot happen independently of cell selection.

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

You can change the view of a PivotTable report depending on what you want to analyze.

You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box.

Which of the following is the path to the PivotTable button?

You can add a trendline to all of the following EXCEPT a(n)____ chart.

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