CIS125S CH5

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.

Arrange All

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

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.

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.

Ascending

Values sorted from A to Z.

AutoFilter menu

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

Cell styles

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

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.

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.

Comparison operators

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

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.

Extract

To pull out multiple sets of data for comparison purposes.