click below
click below
Normal Size Small Size show me how
formulas + funtions
| Question | Answer |
|---|---|
| The equal sign | The equal sign lets the software 'know' that data will be used in a calculation |
| Addition | + |
| Subtraction | - |
| Multiplication | x |
| Division | / |
| P emdas | Parenthesis |
| p E mdas | Exponents |
| pe M das | Multiplication |
| pem D as | Division |
| pemd A s | Addition |
| pemda S | Subtraction |
| Argument | The range of cells to be calculated |
| sum | shortcut for adding a range of cells |
| average | shortcut for averaging a cell |
| Maximum | shortcut for finding the the highest value in a range |
| Minimum | shortcut for finding the lowest value |
| Cell Reference | Indicates a cells location |
| Relative cell reference | Cell value changes as the formula is copied |
| Absolute Cell Reference | cell value remains the same when copied from one location to another |
| Mixed cell reference | combination of an absolute and relative cell reference |
| Order of operations | An order of witch operations are preformed |