Excel Key Terms Number 1

AutoComplete

A feature used to complete an entry based on previous entries made in the column containing the active cell.

natural series

A formatted series of text or numbers

Label

A label is any cell entry other than a numeric value or a formula. A text entry in a cell is called a label. A range of values will often have a label to identify it.

Copy pointer

A tool that allows users to drag a cell or range of cells to a new location

Auto Fill

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

Formula bar

As you enter data in a cell, it simultaneously appears in the formula bar, which is located above the worksheet.

Range

Distance between highest and lowest scores in a set of data.

Selecting text

Highlighting text that is to be changed.

Paste

Inserts cut or copied data at the location of the cursor.

Fill handle

The small black square in the lower right corner of a selected cell

Copy

Transcribe

Cut

When you cut text from a document to either delete it or move it.

Keywords

Words or phrases that further describe the database

move pointer

a tool that allows users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells

Flash Fill

enables you to enter data in one or two cells to set an example, and Excel completes the data entry for you

Workbook properties

individual elements of information about workbook files that helps users search for and identify particular workbook files. Workbook properties can provide information such as who created a file, when a file was created or last modified, and whether or not a file has been reviewed and approved

Office Clipboard

stores the last 24 cut or copied items