Excel Ch 4

first column

applies a different format to the first column so that the row headings stand out. First Column formatting takes priority over Banded rows formatting.

last column

applies a different format to the last column so that the last column of data stands out; effective for aggregated data, such as grand totals per row. Last Column formatting takes priority over Banded rows formatting.

data bars

applies a gradient or solid fill bar in which the width of the bar represents the current cell's value compared relatively to other cells' values.

conditional formatting

applies special formatting to highlight or emphasize cells that meet specific conditions.

SUBTOTAL function

calculates an aggregate value, such as totals or averages, for displayed values in a range, table, or database

print area

the range of cells that will print.

print order

the sequence in which the pages are printed. By default, the pages print in this order: top-left section, bottom-left section, top-right section, and bottom-right section

filter button

Displays a filter button on the right side of each heading in the header row.

total row

Displays a total row when selected. Total row formatting takes priority over column formats.

banded columns

Displays alternate fill colors for even and odd columns to help distinguish fields.

banded rows

Displays alternate fill colors for even and odd rows to help distinguish records.

header row

Displays the header row (field names) when checked; removes field names when not checked. header row formatting takes priority over column formats

record

Each row in a table represents a _______, which is a collection of related data about one entity. For example, all data related to one particular transaction form a record in the Reid Furniture Store worksheet.

duplicate values

Formats cells that are duplicated in the selected range

equal to

Formats cells that are exactly like the data contained in the first selected cell.

unique values

Formats cells that are unique; that is, no other cell in the selected range contains the same data.

text contains

Formats cells that contain the text in the first selected cell.

top/bottom rules

Formats cells with values in the top 10 items, top 10%, bottom 10 items, bottom 10%, above average, or below average. You can change the exact values to format the top or bottom items or percentages, such as top 5 or bottom 15%

color scales

Formats different cells with different colors, assigning one color to the lowest group of values and another color to the highest group of values, with gradient colors to other values.

icon sets

Inserts an icon from an icon palette in each cell to indicate values compared to each other.

freezing

the process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset

freeze panes

Keeps both rows and columns above and to the left of the active cell visible as you scroll through a worksheek

freeze first column

Keeps only the first column visible as you scroll through a worksheet.

freeze top row

Keeps only the top row visible as you scroll through a worksheet

unqualified reference

The use of field headings without row references in a structured formula

table

a structured range that contains related data organized in a method that increases the capability to manage and analyze information.

structured reference

a tag or use of a table element, such as a field heading, as a reference in a formula.

table styles

control the fill color of the header row (the row containing field names) and rows of records. In addition, table styles specify bold and border lines.

total row

displays below the last row of records in an Excel table and enables you to dis-play summary statistics, such as a sum of values displayed in a column.

field

each column represents a _____, an individual piece of data, such as last names or quantities sold. Each field should represent the smallest possible unit of data. For example, instead of a Name field, separate name data into First Name and Last Name fields. Instead of one large address field, separate address data into Street Address, City, State, and ZIP Code fields.

filtering

the process of specifying conditions to display only those records that meet certain conditions

highlight cells rules

highlights cells with a fill color, font color, or border (such as Light red Fill with Dark red Text) if values are greater than, less than, between two values, equal to a value, or duplicate values; text that contains particular characters; or dates when a date meets a particular condition, such as In the last 7 day

page break

indicates where data will start on another printed page.

clear format

removes the conditional formatting from the selected range.

fully qualified structured reference

structured formula that includes references, such as table name

data structure

the organization method used to manage multiple data points within a dataset.

sorting

the process of arranging records by the value of one or more fields within a table. Sorting is not limited to data within tables; normal data ranges can be sorted as well.