chapter 4 cpas
Data Bar ✔✔A conditional format that displays a horizontal gradient or a 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 os 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 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 a sum or an average.
Color scale ✔✔A conditional format that 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 ✔✔Tag or use of a table element, such as a field label, as a reference in a
formula.
Icon set ✔✔Symbols or signs that classify data into three, four, or five categories based on the
values in a range.
Print area ✔✔The range of cells within a worksheet that will print.
Data Bar ✔✔A conditional format that displays a horizontal gradient or a 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 os 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 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 a sum or an average.
Color scale ✔✔A conditional format that 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 ✔✔Tag or use of a table element, such as a field label, as a reference in a
formula.
Icon set ✔✔Symbols or signs that classify data into three, four, or five categories based on the
values in a range.
Print area ✔✔The range of cells within a worksheet that will print.
