Excel Chapter 4 Flashcards
A conditional format that displays horizontal gradient or solid fill indicating the cells relative value compared to other selected cells
Data bar
Listing records or text in a specific sequence
Sorting
Specifying conditions to display only records that meet those conditions
Filtering
A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications
Conditional formatting
A group of fields representing one entity, such as data for one person, place, event or concept
Record
The rules that control the fill colour of the header row, columns and records in a table
Table style
An indication where data will start on another printed page
Page break
A table row that appears below the last row of records in a table and display summary or aggregate statistics
Total row
A conditional format that displays a specific colour based on the relative value of the cell contents to the other selected cells
Colour scale
The sequence in which the pages are printed
Print order
A tag or use of a table element, such a a field label, as a reference in a formula
Structured reference
Symbols or signs that classify data into three, four or five categories based on the values in a range
Icon set
A range of cells in a worksheet that will print
Print area
A predefined formula that calculates and aggregate value, such as totals, for values in a range, table or database
SUBTOTAL function
The smallest data element contained in a table, such as first name, address, phone number
Field
A structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns)
Table
Keeping rows and/or columns visible onscreen at all times ever when you scroll through a large data sheet
Freezing
