Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

29 Cards in this Set

  • Front
  • Back
Ascending order
Arrangement of labels alphabetically from A to Z and numbers from smallest to largest.
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.
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.
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.
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.
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.
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.
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.