Question 1

When creating a PivotTable report,the active cell should be positioned ____.

Accepted Answer

A)  anywhere in the range that contains the data 
B)  in cell A1 
C)  anywhere outside the range that contains the data 
D)  There is no active cell in a PivotTable report. 
A)  anywhere in the range that contains the data 
B)  in cell A1 
C)  anywhere outside the range that contains the data 
D)  There is no active cell in a PivotTable report.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Which of the following are types of summary functions for PivotChart report and PivotTable report data analysis?

Accepted Answer

A)  Count 
B)  Var.p 
C)  Average 
D)  Count Nums 
A)  Count 
B)  Var.p 
C)  Average 
D)  Count Nums

Question 5

When the data in a PivotTable report is changed,any PivotChart reports built upon that PivotTable report update to reflect those changes.

Accepted Answer

A) True 
 B)False

Question 6

You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

Question 11

The summary function that calculates the smallest data value in a PivotTable report is ____.

Accepted Answer

A)  Varp 
B)  Min 
C)  Max 
D)  Average 
A)  Varp 
B)  Min 
C)  Max 
D)  Average

When creating a PivotTable report,the active cell should be positioned ____.

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

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

Which of the following are types of summary functions for PivotChart report and PivotTable report data analysis?

When the data in a PivotTable report is changed,any PivotChart reports built upon that PivotTable report update to reflect those changes.

You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.

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

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

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

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

The summary function that calculates the smallest data value in a PivotTable report is ____.

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

When creating a PivotTable report,the active cell should be positioned ____.

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

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

Which of the following are types of summary functions for PivotChart report and PivotTable report data analysis?

When the data in a PivotTable report is changed,any PivotChart reports built upon that PivotTable report update to reflect those changes.

You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.

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

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

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

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

The summary function that calculates the smallest data value in a PivotTable report is ____.

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