Question 1

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 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

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

Accepted Answer

A)   (CHART TOOLS DESIGN tab | Analysis group) 
B)   (CHART TOOLS DESIGN tab | Chart Layouts group) 
C)   (CHART TOOLS FORMAT tab | Analysis group) 
D)   (CHART TOOLS FORMAT tab | Options group) E) A) and D)
F) B) and C)

Question 4

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)  forecastingF) R-squared valueG) row fieldsH) PivotTable fieldsI) calculated fieldJ) column fieldsK) C) and J)
L) C) and H)

Question 5

-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 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

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

Accepted Answer

A)   category
B)   index
C)   data
D)   summaryE) None of the above
F) B) and C)

Question 8

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

Question 9

____ reports are visual representations of PivotTables.

Accepted Answer

A)   PivotChart
B)   Slicer
C)   Data Marker
D)   Calculated fieldE) B) and C)
F) C) and D)

Question 10

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

Accepted Answer

A)   (PIVOTTABLE TOOLS DESIGN tab | Show group) 
B)   (PIVOTTABLE TOOLS ANALYZE tab | Show group) 
C)   (PIVOTTABLE TOOLS FORMAT tab | Show group) 
D)   (PIVOTTABLE TOOLS DISPLAY tab | Reveal group) E) A) and B)
F) C) and D)

Question 11

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 NumsE) A) and D)
F) B) and D)

Question 12

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 13

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)  forecastingF) R-squared valueG) row fieldsH) PivotTable fieldsI) calculated fieldJ) column fieldsK) B) and E)
L) F) and J)

Question 14

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

Accepted Answer

A)   inventory
B)   pie
C)   scatter
D)   bubbleE) A) and B)
F) None of the above

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Filtering cannot happen independently of cell selection.

Accepted Answer

A) True 
 B)False

Question 18

PivotTable rows are drawn from columns in the worksheet data.

Accepted Answer

A) True 
 B)False

Question 19

_________________________ 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 20

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

Accepted Answer

A) True 
 B)False

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

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.

Correct AnswerverifiedShow Answer

Filtering cannot happen independently of cell selection.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

PivotTable rows are drawn from columns in the worksheet data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

____ reports are visual representations of PivotTables.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified