Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
29 Cards in this Set
- Front
- Back
Ascending order
|
Arrangement of labels alphabetically from A to Z and numbers from smallest to largest.
|
|
AutoFilter
|
An Excel tool that enables you to quickly filter or sort data.
|
|
Category field
|
A field that appears in a PivotTable as a row, column, or page.
|
|
Column field
|
A category field that appears in a PivotTable as a column
|
|
Conditional formatting
|
An Excel formatting tool that appears in a cell only when data in the cell meets conditions that you specify or is the result of a formula.
|
|
Custom AutoFilter
|
Excel feature that allows you to specify comparison operators other than those that are “equal to” the criteria specified in the filter records, filtering records that are greater than, less than, equal to and so on a specified value.
|
|
Data definition table
|
Table that defines and describes the fields that will be used to store data in a list.
|
|
Data field
|
In a PivotTable, the field that is used in reports such as salaries, sales, and costs.
|
|
Data form
|
An Excel dialog box that displays one record at a time and in which you can add, find, edit, and delete records in a list.
|
|
Descending order
|
Arrangement of labels in reverse alphabetical order from Z to A and numbers from largest to smallest.
|
|
Field
|
An attribute of a person, place, or thing; often used Excel lists, PivotTables, and database queries.
|
|
Field name
|
A unique label describing the contents of the data in the rows below it. The row containing field names is called the header row.
|
|
Filter
|
Specify which records to retrieve using specific criteria.
|
|
Header row
|
The row of filed names in a list. Although it often begins in row 1, the header row can begin in any row.
|
|
Insert row
|
The blank row that is displayed directly below the last row of data in a list range, identified by a blue asterisk appears inside the leftmost cell.
|
|
List
|
A collection of similar data stored in a structured manner-in rows and columns, such as lists of client, phone numbers, and transactions.
|
|
List range
|
Rows and columns contained within a list frame.
|
|
Page field
|
A category field that appears in a PivotTable as a page.
|
|
Page view
|
Allows you to filter the PivotTable so it displays summarized data for either a single field item or all field items.
|
|
PivotChart
|
A chart that contains the same elements as a regular chart but also contains field and items that can be added to, rotated, or removed to display different views of your data; must be associated with a PivotTable report in the same workbook.
|
|
PivotTable
|
An interactive table that enables you to group and summarize an Excel list into a concise, tabular format for easier reporting and analysis and for an alternative view of the data.
|
|
Primary sort field
|
The first, and sometimes the only, sort field.
|
|
Record
|
A collection of fields that relate to a person, place, or thing that can be displayed in a row of a database table or an Excel list.
|
|
Row field
|
In a PivotTable a category field for a row.
|
|
Search criteria
|
Conditions placed on fields that define the records to be displayed.
|
|
Secondary sort field
|
After sorting by one criterion, another criterion specified by using the Then by list arrow.
|
|
Sort field
|
The field used to arrange or order data. Also called sort key.
|
|
Sort key
|
The field used to arrange or order records. Also called sort field.
|
|
Total row
|
A row that can be added below the insert row whenever the list range is active. The word “Total” appears in the leftmost cell and provides you the opportunity to display some manner of subtotal formula for all columns in your list.
|