COMP 242 Excel Chapter 5
And operator
The operator that requires each and every one of the comparison criteria that you specify must be true
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.
Comparison operator
The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values.
Extract area
The area where you place the results when copying the results of a filter to another location in a worksheet.
Arrange all
The command that tiles all open program windows on the screen.
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
Criteria
The term used for conditions that you specify that must be matched for the record to be included in the search results.
Find
The command to find and select specific text, formatting, or type of information within a workbook quickly
XPS
The file type developed by Microsoft that is a visual representation of a document
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.
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
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
Theme
A pre-designed set of colors, fonts, lines, and fill effects that look good together
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.
Query
The term that refers to asking a question of the data in a database.
Sort
To organize data in a particular order
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.
Descending order
Numbers sorted from highest to lowest
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.