Flashcards in Test 2 B Deck (10):
The process of displaying a subset of rows in an excel table that meets the criteria you specify.
Separate areas of a worksheet when they are on the screen at the same time.
The division between the panes.
Enable you to specify various conditions in addition to those that were based on an "equals" criterion.
The fields that group the values in a 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.
Fields that contain summary data in a PivotTable.
A graphical representation of the data in a PivotTable.
An object used to filter a PivotTable or PivotChart.