| A | B |
|---|
| Count | used to return the number of cells in a range that contain numbers |
| CountA | used to return the number cells in a range that contain value or letter |
| CountIf | used to return the number of cells that meet a condition set forth in the formula. |
| Date functions | used to calculate a period of time |
| NOW | returns the current date |
| Days360 | calculates difference in days between two dates |
| IF statements | a logical function that allows the user to set up a condition to test data. |
| List | used to assist in organizing spreadsheet information in order to control the size or content of data entries or filter for specific content within a list such as displaying only the Southeast region vice presidents |
| LookUp function | used to compare a cell value to an array of cells and return a value that matches the location of the value in the array |
| Lookup | used for two column vectors |
| VLookUp | used when there are more than two columns in the array (lookup table). |
| Non-validated | a type of list that allows additional entries other than those provided in the drop-down menu |
| Validated | a type of list that limits data entry to specific choices programmed into the function. |
