Excel Chapter 5
Wildcard
A character such as the asterisk (*) used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records.
Cell styles
A set of formatting characteristics that you can apply to a cell.
Field
A single piece of information that is stored in every record.
Record
All of the categories of data pertaining to one person, place, thing, event, or idea.
Database
An organized collection of facts related to a specific topic.
Hyperlink
Colored and underlined text that, when clicked, takes you to another location in the worksheet, to another file, to a Web page on the Internet, or on your organization's intranet.
Comparison operator
The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values.
Arrange all
The command that tiles all open program windows on the screen.
Find
The command to find and select specific text, formatting, or type of information within a workbook quickly
Freeze Panes
The command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksheet.
The file type developed by Adobe Systems that is a visual representation of a document
XPS
The file type developed by Microsoft that is a visual representation of a document
Scaling
The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify
Additive
The term that describes filtering actions in which each additional filter that you apply is based on the current filter
Criteria
The term used for conditions that you specify that must be matched for the record to be included in the search results.
Sort
To organize data in a particular order
CSV file (comma separated values)
The file type that saves an Excel file so that there is a comma between each cell and a paragraph return at the end of each row.
Tab delimited text file
The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row.
And operator
The operator that requires each and every one of the comparison criteria that you specify must be true
Descending order
Numbers sorted from highest to lowest
Auto Filter menu
A menu of filtering commands that displays when you click one of the filter arrows in an Excel table.
Pane
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars
Query
The term that refers to asking a question of the data in a database.
Theme
A pre-designed set of colors, fonts, lines, and fill effects that look good together
Extract area
The area where you place the results when copying the results of a filter to another location in a worksheet.
