| A | B |
|---|
| 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 numbers or text |
| DATE Functions | used to calculate periods of time |
| DAYS360 | function that calculates the difference in days between 2 dates |
| IF a value in a cell is greater than or equal to another value, insert the word “Pass” in a cell | Example of an IF Statement |
| IF | checks if a condition is met and returns one value if TRUE and another value if FALSE |
| In IF statements conditions are set by the _____________. | formula |
| List | used to assist in organizing spreadsheet information |
| LOOKUP | looks up a value form a one-row or one-column range |
| Non-validated List | allows additional entries other than those provided in the drop-down menu |
| NOW | function that returns the current time and date |
| NOW and DAYS 360 are examples of _______________ functions. | DATE |
| Validated List | limits data entry to specific choices programmed into the drop down list |
| VLOOKUP | looks for a value in a table with 2 or more columns; must use a column index number |
| COUNTIF | counts the number of cells in a range that meet the given condition or criteria |
