17 terms

Excel Chapter 4

STUDY
PLAY

Terms in this set (...)

Data bar
A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells
Sorting
The process of listing records or text in a specific sequence, such as alphabetically by last name
Filtering
The process of specifying conditions to display only those records that meet those conditions
Conditional formatting
A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications
Record
A group of related fields representing one entity, such as data for one person, place, event, or concept
Table style
The rules that control the fill color of the header row, columns, and records in a table
Page break
An indication of where data will start on another printed page
Total row
A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as sum or an average
Color scale
A conditional format the displays a particular color based on the relative value of the cell contents to the other selected cells
Print order
The sequence in which the pages are printed
Structured reference
A tag or use of a table element, such as field label, as a reference in a formula. Field labels are enclosed in square brackets, such as [Amount] within the formula
Icon set
A conditional format the displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range
Print area
The range of cells within a worksheet that will print
SUBTOTAL function
A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a databse
Field
The smallest data element contained in a table, such as first name, last name, address, and phone number
Table
A structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns)
Freezing
The process of keeping rows and/or columns visible on screen when you scroll through a large dataset