| A | B |
|---|
| Cell reference | indicates a cell’s location and provides instructions for how cell data is copied or used in calculations |
| Relative | cell value changes as the formula is copied |
| Absolute | cell value remains static when copied to other locations |
| Mixed reference | “indicates the combination of an absolute cell and a relative cell |
| Parentheses | this controls the Order of Operations |
| Conditions or criteria | this tells the function how to calculate the results and what data to use |
| Sum | function that adds the range of cells |
| Average | function that calculates an average in the range of cells |
| Maximum | function that finds the highest number in the range of cells |
| Minimum | function that finds the lowest number in the range of cells |
| IF statements | “conditional operators used in spreadsheet formulas. Results are returned IF the data specified in an equation meets conditions set by the formula” |
| Date functions | used to calculate a period of time |
| NOW function | function that returns the current date |
| Days360 | a date function that calculates the difference in days between two dates |
| 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 is used for two column vectors or multi-column arrays.” |
| VLookUp | “used when there are more than two columns in the array (lookup table). Vlookup searches for matches according to column number” |
| List | a feature used to create a more user-friendly spreadsheet atmosphere |
| Validated list | list that limits data entry to specific choices programmed into the function |
| non-validated list | list that allows additional entries other than those provided in the drop-down menu |
| CountA Function | function will return the number cells in a range that contain any value |
| Count Function | this function alone will return the number of cells in a range that contain numbers |
| CountIf | function will count cells that meet a condition set forth in the formula |
