Excel Chapter 5
Wildcard
A character such as an asterisk(* ) used to search a field when you are uncertain of the value or when you want to widen the search to include more records.
The command to find and select specific text, formatting, or type of information within a workbook quickly is?
Find
Comparison operators
=,<,> 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 the 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 scroll to other parts of the worksheet.
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.
Query
The term that refers to asking a question of the data in a database.
Criteria
The term used for collections that you specify that must be matched for the record to be included in the search results.
CSV (comma separated values)
The file type that saves an Excel file so that there is comma between each cell and a paragraph return at the end of each row.
AutoFilter menu
A menu of filtering commands that display when you click one of the filter arrows in an Excel table.
Cell Style
A set of formatting characteristics that you can apply to a cell.
Field
A single piece of information that is stored in every record.
The term that describes filtering actions in which each additional filter that you apply is based on the current filter is?
Additive
Record
All the categories of data pertaining to one person, place, thing, event, or idea.
Database
An organized collection of facts related to a specific topic.
The operator that requires each and every one of the comparison criteria that you specify must be true is the?
And operator
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.
Numbers sorted from highest to lowest are sorted in?
Descending order
The file type developed by Adobe Systems that is a visual representation of a document is?
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a?
Pane
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 is?
Scaling
To organize data in a particular order is a?
Sort of
A predesigned set of colors, fonts, lines, and fill effects that look good together is a?
Theme
The file type developed by Microsoft that is the visual representation of the document is?
XPS
