A | B |
Formulas | The equations used to calculate values in a cell |
Operand | A number of cell reference used in formulas. |
Operator | Tells Excel what to do with the operands. For example +, -, *, /, and ^. |
Order of Evaluation | The sequence used to calculate the value of a formula. |
Relative Cell Reference | Adjusts to its new location when copied or moved. |
Absolute Cell References | DO NOT change when moved or copied to a new cell. |
Mixed Cell References | Cell references containing both relative and absolute references. |
Function Formulas | Special formulas that do not use operators to calculate a result. |
Argument | A value, cell reference, range, or text that acts as an operand in a function formula. |
Statistical Functions | Used to describe large quantities of data. |
Financial Functions | Used to analyze loans and investments. |