| A | B |
|---|
| If Function | Function that assigne a value to a cell based on a logical test |
| Ctrl+End | To the last cell containing data |
| relative cell reference | A cell reference that excel adjusts as it is copied to the destination area |
| Absolute cell reference | a cell reference that remains constant when copying a formula or function |
| Now Function | Excel function that returns a number that corresponds to the system date and time |
| #ref | excel message used to indicate a cell reference error |
| assumptions | values in cells that you can change to determine new values for formula |
| drag and drop | using a mouse to move or copy cells |
| Go to indicated cell | F5 |
| escape | cancel a cell entry |
| Ctrl+Home | To cell A1 |
| Ctrl+C | copy selected data |
| Ctrl+V | Paste selected data |
| Ctrl+X | Cut selected data |
| Mixed Cell Reference | A cell reference where one factor remains constant and the other varies |
