Exam 7: Excell: Creating Pivottables and Pivotcharts

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

Match the following terms with their meanings: i.field names II.list III.source data IV.field section v.layout section

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

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

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

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

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

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.

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

You can apply a ________ to the entire PivotTable report.

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

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

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

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

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

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

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 Microsoft ________ database stores data in rows and columns.

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

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