Excel Key Terms One


Terms in this set (...)

Active Cell
The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border
A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.
Cell Reference
The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.
A column is a vertical series of cells in a chart, table, or spreadsheet.
Column Heading
The lettered or numbered gray area at the top of each column. Click the column heading to select an entire column. To increase or decrease the width of a column, drag the line to the right of the column heading.
Formula Bar
A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.
Name Box
Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object.
Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.
A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. Rows are identified by numbers e.g. row 1, row 5
Row Heading
The numbered gray area to the left of each row. Click the row heading to select an entire row. To increase or decrease the height of a row, drag the line below the row heading.
Sheet Tab
a sheet tab, or worksheet tab is used to display the worksheet that a user is currently editing.
A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.
The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.