Test 2 B Flashcards Preview

Excel > Test 2 B > Flashcards

Flashcards in Test 2 B Deck (10):
1

Filtering

The process of displaying a subset of rows in an excel table that meets the criteria you specify.

2

Pane

Separate areas of a worksheet when they are on the screen at the same time.

3

Split Bar

The division between the panes.

4

Criteria Filters

Enable you to specify various conditions in addition to those that were based on an "equals" criterion.

5

Category Fields

The fields that group the values in a PivotTable.

6

PivotTable

An interactive table used to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis.

7

Value Fields

Fields that contain summary data in a PivotTable.

8

PivotChart

A graphical representation of the data in a PivotTable.

9

Slicer

An object used to filter a PivotTable or PivotChart.

10

Refresh

Updating a PivotTable to reflect the updated data.