A | B |
Absolute Cell Reference | Cell reference that does not adjust to the new cell location when copied or moved. |
Argument | Value, cell reference, range, or text that acts as an operand in a function formula. |
Assumptions | A variable factor that is useful for conducting What-If analysis in a worksheet. |
Autosum | A function that automatically adds the values in the cells directly above or to the left of the active cell. |
Cell | The space formed by the intersection of a row and a column; the basic unit of a worksheet. |
Chart | A graphic representation of values and their relationships, used to identify trrends and contrasts in data. |
Column | Appears vertically in a worksheet and is identified by letters at the top of the worksheet window. |
Fill | Copies data in to the cell(s) adjuacent to the original. |
Formula | Equation that calculates a new value from values currently on a worksheet. |
Freeze | Keeps row or column titles on the screen no matter where you scroll in the worksheet. |
Function | A built-in formula included in most spreadsheet programs that makes it easy for you to perform comman calculations. |
Goal Seeking | Determines the value of a cell on which the formula depends. |
Operator | Tells the software what to do with operands in a formula. |
Ranges | Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell is the lower right corner, separated by a colon. |
Relative Cell Reference | Cell reference that adjusts to a new location when copied or moved. |
Row | Appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window. |
Spreadsheet | Grid of rows and columns containing numbers, text, and formulas; the purpose of a spreadsheet is to solve problems that involve numbers. |
What-If Analysis | Technique by which you change certain condiditons in a worksheet to see how the changes affect the results of your spreadsheet output. |
Workbook | A file made up of related worksheets. |
Worksheet | The workspace made up of columns and rows wher eyou enter date to create an electronic spreadsheet. |