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

Accepted Answer

When you drag a field out of a PivotTable report in Excel, an "X" symbol appears attached to the pointer, indicating that the field is being removed from the report.

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

Accepted Answer

A PivotTable is a powerful tool in Excel that allows users to summarize and analyze large amounts of data interactively. It enables users to create a summary of the data based on multiple criteria, in a way that is easy to read and understand. PivotTables can also be used to identify trends, patterns, and relationships in the data.

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

Accepted Answer

The Field button on a PivotChart allows the user to choose a filter and thus change the data that is displayed in the chart. The Table button is used to switch between the PivotTable and PivotChart views. The Series button is used to change the series displayed on the chart. The Column button is used to format the columns in the PivotChart.

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

Accepted Answer

A slicer includes a slicer header that indicates the category of the slicer items. This header can be used to filter the data and make it easier to analyze specific categories.

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

Accepted Answer

The PivotTable Fields pane is the window that lists all the fields from the source data for use in a PivotTable and provides areas in which you can arrange the fields in the PivotTable. The Values area and Filters area are both areas within the PivotTable itself, and a PivotChart is a graphical representation of a PivotTable.

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

Accepted Answer

A PivotTable report combines large amounts of data from multiple sources and allows you to compare and analyze related totals. It automatically calculates and summarizes the data, making it easier to understand and draw insights from the information.

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

Accepted Answer

To reflect the new data in a PivotTable report, you must refresh it. Refreshing a PivotTable updates it with changes made to the underlying data without altering the PivotTable layout or format. It ensures that the report accurately reflects the current state of the data, including any new or deleted items. The other options, such as saving, reopening, or listing, do not modify the PivotTable or update it with new data.

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

Accepted Answer

The VALUES Area enables you to display various calculations, including average values, for the data in the PivotTable.

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

Accepted Answer

PivotTables allow you to easily view and analyze data in various arrangements, such as by category, date, or values. It also allows you to summarize large amounts of data into a more manageable format, displaying the total and average of values, etc.

Question 10

In a PivotTable,a single piece of information for every record is called a ________.
A)label
B)data
C)field
D)name

Accepted Answer

In a PivotTable, a single piece of information for every record is called a field. Labels are used to identify the fields or categories, while data is the numerical or quantitative values associated with each field. Name is not a relevant term in this context.

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

Accepted Answer

The FILTERS area is where you can position fields to use for filtering the PivotTable, allowing you to display a subset of the data in the PivotTable report. The COLUMNS area, ROWS area, and VALUES area are used for displaying data in the PivotTable report, not for filtering.

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

Accepted Answer

Slicers are specifically designed filtering controls that are usually associated with PivotTables. They provide an easy and interactive way to filter large amounts of data by allowing users to select one or more buttons that correspond to a specific category or subcategory. This enables users to quickly narrow down their data to specific subsets, without having to manually filter and sort through complex data sets.

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

Accepted Answer

A PivotTable report is the best choice for analyzing related totals, as it allows you to easily summarize and compare data by different factors. PivotTables can group, filter, and sort data, as well as display subtotals and totals for various fields. A PivotChart chart or report may also be useful for presenting this information in a visual format, but a PivotTable report is the most efficient way to analyze the underlying data.

Question 14

You can limit the display of data to specific information by using ________.
A)sorting
B)filtering
C)reporting
D)charting

Accepted Answer

Filtering allows you to select specific criteria to show only the data that meets those criteria, thus limiting the display of information to specific information. Sorting organizes data in a particular order, but does not limit the display of information to specific information. Reporting and charting are methods of presenting data, but do not limit the display of information to specific information.

Question 15

You can apply a ________ to the entire PivotTable report.
A)PivotStyle
B)PivotTable Style
C)PivotReport Style
D)PivotChart Style

Accepted Answer

The correct term for the design or formatting applied to a PivotTable report is "PivotTable Style". The other options listed are not valid terms used in Microsoft Excel.

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

Accepted Answer

Excel uses the column titles as field names to identify and categorize data within the worksheet. Row labels are used to identify and denote each row's content, while data labels are used to show the actual data values in a chart or graph. Report names are usually not used as a data category identifier in Excel.

Question 17

The default calculation in a PivotTable Report is to ________ the numeric data.
A)subtract
B)sum
C)average
D)count

Accepted Answer

The default calculation in a PivotTable Report is to sum the numeric data. This is because PivotTable Reports are commonly used to summarize large amounts of data, and summing the data provides a quick and easy way to see the total value of each category or grouping.

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

Accepted Answer

When a numeric field is added to a PivotTable, it is placed in the Values Area of the PivotTable field list. This is where any numerical values or calculations are displayed in the PivotTable. The other areas (Columns, Rows, and Filters) are used to organize and filter the data in the PivotTable, but the Values Area is where the actual data or calculations are displayed.

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

Accepted Answer

Non-numeric fields, such as text or date fields, are typically used to group or categorize the data in a PivotTable. These fields are best placed in the ROWS area, allowing users to see a breakdown of the data by category. The COLUMNS area is typically used for numeric fields that are being aggregated, while the VALUES area is used to display the results of those aggregations. The FILTER area is used to filter the data in the PivotTable based on specific criteria.

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

Accepted Answer

The ROWS area in the PivotTable layout section allows you to rearrange existing fields. The ROWS Values and ROWS Filters areas are for adding values and filters, respectively. The ROWS Headers area is for formatting the headers of each row in the PivotTable.

Quiz 7: Excell: Creating Pivottables and Pivotcharts

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

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

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 slicer includes a ________ that indicates the category of the slicer items.

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 PivotTable report ________ large amounts of data so you can analyze related totals.

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.

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

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

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

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.

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

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?

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

You can apply a ________ to the entire PivotTable report.

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

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

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

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

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