| A | B |
|---|
| Arrow keys | Enters the data and then selects the next cell in the direction of the arrow key. Used to scroll the worksheet. |
| Cell | Where a row and column intersect. A cell is identified by its column letter and row number. For example, C3. |
| Cell cursor | Solid outline around a cell that is used to indicate the selected cell. |
| Cell reference | A cell name used in a formula. |
| Column | Vertical line of data identified by a letter. |
| Date | Data in the form of a calendar date (i.e. 9/5/02). |
| Enter key | Enters data and then selects the next cell in the column. |
| Escape key | Cancels data entry and restores the cell's original contents. |
| Fill handle | Used to copy a cell's contents to adjacent cells. |
| Formula | Mathematical statement used to calculate values. A formula must always begin with an equal sign. For example, =C5+D7+E8 is a formula. |
| Function | Performs common calculations and return a single value. The formula =SUM(B3:B8) contains a function. |
| Highlighted block | Adjacent spreadsheet cells that have been selected. Formatting commands can be applied to a highlighted block, affecting every cell in the selection. |
| Label | Words or characters stored in a cell that cannot be used in calculations. |
| Order of operations | The rules the computer uses to evaluate the priority of the operators. |
| Pointing | Clicking on a cell to specify its cell reference in a formula. |
| Range | Adjacent cells in a row or column. B3:B8 is a range. |
| Relative cell reference | A cell reference that when copied reflects the row or column it has been copied to. |
| ROUND | Function that changes a value by rounding it to a specific number of decimal places. |
| Row | Horizontal line of data identified by a number. |
| Selected cell | The spreadsheet cell containing the cell cursor as indicated by a solid outline. |
| Source cell | The cell whose contents are to be copied using the Fill command. |
| Spreadsheet | Rows and columns of data on which calculations can be performed. |
| Tab key | Enters data and then selects the next cell in the row. |
| Time | Data in the form of a time (i.e. 12:30 PM). |
| Values | Numeric data that can be stored in cells and used in calculations. |
| Workbook | An Excel spreadsheet file. |
| Argument | Cell references enclosed in parentheses that are used by a function to perform the calculations. |
| AVERAGE | Function that adds the values of the cells in a range and divides the result by the number of cells in the range. |
| Boundary | The bar separating the column letters at the top of the spreadsheet. |
| Circular reference | An error that occurs when a formula references the cell it is stored in. |
| Column headings | The column letter at the top of each column. |
| Formula bar | Area near the top of the spreadsheet window that displays the contents of the selected cell. |
| Gridlines | Solid lines that mark off the rows and columns in a spreadsheet. |
| Microsoft Excel | A spreadsheet application in the Microsoft Office package. |
| Name box | Located near the top of the spreadsheet window. Displays the location of the cell cursor. |
| Row headings | The row number at the left of each row. |
| Scroll bars | Used to display columns and rows not currently displayed. |
| Spreadsheet | Rows and columns of data on which calculations can be performed. |
| SUM | Function that adds the values in a range of cells. |
