-
The command to set the column and row headings so that they remain on the screen while you scroll to others parts of the worksheet
Freeze Pane
-
The command that tiles all open program windows
Arrange All
-
A set of formatting characteristics that you can apply to a cell
Cell Styles
-
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
Hyperlink
-
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
CSV File
-
The file type that saves and Excel file with tabs between each cell in a row and a pargraph return at the end of each row
Tab Delimited Text File
-
An organized collection of facts related to a specific topic
Database
-
All of the categories of data pertaining to one person, place, thing, event, or idea
Record
-
A single piece of information that is stored in every record
Field
-
The term that referes to asking a question of the data in a database
Query
-
The term used for conditions that you specify that must be matched for the record to be included in the search results
Criteria
-
A menu filtering commands that displays when you click on of the filter arrws in an Excel table
AutoFilter Menu
-
The equal sign, greater than sign, or less thatn sign used singly or in combinations to compare two values
Comparison Operators
-
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
Wildcard
-
The area where you plae the results when copying the results of a filter to another location in the worksheet
Extract area
|
|