Chapter 5

List

A series of rows that contains related data that you can group by adding subtotals

Extract

The process of pulling out multiple sets of data for comparison purposes

HTML (Hypertext Markup Language)

a language that web browsers can interpret

Field

specific type of data such as name, employee number, or SS number that is stored in columns

active area

the area of the worksheet that contains data or has contained data

Wildcard

A character, for example the asterisk or question mark, 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.

Freeze Pane

A command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes.

Go To

A command that moves to a specific cell or range of cells that you specify.

Go To Special

A command that moves to cells that have special characteristics, for example, to cells that are blank or to cells that contain constants, as opposed to formulas.

Cell Style

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Sort Dialog Box

A dialog box in which you can sort data based on serval criteria at once, and that enables a sort by more than one column or row

AutoFilter Menu

A drop-down menu from which you can filter a column by a list of values, by a format, or by criteria.

Tab Delimited Tax File

A file type in which cells are separated by tabs; this type of file can be readily exchanged with various database programs

Comma Delimited File

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; also referred to as a CSV (comma separated values) file.

Custom Filter

A filter with which you can apply complex criteria to a single column.

Pane

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

Filtering

A process in which only the rows that meet the criteria display; rows that do not meet the criteria are hidden.

Custom List

A sort order that you can define.

Major Sort

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

And Comparison Operator

The comparison operator that requires each and every one of the comparison criteria to be true.

Or comparison operator

The comparison operator that requires only one of the two comparison criteria that you specify to be true.

.xlsx file name extension

The default file format used by Excel 2016 to save an Excel workbook

Extract Area

The location to which you copy records when extracting filtered rows.

Sort

The process of arranging data in a specific order

Query

a process of restricting records through the use of criteria conditions that will display records that will answer a question about the data

Scaling

the group of command by which you can reduce the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify

Find

A command that locates and selects specific text or formatting

CSV (comma-separated values) file

A file type in which the cells in each row are separated by commas and an end-of-paragraph mark at the end of each row; also referred to as a comma delimited file.

Advanced Filter

A filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria.

Record

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

Criteria Range

An area on your worksheet where you define the criteria for the filter, and that indicates how the displayed records are filtered

Database

An organized collection of facts related to a specific topic

Criteria

Conditions that you specify in a logical function or filter

Comparison Operators

Symbols that are used to evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria

Hyperlink

Text or graphics, when clicked, take you to another location in the worksheet, to another file, or to a webpage on the internet or on your organization's intranet

Split

The command that enables you to view separate parts of the same worksheet on your screen; splits the windows into multiple resizable panes to view distant parts of the worksheet at one time

Arrange All

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

Subtotal Command

The command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells.

Detail Data

The subtotaled rows that are totaled and summarized; typically adjacent to and either above or to the left of the summary data.

Ascending

The term that refers to the arrangement of text that is sorted alphabetically from A to Z, numbers, sorted from lowest to highest, or dates and times sorted from earliest to latest.

Descending

The term that refers to the arrangement of text that is sorted alphabetically from Z to A, numbers sorted from highest to lowest, or dates and times sorted from latest to earliest.

Compound Criteria

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.

PDF (Portable Document Format)

a file format by Adobe that creates a representation of electronic paper that displays your data on the screen as it would look when printed, but that cannot be easily changed