Question 1

In Microsoft Access,each column is called a ________.

Accepted Answer

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

Question 2

Another term for viewing or summarizing data in a PivotTable is known as ________ the information around to get varying views of the data.

Accepted Answer

pivoting

Question 3

A slicer includes a slicer header that specifies the category of the slicer items.

Accepted Answer

A) True 
 B)False  True

Question 4

You cannot update or refresh PivotTable report data.

Accepted Answer

A) True 
 B)False

Question 5

By using a PivotTable,you can show the same data in a table in ________.

Accepted Answer

A) more than one arrangement 
B) a summarized fashion 
C) large amount of cells 
D) field names 
A) more than one arrangement 
B) a summarized fashion 
C) large amount of cells 
D) field names

Question 6

In Microsoft Access,the field used to uniquely identify a record is the ________.

Accepted Answer

The answer of In Microsoft Access,the field used to uniquely...

Question 7

In the PivotTable Field List,you can rearrange existing fields by using one of the four areas at the bottom of the layout section.

Accepted Answer

A) True 
 B)False

Question 8

You can filter and change the values of the data in a PivotChart report by using the grey ________ buttons that display on the chart.

Accepted Answer

The answer of You can filter and change the values...

Question 9

In Microsoft Access,each row is a ________ where all the categories of data pertaining to one person,place,event,thing,or idea is stored.

Accepted Answer

The answer of In Microsoft Access,each row is a ________...

Question 10

Most of the formatting that has been practiced in standard charts works the same way in a PivotChart.

Accepted Answer

A) True 
 B)False

Question 11

The ________ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of the data in the PivotTable report.

Accepted Answer

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

Question 12

You can arrange and hide worksheets in a multi-sheet workbook.

Accepted Answer

A) True 
 B)False

Question 13

The source data for a PivotTable can come from any external source in any format.

Accepted Answer

A) True 
 B)False

Question 14

To update the contents of a PivotTable or PivotChart report to reflect changes to the underlying source data,you would ________ the data.

Accepted Answer

The answer of To update the contents of a PivotTable...

Question 15

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

Accepted Answer

A) Business Intelligence tool 
B) report tool 
C) Data Model 
D) table tool 
A) Business Intelligence tool 
B) report tool 
C) Data Model 
D) table tool

Question 16

When getting external data from Microsoft Access,in the Select Table dialog box,select the Enable selection of multiple tables check box,and then click the ________ check box to select all of the tables in the database.

Accepted Answer

A) List 
B) Field 
C) Text 
D) Name 
A) List 
B) Field 
C) Text 
D) Name

Question 17

Which of the following areas of a PivotTable field list enables you to display average values?

Accepted Answer

A) ROWS Area 
B) FILTERS Areas 
C) COLUMN Areas 
D) VALUES Area 
A) ROWS Area 
B) FILTERS Areas 
C) COLUMN Areas 
D) VALUES Area

Question 18

You can create a data model by getting external data from Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 19

A ________ can import data from an Excel workbook,from a Microsoft Access database,or from an external source such as a corporate database,a public data feed,or an analysis service.

Accepted Answer

A) Business Intelligence tool 
B) report tool 
C) Data Model 
D) table tool 
A) Business Intelligence tool 
B) report tool 
C) Data Model 
D) table tool

Question 20

The Clear Filter command removes a filter.

Accepted Answer

A) True 
 B)False

In Microsoft Access,each column is called a ________.

Another term for viewing or summarizing data in a PivotTable is known as ________ the information around to get varying views of the data.

A slicer includes a slicer header that specifies the category of the slicer items.

You cannot update or refresh PivotTable report data.

By using a PivotTable,you can show the same data in a table in ________.

In Microsoft Access,the field used to uniquely identify a record is the ________.

In the PivotTable Field List,you can rearrange existing fields by using one of the four areas at the bottom of the layout section.

You can filter and change the values of the data in a PivotChart report by using the grey ________ buttons that display on the chart.

In Microsoft Access,each row is a ________ where all the categories of data pertaining to one person,place,event,thing,or idea is stored.

Most of the formatting that has been practiced in standard charts works the same way in a PivotChart.

The ________ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of the data in the PivotTable report.

You can arrange and hide worksheets in a multi-sheet workbook.

The source data for a PivotTable can come from any external source in any format.

To update the contents of a PivotTable or PivotChart report to reflect changes to the underlying source data,you would ________ the data.

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

When getting external data from Microsoft Access,in the Select Table dialog box,select the Enable selection of multiple tables check box,and then click the ________ check box to select all of the tables in the database.

Which of the following areas of a PivotTable field list enables you to display average values?

You can create a data model by getting external data from Microsoft Access.

A ________ can import data from an Excel workbook,from a Microsoft Access database,or from an external source such as a corporate database,a public data feed,or an analysis service.

The Clear Filter command removes a filter.

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

In Microsoft Access,each column is called a ________.

Another term for viewing or summarizing data in a PivotTable is known as ________ the information around to get varying views of the data.

A slicer includes a slicer header that specifies the category of the slicer items.

You cannot update or refresh PivotTable report data.

By using a PivotTable,you can show the same data in a table in ________.

In Microsoft Access,the field used to uniquely identify a record is the ________.

In the PivotTable Field List,you can rearrange existing fields by using one of the four areas at the bottom of the layout section.

You can filter and change the values of the data in a PivotChart report by using the grey ________ buttons that display on the chart.

In Microsoft Access,each row is a ________ where all the categories of data pertaining to one person,place,event,thing,or idea is stored.

Most of the formatting that has been practiced in standard charts works the same way in a PivotChart.

The ________ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of the data in the PivotTable report.

You can arrange and hide worksheets in a multi-sheet workbook.

The source data for a PivotTable can come from any external source in any format.

To update the contents of a PivotTable or PivotChart report to reflect changes to the underlying source data,you would ________ the data.

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

When getting external data from Microsoft Access,in the Select Table dialog box,select the Enable selection of multiple tables check box,and then click the ________ check box to select all of the tables in the database.

Which of the following areas of a PivotTable field list enables you to display average values?

You can create a data model by getting external data from Microsoft Access.

A ________ can import data from an Excel workbook,from a Microsoft Access database,or from an external source such as a corporate database,a public data feed,or an analysis service.

The Clear Filter command removes a filter.

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