Chapter 5 Quiz

Ace your homework & exams now with Quizwiz!

A command that displays only the rows that meet a criteria.

Filter

A language web browsers can interpret

HTML

To pull out multiple sets of data for comparison purposes.

extract

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

find

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

record

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.

wildcard

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

extract area

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

pane

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

And comparison operator

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

AutoFilter Menu

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

Go To

A command that removes information from view in a worksheet.

Hide

The command on the Page Layout tab that enables you to repeat column or titles when printing a long worksheet.

Print Titles

The term that refers to asking a question of the data in a database.

Query

Before subtotaling a list, the list must be:

Sorted

The command that totals several rows of related data together.

Subtotal

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

arrange all

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

cell styles

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

criteria

A sort order that you can define is a:

custom list

An organized collection of facts related to a specific topic.

database

Numbers sorted from highest to lowest are sorted in:

descending order

A single piece of information that is stored in every record:

field

Colored and underlined text that you can click to go to a file, a location in a file, a webpage on the Internet, or a webpage on your organization's intranet.

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.

hyperlink

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

major sort

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

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 predesigned set of colors, fonts, lines, and fill effects that look good together is a:

theme

Values sorted from A to Z.

Ascending

A file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row.

CSV

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.

CSV file (comma separated values)

The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values.

Comparison operators

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.

Freeze panes

A widely used file format developed by Adobe Systems that lets you create a representation of electronic paper that displays your data on the screen as it would look when printed.

PDF

The file type developed by Adobe Systems that is a visual representation of a document.

PDF

The Excel View in which you can adjust paging in a worksheet.

Page Break Preview

A command that organize data in a particular order.

Sort

To organize data in a particular order is to:

sort


Related study sets

Counseling The CoDependent : A Christian Perspective. Utilizing Temperament Workbook

View Set

Ch. 15 Civil Liberties and Civil Rights

View Set

ЕГЭ устная часть задание 3

View Set