| A | B |
|---|
| Sum | adds the range of cells |
| Average | determines the average of the range of cells |
| Maximum | finds the highest number in the range of cells |
| Minimum | finds the lowest number in the range of cells |
| IF statements | are conditional operators |
| Date functions | used to calculate a period of time using NOW and Days360 |
| LookUp function | used to compare a cell value to an array of cells and returns a value that matches the location of the value in the array |
| VLookUp | used when there are more than two columns in the array (lookup table) |
| List | featured used to create a more user-friendly spreadsheet atmosphere such as validated and non-validated |
| Count | used to return the number of cells in a range such as Count, CountA, and CountIF |
