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 |