click below
click below
Normal Size Small Size show me how
Formulas & Functions
| Term | Definition |
|---|---|
| The equal (=) sign | Lets the software "know" that the data will be used in a calculation. |
| Order of Operations | The order in which operations are performs in a formula calculation. |
| Sum | Shortcut for adding a range of cells. |
| Average | Shortcut for averaging a range of cells. |
| Maximum | Shortcut for finding the highest value in a range of cells. |
| Minimum | Shortcut for finding the lowest value in a range of cells. |
| Function | A shortcut for a formula. |
| Argument | The range of cells to be calculated in a function. |
| Cell Reference | Indicates a cell's location and provides instructions for how cell data is copied or used in calculations. |
| Relative Cell Reference | Cell value changes as the formulas is copied. |
| Absolute Cell Reference | Cell value remains the same when copied from one location to another ($ in front of cell reference part indicates absolute cell reference) |
| Mixed Cell Reference | Combination of an absolute and relative cell reference. |
| Addition | + |
| Division | / |
| Multiplication | * |
| Subtraction | - |
| Formulas | Instruct the software to perform a calculation. |
| P | Performs operations on the items enclosed in (parentheses) first. |
| E | ^ A way to show how many times a number is multiplied by itself. |
| M | * Multiply's numbers by each other. (from left to right) |
| D | / Divides numbers by each other. |
| A | + Adds numbers together. (from left to right) |
| S | - Subtracts numbers from each other. |