Excel Chapter 5 Quiz A Questions

A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a

pane

The default file format for Excel 2016

.xlsx

The command that located and selects specific text, formatting, or type of information within a workbook quickly is

find

A term sometimes used to refer to the first sort level in a sort dialog box is

major sort

The page formatting that reduced the horizontal and vertical size of the printed data by a percentage or by the number of pages you specify

scaling

A predesigned set of colors, fonts, lines, and fill effects that look good together is a

theme

Command used to move to a specific cell or range of cells in a large worksheet

Go To

The area where you place the results when copying the results of a filter to another location in the worksheet

extract area

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

Tab delimited text file

A sort order that you can define is a

custom sort

The operator the requires each and every one of the comparison criteria that you must specify must be true is the

And comparison operator

A language web browsers can interpret

HTML

Numbers sorted from highest to lowest are sorted in

descending order

A single piece of information that is stored in every record

field

To organize data in a particular order is to

sort