ITE 140 Exam 2
Field names
Column titles from source data forming categories of data for PivotTable
CSV file
Comma-separated values file
Arrange All
Command to tile open Excel windows
Criteria
Conditions in logical function or filter
Criteria range
Defines filter criteria
Database
Organized collection of related facts
What is the command to update a PivotTable?
Refresh.
List
Series of rows containing related data with columns
Field
Single piece of information for every record
Descending
Sorted from Z to A, highest to lowest, or latest to earliest
Compound filter
A filter that uses more than one condition—and one that uses comparison operators.
Custom filter
Applies complex criteria to a column
Values area
Area for numeric/financial data in PivotTable
Filters area
Area in lower portion of PivotTable Fields pane to position fields for filtering PivotTable report
Columns area
Area to position fields displayed as columns in PivotTable report
What is the Rows area in a PivotTable?
Area to position fields displayed as rows.
What is a relationship in Excel?
Association between tables sharing a common field.
Field button
Button on PivotChart to choose a filter and change displayed data
Filtering button
Button on slicer to select item for filtering
Clear Filter
Button to remove a filter
What is meant by 'Record All'?
Categories of data for a person, place, event, thing, or idea.
What is meant by 'Source data'?
Data for a PivotTable formatted in columns and rows.
Cell style
Defined set of formatting characteristics
What is a Slicer in Excel?
Easy-to-use filtering control with buttons.
Primary key
Field used to uniquely identify a record in an Access table
Comma delimited file
File type with commas between cell contents
Advanced filter
Filter with 3+ criteria or computed criteria
PivotChart
Graphical representation of data in PivotTable report
End-of-paragraph mark
Indicates end of row in CSV file
PivotTable
Interactive Excel report summarizing and analyzing large amounts of data
Filter
Limit display of data to specific information
Area section
Lower portion of PivotTable Fields pane
AutoFilter menu
Menu to filter by values, format, or criteria
Data model
Method of incorporating data from multiple tables into Excel worksheet
And comparison operator
Operator requiring all criteria to be true
Associated PivotTable report
PivotTable report in a workbook represented in a PivotChart
Detail data
Subtotaled and summarized rows
Comparison operators
Symbols to evaluate values for criteria
Ascending
Text sorted A to Z, numbers lowest to highest
Compound criteria
The use of two or more criteria on the same row—all conditions must be met for the records to be included in the results.
What is a Slicer header?
Top of a slicer indicating the category of slicer items.
Field section
Upper portion of PivotTable Fields pane containing fields from source data
Custom list
User-defined sort order
PivotTable Fields pane
Window listing fields from source data for use in PivotTable and area to arrange fields
Active area
Worksheet area with data