Excel: Using Formulas and Functions
Order by
15 terms
Terms | Definitions |
|---|---|
 Absolute Reference | Permanent reference to a cell that does not change in relation to the location of the formula |
| Argument | Refers to the text, numbers, or cell references on which the function is to be performed |
| Arithmetic operator | Used for addition, subtraction, multiplication, division, and exponentiation |
| Auto Fill | A feature that can be used to automatically fill in worksheet data in any direction |
| Comparison operator | Compares two values to obtain a logical value, either TRUE or FALSE |
| Constant | Number entered directly into a formula that does not change |
| Error value | Indicates when a formula you have entered results in an error |
| Formula | Set of instructions used to perform calculations on values in a worksheet |
| Function | Buildt-in forumlas that enable you to perfom complex calculations easily |
| Mixed reference | Contains both relative and absolute cell references |
| Operator | Sign or symbol that indicates what calculation is to be performed |
| Order of Operations | Specific sequence used to calculate the value of a formula |
| Relative reference | The reference to a cell that changes in relation to the location of the formula |
| Syntax | A set of established rules that specifies how the function must be entered. |
| Fill Handle | A little black square in the lower-right corner of the selected cell |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.