Spreadsheet Terminology

Front

Spreadsheet

Back

A grid of rows and columns in which you enter text, numbers, and the results of calculations. The purpose of spreadsheets is to solve problems that involve numbers.

Front

Workbook

Back

The file used to store worksheets. It contains a collection of related worksheets.

Front

Active cell

Back

The cell in the worksheet in which you can type data. It is highlighted with a thick border.

Front

Worksheet tabs

Back

Identify the worksheets in the workbook.

Front

Name box

Back

The cell reference area located below the Ribbon and displays the cell reference of the active cell. It identifies the active cell(s) by the letter of the column and the number of the row where they cross.

Front

Formula Bar

Back

Displays the contents of the active cell and is used to enter or edit text or numbers.

Front

Scroll Bars

Back

Used to move horizontally or vertically within a worksheet.

Front

Formula

Back

An equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.

Front

Active worksheet

Back

The worksheet that is displayed in the work area.

Front

Range

Back

A group of selected cells.