Question 1

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 2

PivotChart reports often are used to represent changes in one set of data over time.

Accepted Answer

A) True 
 B)False

Question 3

If you tap or click outside of a PivotTable or PivotChart, the _________________________ will no longer be displayed.

Accepted Answer

The answer of If you tap or click outside of...

Question 4

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 
E)  None of the above 
A)  trendlines 
B)  PivotTables 
C)  PivotCharts 
D)  slicers 
E)  None of the above

Question 7

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Drawn from data in worksheet columns.

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 10

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 11

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 12

PivotTables are always based on a PivotChart.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Case 8-2
Last year, your cousin Margie started a small business selling crafting and needlework supplies to small retailers across the state. She has recorded her company's annual sales data totals in a worksheet indicating city, store, and product. Going forward, Margie needs to direct her limited resources toward promoting her top products and improving her business relationships with her top retailers. To do this, she needs to carefully analyze the first year's sales data.
-Margie gives you a call to thank you for your suggestions on analyzing the company's sales data. She tells you that she now needs to prepare some easy-to-understand visual aids based on the data for a meeting with her banker. You suggest that she ____.

Accepted Answer

A)  create one or more PivotChart reports based on the data; move each chart to its own chart sheet; print copies of each chart sheet for the meeting 
B)  bring you to the meeting so that you can explain the data 
C)  create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker 
D)  import the data totals into a text file and then print copies of the text file for the meeting 
A)  create one or more PivotChart reports based on the data; move each chart to its own chart sheet; print copies of each chart sheet for the meeting 
B)  bring you to the meeting so that you can explain the data 
C)  create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker 
D)  import the data totals into a text file and then print copies of the text file for the meeting

Question 15

When creating a(n) _________________________, you can use categories in the data to summarize different groups or totals.

Accepted Answer

The answer of When creating a(n) _________________________, you can use...

Question 16

PivotTables automatically update when you change the underlying data for the PivotTable report.

Accepted Answer

A) True 
 B)False

Question 17

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 18

A(n) _________________________ field in a PivotTable report is a field with values not entered as data, but determined by computation involving data in other fields.

Accepted Answer

The answer of A(n) _________________________ field in a PivotTable report...

Question 19

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

Accepted Answer

A)  (PIVOTCHART TOOLS LAYOUT tab | Show/Hide group) 
B)  (PIVOTCHART TOOLS DESIGN tab | Show/Hide group) 
C)  (PIVOTCHART TOOLS OPTIONS tab | Show/Hide group) 
D)  (PIVOTCHART TOOLS ANALYZE tab | Show/Hide group) 
A)  (PIVOTCHART TOOLS LAYOUT tab | Show/Hide group) 
B)  (PIVOTCHART TOOLS DESIGN tab | Show/Hide group) 
C)  (PIVOTCHART TOOLS OPTIONS tab | Show/Hide group) 
D)  (PIVOTCHART TOOLS ANALYZE tab | Show/Hide group)

Question 20

Tap or click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

Accepted Answer

A)  Options 
B)  Columns 
C)  Fields 
D)  PivotTable 
A)  Options 
B)  Columns 
C)  Fields 
D)  PivotTable

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

PivotChart reports often are used to represent changes in one set of data over time.

If you tap or click outside of a PivotTable or PivotChart, the _________________________ will no longer be displayed.

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

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

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

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Drawn from data in worksheet columns.

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

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.

PivotTables are always based on a PivotChart.

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

When creating a(n) _________________________, you can use categories in the data to summarize different groups or totals.

PivotTables automatically update when you change the underlying data for the PivotTable report.

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

A(n) _________________________ field in a PivotTable report is a field with values not entered as data, but determined by computation involving data in other fields.

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

Tap or click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

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

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

PivotChart reports often are used to represent changes in one set of data over time.

If you tap or click outside of a PivotTable or PivotChart, the _________________________ will no longer be displayed.

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

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

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

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Drawn from data in worksheet columns.

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

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.

PivotTables are always based on a PivotChart.

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

When creating a(n) _________________________, you can use categories in the data to summarize different groups or totals.

PivotTables automatically update when you change the underlying data for the PivotTable report.

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

A(n) _________________________ field in a PivotTable report is a field with values not entered as data, but determined by computation involving data in other fields.

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

Tap or click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

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