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.
