| A | B |
|---|
| IF Statements | Conditional Operators |
| Date Functions | Used to calculate a period of time |
| Now Function | Returns the current date |
| Days360 | Calculate differences in days between two dates |
| LookUp Function | Used to compare a cell value to any array of cells |
| LookUp Function | Returns a value that matches the location of the value in the arrray |
| LookUp | Used for tow column vectors |
| VLookUp | Used when there are more than two columns in the array |
| List | Used to assist in organizing spreadsheet information |
| Filter | shows specific content within a list |
| Validated List | Limits data entry to specific choices programmed into the function |
| Non-Validated | Allows additional entries other than those provided in the drop-down menu |
| Count | Used to return the number of cells in a range |
| CountA | Number cells in a range that contains value or letter |
| CountIf | Cells that meet a condition set forth in the formula |
