| A | B |
|---|
| filling | copies data to adjacent cells |
| freezing | keeps row or column titles on screen no matter where you scroll |
| splitting | divides screen into 2 or 4 parts |
| formula | equation used to calculate values in a cell |
| operand | number or cell reference used in formulas |
| operator | tells Excel what to do with operands (ex: + or /) |
| order of evaluation | sequence used to calculate value of a formula |
| relative cell reference | adjusts to its new location when copied or moved |
| absolute cell reference | does not change when moved or copied to a new cell |
| mixed cell reference | cell reference containing both relative and absolute references |
| point-and-click method | entering formula quickly by clicking on cell rather than keying reference |
| AutoSum | used to add long columns or rows |
