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
| Enters data and then selects the next cell in the direction of the arrow key. |
|
|
Term
|
Definition
| function that adds the values of the cell ina a range and divides the result by the number of cell 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 a column. Each cell can store a single item of data. |
|
|
Term
|
Definition
| The column letter and row number used to indentify a cell such as B3. |
|
|
Term
|
Definition
| An error that occurs when a formula references the cell it is stored in. |
|
|
Term
|
Definition
| Cancels data entry and restores the original content of the cell. |
|
|
Term
|
Definition
| The solid square in the lower-right corner of the selected cell that is used to copy the contents of a cell to adjenct cells |
|
|
Term
|
Definition
| Mathematical statment used to calculate a value. A formula must always begin with a equal sign. For example, =C%=D7=E8 is a formula. |
|
|
Term
|
Definition
| Area near the top of the worksheet window that displays the content of the active cell. |
|
|
Term
|
Definition
| Performs a calculation that result in a single value. The formula= SUM(B3:B8) contains the SUM function. |
|
|
Term
|
Definition
| Solid lines that mark off the rows and columns in a worksheet. |
|
|
Term
|
Definition
| Text stroed in a cell that cannot be used in calculations. |
|
|
Term
|
Definition
| located near the top of the worksheet window. Displays the cell refernece of the active cell. |
|
|
Term
|
Definition
| Selection of twop or more cells. |
|
|
Term
|
Definition
| A cell refernece 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 a decimal places. |
|
|
Term
|
Definition
| The number down the left side of the worksheet used to identify individual rows. |
|
|
Term
|
Definition
| Used to display the three worksheets in the workbook. |
|
|
Term
|
Definition
| Data displayed in the rows and columns. |
|
|
Term
|
Definition
| Function that adds the value in a range of cells. |
|
|
Term
|
Definition
| Numeric data that is stored in a cell that can be used in calculations. |
|
|
Term
|
Definition
| An Excel spreadsheet file. |
|
|
Term
|
Definition
| Sheets in an Excel workbook used to present data in an organized format. |
|
|
