BITS Chapter 4 Vocab

STUDY
PLAY

Terms in this set (...)

color scale
a conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells
conditional formatting
a set of rules that applies specific formatting to highlight or emphasize cells that meet specifications
data bar
a conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells
field
the smallest data element contained in a table, such as a first name, last name, address, and phone number
filtering
the process of specifying conditions to display only those records that meet those conditions
freezing
the process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset
icon set
a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range
page break
an indication of where data will start on another printed page
print area
the range of cells within a worksheet that will print
print order
the sequence in which pages are printed
record
a group of related fields representing one entity, such as data for one person, place, event, or concept
sorting
the process of listing records or text in a specific sequence, such as alphabetically by last name
structured reference
a tag or use of a table element, such as a field label, as a reference in a formula. Field labels are enclosed in square brackets, such as [Amounts] within the formula
SUBTOTAL function
a predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database
table
a structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns)
table style
the rules that control the fill color of the header row, columns, and records in a table
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 a sum or an average