|
Term
|
Definition
|
|
Ascending order
|
Text is arranged alphabetically from A to z and numbers are arranged from smallest to highest
|
|
AutoFilter
|
A feature that allows you to filter a list by clicking the AutoFilter list arrow
|
|
Category field
|
Fields used in a PivotTable and are used to group the values
|
|
Conditional formatting
|
Formatting that appears in a cell only when data in the cell meets conditions that you specify or is the result of a formula
|
|
Custom AutoFilters
|
Filters that allow you to specify relationships other than those that are “equal to” the criteria specified in the filter records.
|
|
Data fields
|
Fields used in a PivotTable
|
|
Data Form
|
A dialog box in which you can add, find, edit, and delete record in a list.
|
|
Descending order
|
Text is arranged in reverse alphabetical order and numbers are arranged from highest to lowest
|
|
Field
|
Each column in a list is a field and described some attribute or characteristic of a person, place, or thing.
|
|
Field name
|
A unique label describing the contents of the data in the rows below
|
|
Filtering
|
The process of displaying a subset of data in the list that meets the criteria
|
|
Header row
|
The row of field names in a list
|
|
Insert row
|
Consists of a blank row displayed directly below the last row of data in a list
|
|
List
|
A collection of similar data stored in a structure manner: in rows and columns
|
|
List Range
|
Consists of rows and column contained within the list frame
|
|
Page View
|
A feature that allows you to filter the PivotTable so it displays summarized data for either a single field item or all field items
|
|
PivotChart
|
A repot that contains the same elements as regular chart but also contains field and items that can be added to, rotated, or removed to display different views of your data
|
|
PivotTable
|
An interactive table that enables you to group and summarize an Excel list into a concise, tabular format for easier reporting and analysis
|
|
Primary sort field
|
The first sort field
|
|
Record
|
A collection of fields that describes a person, place, or thing
|
|
Search Criteria
|
Conditions placed on fields that define the records to be displayed
|
|
Sort field (sort keys)
|
The field you use to order data in a list
|
|
Total row
|
Provides you with the opportunity to calculate totals(sum, average, count, and so on) for all columns in the list
|
