Term
|
Definition
| the selected cell displayed with a bold outline. Data can only be entered into an active cell. |
|
|
Term
|
Definition
| Cells that are next to each other |
|
|
Term
|
Definition
| Cells that are next to each other |
|
|
Term
|
Definition
| Enters data and then selects the next cell in the direction of the arrow key |
|
|
Term
|
Definition
| Enters data and then selects the next cell in the direction of the arrow key |
|
|
Term
|
Definition
| Enters data and then selects the next cell in the direction of the arrow key |
|
|
Term
|
Definition
| Function that adds the values of the cells range and divides the result by the number of cells in the range |
|
|
Term
|
Definition
| the bar seperating the column letters at the top of the worksheet. |
|
|
Term
|
Definition
| The intersection of a row and column. Each cell can store a single item of data |
|
|
Term
|
Definition
| The column letter and row number used to identify a cell, such as B3 |
|
|
Term
|
Definition
| An error that occurs when a formula references the cell it is stored in |
|
|
Term
|
Definition
| Letter at the top of the worksheet used to identify individual columns. |
|
|
Term
|
Definition
| Cancels data entry and restores the original contents of the cell. |
|
|
Term
|
Definition
| The solid square in the lower-right corner of a selected cell that is used to copy the contents of a cell to adjacent cells. |
|
|
Term
|
Definition
| Mathematical statement used to calculate a value. A formula must always begin with an equal sign.For example,= C5+D7+E8 is a formula |
|
|
Term
|
Definition
| Area near the top of the worksheet window that displays the contents of the active cell. |
|
|
Term
|
Definition
| Performs a calculation that results in a single value. The formula=SUM(B3:B8) contains the SUM funtion. |
|
|
Term
|
Definition
| Performs a calculation that results in a single value. The formula=SUM(B3:B8) contains the SUM funtion. |
|
|
Term
|
Definition
| Solid lines that mark off the rows and columns in a worksheet. |
|
|
Term
|
Definition
| Text stored in a cell that cannot be used in calculations. |
|
|
Term
|
Definition
| Located near the top of the worksheet window. Displays the cell reference of the active cell. |
|
|
Term
|
Definition
| Slection of two or more cells. |
|
|
Term
|
Definition
| A cell reference that when copied reflects the row or column it has been copied to. |
|
|
Term
|
Definition
| Function that changes a value by rounding it to a specific number of decimal places. |
|
|
Term
|
Definition
| The number down the left side of the worksheet used to identify indivdual rows. |
|
|
Term
|
Definition
| The number down the left side of the worksheet used to identify indivdual rows. |
|
|
Term
|
Definition
| The number down the left side of the worksheet used to identify indivdual rows. |
|
|
Term
|
Definition
| Used to display the three worksheets in the wordbook. |
|
|
Term
|
Definition
| Data displayed in rows and columns. |
|
|
Term
|
Definition
| Data displayed in rows and columns. |
|
|
Term
|
Definition
| Data displayed in rows and columns. |
|
|
Term
|
Definition
| Function that adds the values in a range of cells. |
|
|
Term
|
Definition
| numeric data that is stored in a cell that can be used calculations. |
|
|
Term
|
Definition
| An excel spreadsheet file |
|
|
Term
|
Definition
| Sheets in an excel workbook used to present data in an organized format |
|
|
