Deck 7: Excell: Creating Pivottables and Pivotcharts

Question 1

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

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

Answer 1

B

Question 2

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

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

Answer 2

A

Question 3

Which of the following is a button on a PivotChart with an arrow to choose a filter,and thus change the data that is displayed in the chart?

A)Table button
B)Series button
C)Field button
D)Column button

Answer 3

C

Question 4

A slicer includes a ________ that indicates the category of the slicer items.

A)button header
B)filter header
C)category header
D)slicer header

Question 5

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.

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

Question 6

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

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

Question 7

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)refresh
B)list
C)save
D)reopen

Question 8

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

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

Question 9

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

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

Question 10

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

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

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.

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

Question 12

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

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

Question 13

Which of the following is a report that is useful when you want to analyze related totals,such as when you have a long list of numbers to sum and you want to compare several facts about each total?

A)PivotTable chart
B)PivotChart table
C)PivotChart report
D)PivotTable report

Question 14

You can limit the display of data to specific information by using ________.

A)sorting
B)filtering
C)reporting
D)charting

Question 15

You can apply a ________ to the entire PivotTable report.

A)PivotStyle
B)PivotTable Style
C)PivotReport Style
D)PivotChart Style

Question 16

Excel uses the column titles as the ________ for the categories of data.

A)report names
B)field names
C)data labels
D)row labels

Question 17

The default calculation in a PivotTable Report is to ________ the numeric data.

A)subtract
B)sum
C)average
D)count

Question 18

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

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

Question 19

By default,when a non-numeric field is added to a PivotTable,it is placed in the ________ area.

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

Question 20

In the PivotTable field section,you can rearrange existing fields by using which of the following areas in the layout section?

A)ROWS Values
B)ROWS Filters
C)ROWS Areas
D)ROWS Headers

Question 21

When you import data from Microsoft Access to Excel,the resulting association between tables of data that share a common field is called a ________.

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

Question 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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

Question 26

An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the ________.

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

Question 27

In Microsoft Access,each row is called a ________.

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

Question 28

The area to rearrange and reposition fields in the PivotTable is called the ________.

A)layout section
B)COLUMNS area
C)field section
D)column filters

Question 29

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.

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

Question 30

A PivotTable is an interactive Excel report that summarizes large amounts of data,allowing you to more easily analyze it.

Question 31

An area to position fields that you want to display as columns in the PivotTable is called ________.

A)COLUMNS Areas
B)COLUMNS Headers
C)COLUMNS Texts
D)COLUMNS Filters

Question 32

The data for a PivotTable formatted in columns and rows is called ________.

A)list
B)data series
C)source data
D)names

Question 33

To limit the display of data to only specific information is called ________.

A)refresh
B)update
C)slice
D)filter

Question 34

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.

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

Question 35

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

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

Question 36

A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.

A)cell ranges
B)named reports
C)field buttons
D)name ranges

Question 37

In Microsoft Access,each column is called a ________.

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

Question 38

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

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

Question 39

A chart that illustrates the relationship of each part to a whole is called a ________.

A)column chart
B)line chart
C)pie chart
D)bar chart

Question 40

An area to position fields that you want to display as rows in the PivotTable reports is called the ________.

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

Question 41

A Data Model enables you to use a PivotTable by using the data from multiple,related tables.

Question 42

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

Question 43

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

Question 44

The Clear Filter command removes a filter.

Question 45

From a PivotTable report,you can double-click a total to display the data on a new worksheet.

Question 46

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

Question 47

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

Question 48

A line chart shows the relationship of each part as a whole.

Question 49

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

Question 50

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

Question 51

In Microsoft Access,the field that uniquely identifies a record is the primary key.

Question 52

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

Question 53

A Microsoft Access database can contain only one table.

Question 54

A row label corresponds to a data series in a PivotTable report.

Question 55

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

Question 56

Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable report.

Question 57

A PivotChart displays data series,categories,data markers,and axes in the same manner as a standard chart.

Question 58

In a PivotTable report,the calculations can be modified.

Question 59

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

Question 60

You cannot update or refresh PivotTable report data.

Question 61

A PivotChart always has an associated ________ report and the two are interactive.

Question 62

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

Question 63

A list or table used to create a PivotTable or PivotChart report that comes from an Excel list or external database is called ________.

Question 64

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

Question 65

A(n)________ is an interactive Excel report that summarizes and analyzes large amounts of data.

Question 66

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

Question 67

A(n)________ is a system of integrating data from multiple and related tables into an Excel worksheet.

Question 68

When you create a PivotTable,Excel will use your column titles as the ________ names-or the categories of data within the PivotTable.

Question 69

A Microsoft ________ database stores data in rows and columns.

Question 70

A series of rows that contains related data with column titles in the first row is known as a(n)________.

Question 71

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

Question 72

The default calculation in a PivotTable report is to ________ the numeric data.

Question 73

Filters applied to a PivotChart report will be reflected in the ________ report.

Question 74

To analyze numeric data in depth and to answer unanticipated questions about worksheet data or an external data source,you can create a PivotTable ________.

Question 75

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

Question 76

You can ________ a PivotTable by using a search filter or by using slicers to limit the data displayed.

Question 77

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

Question 78

The filtering button that removes a filter is the ________ button.

Question 79

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

Question 80

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