| A | B |
|---|
| Advanced Functions | Functions used in higher-level operations, such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections |
| IF statements | Conditional operators. Checks whether a cell value meets a condition, and returns one value if TRUE, and another value if FALSE. |
| Date Functions | Used to calculate a period of time |
| NOW | Function that returns the current date, no matter when you open the spreadsheet. |
| DAYS360 | Function that calculates difference between two dates (in days), based on 12 months with 30 days per month |
| Lookup Function | Used to compare a cell value to an array (range) of cells and return a value that matches the location of the value in the array |
| LOOKUP | Function used to compare a cell value to an array (range) in one column or row |
| VLOOKUP | Function used to compare a cell value to an array (range) of cell in a table with 2 or more columns |
| List | data validation feature used to assist in organizing spreadsheet information |
| 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 Functions | Used to return the number of cells in a range depending on the data in the cell |
| COUNT | Function that counts the number of cells in a range that contain numbers |
| COUNTA | Function that counts the number cells in a range that contain values or labels |
| COUNTIF | Function that counts the cells that meet a condition set forth in the formula |
