Excel Test Review

A single page or computerized spreadsheet in Excel

• Data group
• Workbook
• Worksheet
• Chart

These appear vertically and are identified by letters at the top of the worksheet window.

• Text
• Data sets
• Rows
• Columns

Appear horizontally and are identified by numbers on the left side of the worksheet window.

• Text
• Data sets
• Rows
• Columns

The intersection of a column and row which forms the basic unit of an excel spreadsheet where data is entered.

• Cell
• Name box
• Cell reference
• Data box

The cell surrounded by a thick green border in which data can be entered.

• Range
• Active cell
• Marquee
• Name box

Stored in the individual cells of a worksheet.

• Numbers/Values
• Stuff
• Text/Labels
• Data

Displays the cell reference of the active cell. Can also be used to navigate to a cell.

• Name box
• Range
• Formula bar
• Cell

Displays the data stored in the active cell. Displays a formula when the cell contains a calculated value. It can also be used to enter or edit data in a cell.

• Name box
• Function bar
• Formula bar
• Function library

Any set of characters containing a letter, hyphen, or space. Used to place titles on the worksheet, columns, and rows.

• Formula
• Text/Labels
• Numbers/Value
• Data

In Excel this can only contain the following characters: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, +, -, ( ), /, comma, period, $, %, E, and e.

• Formula
• Text/Labels
• Numbers/Value
• Functions