Excel Chapter 5: End of Chapter Quiz
Already Passed
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.
Arrange All ✔✔The
...
Excel Chapter 5: End of Chapter Quiz
Already Passed
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.
Arrange All ✔✔The command that tiles all open program windows on the screen.
Cell Styles ✔✔A set of formatting characteristics that you can apply to a cell
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.
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.
PDF (portable document format) ✔✔The file type developed by Adobe Systems that is a visual
representation of a document.
Ascending ✔✔Values sorted from A to Z
Database ✔✔An organized collection of facts related to a specific topic
Record ✔✔All of the categories of data pertaining to one person, place, thing, event, or idea.
Criteria ✔✔The term used for conditions that you specify that must be matched for the record to
be included in the search results
Query ✔✔The term that refers to asking a question of the data in a database
AutoFilter menu ✔✔The term used for conditions that you specify that must be matched for the
record to be included in the search results.
Comparison operators ✔✔The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used
singly or in combinations to compare two values.
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.
Extract ✔✔To pull out multiple sets of data for comparison purposes
find ✔✔The command that locates and selects specific text, formatting, or type of information
within a workbook quickly is:
pane ✔✔A portion of a worksheet window bounded by and separated from other portions by
vertical or horizontal bars is a:
Go To ✔✔Command used to move to a specific cell or range of cells in a large worksheet
theme ✔✔A predesigned set of colors, fonts, lines, and fill effects that look good together is a:
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:
.xlsx ✔✔The default file format for Excel 2016:
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:
HTML ✔✔A language web browsers can interpret
sort ✔✔To organize data in a particular order is to:
descending order ✔✔Numbers sorted from highest to lowest are sorted in:
field ✔✔A single piece of information that is stored in every record:
custom list ✔✔A sort order that you can define is a:
And comparison operator ✔✔The operator that requires each and every one of the comparison
criteria that you specify must be true is the:
major sort ✔✔A term sometimes used to refer to the first sort level in the Sort dialog box is:
extract area ✔✔The area where you place the results when copying the results of a filter to
another location in the worksheet:
[Show More]
![Preview of [SOLVED] EDCO 740 / EDCO740 Quiz 1 (LATES 2021/2022 Graded A)](https://scholarfriends.com/storage/EDCO_740_Quiz_1.png)
