| A | B |
| If Statements | Has 3 parts, returns information or carries out an action |
| Now Function | Returns current date |
| Days 360 Function | Counts the number of days elapsed between two dates |
| Array | All the data in the cells of a lookup table |
| Vector | Column number that contains answer to information sought in vlookup inquiry |
| Lookup Function | Used when seeking information in a two column table |
| VLookup Function | Used when seeking information in a table containing more than two columns |
| Validated list | Can only choose what is on the list |
| Non-Validated list | Can choose additional entries besides what's on drop-down list |
| Count Function | Counts the number of cells in a range that contain numbers |
| CountIf Function | Counts the number of cells in a range that meet a condition set forth in the formula |
| CountA Function | Returns the number of cells in a range that contain text |