Question 1

PivotTables are ____ by nature.

Accepted Answer

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

Question 2

A(n) _________________________ report must always be associated with a PivotTable report.

Accepted Answer

The answer of A(n) _________________________ report must always be associated...

Question 3

Some features of PivotTables and PivotCharts are disabled when a workbook is in compatibility mode.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A field containing computational values based on data in other fields.

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 6

By default, a PivotChart report will be created on its own chart sheet in a workbook.

Accepted Answer

A) True 
 B)False

Question 7

The +/- buttons ____ a field across categories.

Accepted Answer

A)  add and subtract 
B)  expand and collapse 
C)  multiply and divide 
D)  none of the above 
A)  add and subtract 
B)  expand and collapse 
C)  multiply and divide 
D)  none of the above

Question 8

-You can filter the PivotTable report shown in the accompanying figure by ____.

Accepted Answer

A)  Total 2014 Sales 
B)  Department and Style 
C)  Total 2015 Sales 
D)  Average 2014 Sales 
A)  Total 2014 Sales 
B)  Department and Style 
C)  Total 2015 Sales 
D)  Average 2014 Sales

Question 9

To apply a sheet tab color, you can press and hold or right-click a sheet tab, point to _________________________, and then click a color in the color grid.

Accepted Answer

The answer of To apply a sheet tab color, you...

Question 10

In a PivotTable, you use the filter button to specify how to filter the data; after you create a(n) _________________________, you can perform the same filtering task in one step.

Accepted Answer

The answer of In a PivotTable, you use the filter...

Question 11

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 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An interactive view of worksheet 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

PivotTables are ____ by nature.

A(n) _________________________ report must always be associated with a PivotTable report.

Some features of PivotTables and PivotCharts are disabled when a workbook is in compatibility mode.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A field containing computational values based on data in other fields.

By default, a PivotChart report will be created on its own chart sheet in a workbook.

The +/- buttons ____ a field across categories.

-You can filter the PivotTable report shown in the accompanying figure by ____.

To apply a sheet tab color, you can press and hold or right-click a sheet tab, point to _________________________, and then click a color in the color grid.

In a PivotTable, you use the filter button to specify how to filter the data; after you create a(n) _________________________, you can perform the same filtering task in one step.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An interactive view of worksheet data.

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

PivotTables are ____ by nature.

A(n) _________________________ report must always be associated with a PivotTable report.

Some features of PivotTables and PivotCharts are disabled when a workbook is in compatibility mode.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A field containing computational values based on data in other fields.

By default, a PivotChart report will be created on its own chart sheet in a workbook.

The +/- buttons ____ a field across categories.

-You can filter the PivotTable report shown in the accompanying figure by ____.

To apply a sheet tab color, you can press and hold or right-click a sheet tab, point to _________________________, and then click a color in the color grid.

In a PivotTable, you use the filter button to specify how to filter the data; after you create a(n) _________________________, you can perform the same filtering task in one step.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An interactive view of worksheet data.

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