Spreadsheet Terminology Review

The space formed by the intersection of a row and a column; the basic unit of a worksheet. (tiny rectangles on a spreadsheet)

• Spreadsheet

• Cell

• Worksheet

• Word Processor

A vertical group of cells in a worksheet identified by letters

• Row

• Column

• Table

• Chart

A horizontal group of cells in a worksheet identified by numbers

• Table

• Chart

• Row

• Column

The position of data within a cell

• Index

• Tab

• Indent

• Alignment

A selected worksheet cell that is ready for data entry.

• Cell name

• Active Cell

• Cell box

• Selector cell

An equation that calculates a new value using values currently on a spreadsheet.

• Formula

• Function

• Equatiot

A function that automatically adds the values in the cells directly above or to the left of the active cell.

• Average

• Max

• Autosum

• Min

To copy a cell’s contents and/or formatting into an adjacent cell or range. (Allows Excel to recognize patterns in formulas and functions)

• Paste & Review

• Fill

• Find & Replace

• Autocopy

A unique identifier for a cell which is formed by combining the cell's column letter and row number

• Cell reference

• Cell box

• Name box

• Name location

A prewritten formula that makes it easy to perform common calculations

• Function

• Formula

• Phase

• Autocalculate