Acct 1120 Ch4 vocabulary

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

PivotChart

A graphical representation of the data in a Pivot Table.

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.

Pivot Table Fields pane

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

PivotChart

A(n) _____ displays data series, categories, data markers, and axes in the same manner as a standard chart.

Pie

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

Values area

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

Pivot Table

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

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:

Data Model

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 ______.

Slicer

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

Access database file

One possible source of data for a Pivot Table is a(n):

colum titles

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

Associated PivotTable report

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

Associated PivotTable

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

Clear Filter

The _____ button removes a filter from a slicer.

Values area

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

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:

Field names

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

Refresh

The command to update a PivotTable to reflect new data.

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.

Layout section

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

Slicer header

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

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.

Get Data

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

Hide

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

Slicers are used to:

filter data

Relationship

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


Kaugnay na mga set ng pag-aaral

Wordly Wise 3000 - Book 7 - Lesson 7

View Set

AP Psychology Unit 5 Progress Check MCQ

View Set

Ch.1-1 Nature of our Surroundings Matter and Energy Sources of Ionizing Radiation

View Set

Chp 6: Resistance Exercise for Impaired Muscle Performance

View Set