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. |