Excel Chp 5 - PDF

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.

Filter

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

HTML

A language web browsers can​ interpret:

AutoFilter menu

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

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:

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 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.

descending order

Numbers sorted from highest to lowest are sorted​ in:

Access database file

One possible source of data for a PivotTable is​ a(n):

extract area

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

Arrange All

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

Subtotal

The command that totals several rows of related data together.

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.

.xlsx

The default file format for​ Excel:

Comparison operators

The equal sign​ (=), greater than sign​ (>), or less than sign​ (<) used singly or in combinations to compare two values.

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:

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.

sort

To organize data in a particular order is​ to:

Ascending

Values sorted from A to Z.

Go To

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

PDF (Portable Document Format)

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

CSV file (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.

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:

Compound filter

A filter that uses more than one condition or that uses comparison operators.

Page Break Preview

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

Find

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

custom list

A sort order that you can define is​ a:

Sorted

Before subtotaling a​ list, the list must​ be:

Extract

To pull out multiple sets of data for comparison purposes.

major sort

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