Excel Chapter 5: End of Chapter Quiz
Query
The term that refers to asking a question of the data in a database
Criteria
The term used for conditions that you specify that must be matched for the record to be included in the search results
AutoFilter menu
The term used for conditions that you specify that must be matched for the record to be included in the search results.
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.
PDF (portable document format)
The file type developed by Adobe Systems that is a visual representation of a document.
CSV (comma separated values file)
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.
Comparison operators
The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values.
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 comparison operator
The operator that requires each and every one of the comparison criteria that you specify must be true is the:
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 is:
HTML
A language web browsers can interpret
Go To
Command used to move to a specific cell or range of cells in a large worksheet
descending order
Numbers sorted from highest to lowest are sorted in:
extract area
The area where you place the results when copying the results of a filter to another location in the worksheet:
find
The command that locates and selects specific text, formatting, or type of information within a workbook quickly is:
Arrange All
The command that tiles all open program windows on the screen.
.xlsx
The default file format for Excel 2016:
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.
pane
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a:
theme
A predesigned set of colors, fonts, lines, and fill effects that look good together is a:
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:
custom list
A sort order that you can define is a:
major sort
A term sometimes used to refer to the first sort level in the Sort dialog box is:
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.
sort
To organize data in a particular order is to:
Extract
To pull out multiple sets of data for comparison purposes
Ascending
Values sorted from A to Z