BIM Voc. 15-24

A block of adjacent cells in a worksheet.

• Contiguous range

• Noncontiguous range

• Range

Cells in a worksheet that act as a block, but are not necessarily adjacent to each other.

• Cell

• Noncontiguous range

• Contiguous range

A block of cells in an Excel worksheet.

• row

• Colum

• Range

An instruction Excel uses to calculate a result.

• Formula

• SUM

• =

A built-in calculation used to add a range of values together.

• fx

• SUM Function

• Formula

A Windows feature that holds data or graphics that you cut or copy prior to pasting into another location

• Copy

• Paste

• Clipboard

The command used to place a copy of data from the selected cell or range on the Clipboard.

• Copy

• Clipbaord

• Double click

The command used to place data from the Clipboard to a location on the worksheet.

• flie

• Paste

• clip

A cell address that can change in a copied formula, so the new address is expressed

in relation to the cell containing the copied

formula.

• Noncontiguous range

• Contiguous range

• Relative Reference

A cell address in a formula that will not change when you copy the formula to another location.

• Absolute Reference

• Relative reference

• Print titles