BSAN FINAL CHAPTER 7

¡Supera tus tareas y exámenes ahora con Quizwiz!

A method of incorporating data from multiple, related tables into an Excel worksheet

Data model

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable

Field Section

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are

Field Buttons

The lower portion of the PivotTable Fields pane where you build the PivotTable report by rearranging and repositioning fields.

Layout Section

The field used to uniquely identify a record in an Access table

Primary Key

A process by which you can limit the display of data to only specific information

Filter

To prevent a user from making changes to an Excel worksheet, use the ___________ command so that the worksheet is not visible

Hide

One possible source of data for a PivotTable is a(n

Access database file

To work with multiple tables in Excel, a __________ must be created between the tables.

relationship

The data for a PivotTable should be in the format of a

List

An interactive Excel report that summarizes and analyzes large amounts of data

PivotTable

The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source

source data

A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.

PivotTable Fields Pane

easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way

Slicer

The top of a slicer that indicates the category of the slicer items

Slicer Header

An area to position fields that contain data that is summarized in a PivotTable or PivotChart report

VALUES area

The area in the layout section of the PivotTable Fields pane where data is summarized is the

VALUES area

The ____________ button removes a filter from a slicer

clear filter

PivotTable field names are formed from the source data's

column titles

Slicers are used to

filter data

A single piece of information for every record

Field

The column titles from source data that form categories of data for a PivotTable

Field Names

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

PivotChart

The command to update a worksheet to reflect new data.

Refresher

The ____________ is a report in a workbook that is graphically represented in a PivotChart.

Associated PivotTable

Data from an Excel workbook, an Access database, or imported from an external source such as a corporate database, a public data feed, or an analysis service can be incorporated in the ___________

Data Mode

The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the

FILTERS Area

To import data from Access into an Excel Data Model, use the __________ command.

Get External Data

A graphical representation of the data in a PivotTable.

PivotChart


Conjuntos de estudio relacionados

Management Ch.1 & Ch.2 Questions

View Set

Exam 2: Pneumothorax & Hemothorax (NCLEX)

View Set

CISSP all ISC2 chapters combined

View Set

Life & Health Law 1 (Chapter 26)

View Set