Question 1

_________________________ can represent changes in one set of data with changes in another set of data.

Accepted Answer

The answer of _________________________ can represent changes in one set...

Question 2

The Field Headers button is located in the _________________________ group on the PIVOTTABLE TOOLS ANALYZE tab.

Accepted Answer

The answer of The Field Headers button is located in...

Question 3

When creating a PivotChart report, you select the chart type and subtype in the __________________________ dialog box.

Accepted Answer

The answer of When creating a PivotChart report, you select...

Question 4

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

Question 5

PivotTable rows are drawn from columns in the worksheet data.

Accepted Answer

A) True 
 B)False

Question 6

Today, data are increasingly available from a wide variety of sources and gathered with much more ease.

Accepted Answer

A) True 
 B)False

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Changes to category fields are correspondingly made to these in the PivotTable report.

Accepted Answer

A) trendline 
B) PivotTable report 
C) PivotChart report 
D) slicers 
E) forecasting
F)R-squared value
G)row fields
H)PivotTable fields
I)calculated field
J)column fields 
A) trendline 
B) PivotTable report 
C) PivotChart report 
D) slicers 
E) forecasting
F)R-squared value
G)row fields
H)PivotTable fields
I)calculated field
J)column fields

Question 8

Which of the following is the path to the +/- Buttons button?

Accepted Answer

Question 9

____ reports are visual representations of PivotTables.

Accepted Answer

A)  PivotChart 
B)  Slicer 
C)  Data Marker 
D)  Calculated field 
A)  PivotChart 
B)  Slicer 
C)  Data Marker 
D)  Calculated field

Question 10

When a field of interest is already part of the PivotTable, included in the ROWS area of the PivotTable Fields task pane, you can use filters associated with those fields in the PivotTable report, _________________________ filters, to view a subset of data.

Accepted Answer

The answer of When a field of interest is already...

Question 11

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 12

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

Accepted Answer

Question 13

Which are types of fields used by PivotTables?
a.
summary
b.
data
c.
category
d.
index

Accepted Answer

The answer of Which are types of fields used by...

Question 14

Before you add a trendline to a chart, you need to determine the data series to analyze.

Accepted Answer

A) True 
 B)False

Question 15

The default chart type for a PivotChart is a 2-D Line chart.

Accepted Answer

A) True 
 B)False

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Graphic objects used to filter data.

Accepted Answer

A) trendline 
B) PivotTable report 
C) PivotChart report 
D) slicers 
E) forecasting
F)R-squared value
G)row fields
H)PivotTable fields
I)calculated field
J)column fields 
A) trendline 
B) PivotTable report 
C) PivotChart report 
D) slicers 
E) forecasting
F)R-squared value
G)row fields
H)PivotTable fields
I)calculated field
J)column fields

Question 17

Filtering cannot happen independently of cell selection.

Accepted Answer

A) True 
 B)False

Question 18

-As shown in the accompanying figure, _________________________ are graphic objects that contain buttons you tap or click to filter the data in PivotTables and PivotCharts.

Accepted Answer

The answer of  
-As shown in the accompanying figure,...

Question 19

The summary function that calculates the number of data values in a PivotTable report is ____.

Accepted Answer

A)  Count 
B)  Product 
C)  Var 
D)  Count Nums 
A)  Count 
B)  Product 
C)  Var 
D)  Count Nums

Question 20

Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

_________________________ can represent changes in one set of data with changes in another set of data.

The Field Headers button is located in the _________________________ group on the PIVOTTABLE TOOLS ANALYZE tab.

When creating a PivotChart report, you select the chart type and subtype in the __________________________ dialog box.

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

PivotTable rows are drawn from columns in the worksheet data.

Today, data are increasingly available from a wide variety of sources and gathered with much more ease.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Changes to category fields are correspondingly made to these in the PivotTable report.

Which of the following is the path to the +/- Buttons button?

____ reports are visual representations of PivotTables.

When a field of interest is already part of the PivotTable, included in the ROWS area of the PivotTable Fields task pane, you can use filters associated with those fields in the PivotTable report, _________________________ filters, to view a subset of data.

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

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

Which are types of fields used by PivotTables? a. summary b. data c. category d. index

Before you add a trendline to a chart, you need to determine the data series to analyze.

The default chart type for a PivotChart is a 2-D Line chart.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Graphic objects used to filter data.

Filtering cannot happen independently of cell selection.

-As shown in the accompanying figure, _________________________ are graphic objects that contain buttons you tap or click to filter the data in PivotTables and PivotCharts.

The summary function that calculates the number of data values in a PivotTable report is ____.

Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

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

_________________________ can represent changes in one set of data with changes in another set of data.

The Field Headers button is located in the _________________________ group on the PIVOTTABLE TOOLS ANALYZE tab.

When creating a PivotChart report, you select the chart type and subtype in the __________________________ dialog box.

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

PivotTable rows are drawn from columns in the worksheet data.

Today, data are increasingly available from a wide variety of sources and gathered with much more ease.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Changes to category fields are correspondingly made to these in the PivotTable report.

Which of the following is the path to the +/- Buttons button?

____ reports are visual representations of PivotTables.

When a field of interest is already part of the PivotTable, included in the ROWS area of the PivotTable Fields task pane, you can use filters associated with those fields in the PivotTable report, _________________________ filters, to view a subset of data.

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

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

Which are types of fields used by PivotTables? a. summary b. data c. category d. index

Before you add a trendline to a chart, you need to determine the data series to analyze.

The default chart type for a PivotChart is a 2-D Line chart.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Graphic objects used to filter data.

Filtering cannot happen independently of cell selection.

-As shown in the accompanying figure, _________________________ are graphic objects that contain buttons you tap or click to filter the data in PivotTables and PivotCharts.

The summary function that calculates the number of data values in a PivotTable report is ____.

Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters