Excel chp 4 - PDF

Ace your homework & exams now with Quizwiz!

Field section

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.

Clear Filter

The​ ____________ button removes a filter from a slicer.

Values area

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

associated PivotTable

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

Get Data

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

Slicer

​Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data in an interactive way.

Field names

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

relationship

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

Field buttons

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

Filters area

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:

list

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

Source data

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

Primary key

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

Hide

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

filter data

Slicers are used​ to:

Layout section

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

PivotTable

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

column titles

PivotTable field names are formed from the source​ data's:

Access database file

One possible source of data for a PivotTable is​ a(n):

Slicer header

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

pie

​A(n) __________ chart illustrates the relationship of each part to a whole.

PivotTable Fields pane

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

PivotChart

A graphical representation of the data in a PivotTable.

Data model

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

Filter

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

Field

A single piece of information for every record.

Refresh

The command to update a PivotTable to reflect new data.


Related study sets

PrepU: Ch. 10 Leadership, Managing and Delegating

View Set

PEDs Chapt 5 Growth and Development of the Preschooler

View Set

American Strengths and Weaknesses

View Set