Question 1

If you change the underlying data on which a PivotTable report is based,you must also ________ or update the PivotTable to reflect the new data.

Accepted Answer

A) refresh 
B) list 
C) save 
D) reopen 
A) refresh 
B) list 
C) save 
D) reopen

Question 2

A PivotChart usually has an associated PivotTable and the two are interactive.

Accepted Answer

A) True 
 B)False

Question 3

When you import data from Microsoft Access to a PivotTable Report,the ________ displays on the right side of the worksheet.

Accepted Answer

A) PivotTable Fields pane 
B) PivotTable 
C) Data Model 
D) PivotChart 
A) PivotTable Fields pane 
B) PivotTable 
C) Data Model 
D) PivotChart

Question 4

A method of incorporating data from multiple,related tables into an Excel worksheet is a ________.

Accepted Answer

A) Data Model 
B) PowerPivot 
C) PowerView 
D) Data feed 
A) Data Model 
B) PowerPivot 
C) PowerView 
D) Data feed

Question 5

When a numeric field is added to a PivotTable,it is placed in the ________ area of the PivotTable field list.

Accepted Answer

A) COLUMNS Area 
B) FILTERS Area 
C) ROWS Area 
D) VALUES Area 
A) COLUMNS Area 
B) FILTERS Area 
C) ROWS Area 
D) VALUES Area

Question 6

In Microsoft Access,each row is called a ________.

Accepted Answer

A) relationship 
B) field 
C) primary key 
D) record 
A) relationship 
B) field 
C) primary key 
D) record

Question 7

Which of the following is an interactive Excel report that summarizes and helps analyze large amounts of data?

Accepted Answer

A) PivotTable 
B) PivotRow 
C) PivotChart 
D) PivotSection 
A) PivotTable 
B) PivotRow 
C) PivotChart 
D) PivotSection

Question 8

A graphical representation of the data in a PivotTable report is a PivotChart report.

Accepted Answer

A) True 
 B)False

Question 9

A(n)________ report is a graphical representation of the data in a PivotTable report.

Accepted Answer

The answer of A(n)________ report is a graphical representation of...

Question 10

________ are filtering controls with buttons that enable you to drill down through large amounts of data.

Accepted Answer

A) Slicers 
B) Data labels 
C) Data series 
D) Data Markers 
A) Slicers 
B) Data labels 
C) Data series 
D) Data Markers

Question 11

You can modify the data that displays in the PivotChart by dragging the ________ between areas in the PivotChart Fields list.

Accepted Answer

The answer of You can modify the data that displays...

Question 12

A field that is being removed from the PivotTable report is indicated by a(n)attached to the pointer as you drag ________.

Accepted Answer

A) no symbol 
B) X 
C) gray area 
D) delete button 
A) no symbol 
B) X 
C) gray area 
D) delete button

Question 13

To best represent large amounts of data,it is often helpful to filter the PivotTable.

Accepted Answer

A) True 
 B)False

Question 14

The ________ is a window that lists all the fields from the source data for us in a PivotTable and provides an areas in which you can arrange the fields in the PivotTable.

Accepted Answer

A) VALUES area 
B) FITLERS area 
C) PivotTable Fields pane 
D) PivotChart 
A) VALUES area 
B) FITLERS area 
C) PivotTable Fields pane 
D) PivotChart

Question 15

Slicers display as movable objects on your worksheet in the same manner as charts and shapes.

Accepted Answer

A) True 
 B)False

Question 16

A PivotTable report ________ large amounts of data so you can analyze related totals.

Accepted Answer

A) compares and calculates 
B) calculates and combines 
C) compares and contrasts 
D) combines and compares 
A) compares and calculates 
B) calculates and combines 
C) compares and contrasts 
D) combines and compares

Question 17

You can format a 3-D Pie PivotChart using the same techniques that you use to format a chart.

Accepted Answer

A) True 
 B)False

Question 18

In a PivotTable,a single piece of information for every record is called a ________.

Accepted Answer

A) label 
B) data 
C) field 
D) name 
A) label 
B) data 
C) field 
D) name

Question 19

The PivotTable report with data graphically represented in a PivotChart is that PivotChart's ________ PivotTable report.

Accepted Answer

The answer of The PivotTable report with data graphically represented...

Question 20

When you import data from Microsoft Access tables into an Excel data model,you establish a ________ between the Access tables and the Excel data model.

Accepted Answer

The answer of When you import data from Microsoft Access...

If you change the underlying data on which a PivotTable report is based,you must also ________ or update the PivotTable to reflect the new data.

A PivotChart usually has an associated PivotTable and the two are interactive.

When you import data from Microsoft Access to a PivotTable Report,the ________ displays on the right side of the worksheet.

A method of incorporating data from multiple,related tables into an Excel worksheet is a ________.

When a numeric field is added to a PivotTable,it is placed in the ________ area of the PivotTable field list.

In Microsoft Access,each row is called a ________.

Which of the following is an interactive Excel report that summarizes and helps analyze large amounts of data?

A graphical representation of the data in a PivotTable report is a PivotChart report.

A(n)________ report is a graphical representation of the data in a PivotTable report.

________ are filtering controls with buttons that enable you to drill down through large amounts of data.

You can modify the data that displays in the PivotChart by dragging the ________ between areas in the PivotChart Fields list.

A field that is being removed from the PivotTable report is indicated by a(n)attached to the pointer as you drag ________.

To best represent large amounts of data,it is often helpful to filter the PivotTable.

The ________ is a window that lists all the fields from the source data for us in a PivotTable and provides an areas in which you can arrange the fields in the PivotTable.

Slicers display as movable objects on your worksheet in the same manner as charts and shapes.

A PivotTable report ________ large amounts of data so you can analyze related totals.

You can format a 3-D Pie PivotChart using the same techniques that you use to format a chart.

In a PivotTable,a single piece of information for every record is called a ________.

The PivotTable report with data graphically represented in a PivotChart is that PivotChart's ________ PivotTable report.

When you import data from Microsoft Access tables into an Excel data model,you establish a ________ between the Access tables and the Excel data model.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters

Exam 7: Excell: Creating Pivottables and Pivotcharts

If you change the underlying data on which a PivotTable report is based,you must also ________ or update the PivotTable to reflect the new data.

A PivotChart usually has an associated PivotTable and the two are interactive.

When you import data from Microsoft Access to a PivotTable Report,the ________ displays on the right side of the worksheet.

A method of incorporating data from multiple,related tables into an Excel worksheet is a ________.

When a numeric field is added to a PivotTable,it is placed in the ________ area of the PivotTable field list.

In Microsoft Access,each row is called a ________.

Which of the following is an interactive Excel report that summarizes and helps analyze large amounts of data?

A graphical representation of the data in a PivotTable report is a PivotChart report.

A(n)________ report is a graphical representation of the data in a PivotTable report.

________ are filtering controls with buttons that enable you to drill down through large amounts of data.

You can modify the data that displays in the PivotChart by dragging the ________ between areas in the PivotChart Fields list.

A field that is being removed from the PivotTable report is indicated by a(n)attached to the pointer as you drag ________.

To best represent large amounts of data,it is often helpful to filter the PivotTable.

The ________ is a window that lists all the fields from the source data for us in a PivotTable and provides an areas in which you can arrange the fields in the PivotTable.

Slicers display as movable objects on your worksheet in the same manner as charts and shapes.

A PivotTable report ________ large amounts of data so you can analyze related totals.

You can format a 3-D Pie PivotChart using the same techniques that you use to format a chart.

In a PivotTable,a single piece of information for every record is called a ________.

The PivotTable report with data graphically represented in a PivotChart is that PivotChart's ________ PivotTable report.

When you import data from Microsoft Access tables into an Excel data model,you establish a ________ between the Access tables and the Excel data model.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters