Excel ch 5 quiz

The default file format for Excel 2013:

.xlsx

PDF (Portable Document Format)

A multi-platform file format developed by Adobe Systems. A PDF file captures document text, fonts, images, and even formatting of documents from a variety of applications.

comparison operator

symbol which indicates the relationship between two values

The term used for conditions that you specify that must be matched for the record to be included in the search results.

criteria

Numbers sorted from highest to lowest are sorted in?

descending order

CSV file

A file that contains comma-separated values.

Arrange All

The command that tiles all open program windows on the screen.

Freeze Panes

To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.

The file type developed by Microsoft that is the visual representation of the document is?

XPS

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

theme

query

to ask

The command to find and select specific text, formatting, or type of information within a workbook quickly is?

to find

extract

to pull out by force

All of the categories of data pertaining to one person, place, thing, event, or idea.

to record

Ascending

Values sorted from A to Z

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

Detail comparison operator

A set of formatting characteristics that you can apply to a cell

Cell Styles

Hyperlink

Colored and underlined text that, when clicked, will take you to another link

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

Pane

AutoFilter menu

A menu of filtering commands that displays when you click one of the filter arrows in an Excel table.

cell style

A set of formatting traits that has been given a name.

Wildcard

A special character that represents other characters in a search.

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

Active area

The use of two or more criteria on the same row - all conditions must be met for the records to be included in the results

Advanced filter

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

Go to

The term that describes filtering actions in which each additional filter that you may apply is based on the current filter is:

Scaled

To organize data in a particular order is a?

Sort

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

Database

an organized body of related information

A single piece of information that is stored in every record and represented by a column in a table.

field

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