Excel Vocabulary Pt 1

A cell is the intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet.

• Cell

• Active Cell

• Cell address or cell reference

• Formula bar

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

• Cell

• Active Cell

• Cell address or cell reference

• Formula bar

The location of a cell in a worksheet as identified by its column letter and row number, such as A1.

• Cell

• Active Cell

• Cell address or cell reference

• Formula bar

The active cell is the current cell. There is a green border around the active cell.

• Cell

• Active Cell

• Cell address or cell reference

• Formula bar

Tabs appear at the bottom of the workbook window, which display the name of each worksheet.

• Sheet tabs

• Workbook

• Worksheet

• Blank worksheet

The work area for entering and calculating data made up of columns and row separated by guidelines (light gray lines). Also called a spreadsheet.

• Sheet tabs

• Workbook

• Worksheet

• Blank worksheet

An Excel file with one or more worksheets.

• Sheet tabs

• Workbook

• Worksheet

• Blank worksheet

A new, empty workbook contains one worksheet (sheet).

• Sheet tabs

• Workbook

• Worksheet

• Blank worksheet

An instruction Excel uses to calculate a result.

• Formula

• Range

• SUM Function

• Name Box

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

• Formula

• Range

• SUM Function

• Name Box