Term
|
Definition
| the selected cell displays 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 directiion of the arrow key. |
|
|
Term
|
Definition
| function that adds the values of the cells in a 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 work sheet. |
|
|
Term
|
Definition
| the intersection of 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 reference 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
| preforms a calculation that results 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 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
| selection of two of more cells. |
|
|
Term
|
Definition
| a cell reference that when copied reflects the row and 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 individual rows. |
|
|
Term
|
Definition
| used to display the three worksheets in the work book. |
|
|
Term
|
Definition
| data displayed in rows and columns. |
|
|
Term
|
Definition
| function thatadds the values in range of cells. |
|
|
Term
|
Definition
| numeric data that is stored in a cell that can be used in calculations. |
|
|
Term
|
Definition
| an exel spreadsheet file. |
|
|
Term
|
Definition
sheets in an exel workbook used to present data in an organized format. |
|
|
