Apps I - 4.01 Vocabulary List 3
About this set
Created by:
rhonda_siers on November 17, 2009
Subjects:
Log in to favorite or report as inappropriate.
Order by
14 terms
Terms | Definitions |
|---|---|
 Advanced 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. |
| Count | number of cells in a range that contain numbers. |
| CountA | number of cells in a range that contain value or letter. |
| CountIf | cells that meet a condition set forth in the formula. |
| Date function | used to calculate a period of time. |
| Days360 | calculates difference in days between two dates. |
| IF Statements | conditional operators. |
| List | used to assist in organizing spreadsheet information. |
| Lookup | used for two column vectors. |
| 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. |
| Non-validated List | allows additional entries other than those provided in the drop-down menu. |
| NOW | returns the current date. |
| Validated List | limits data entry to specific choices programmed into the function. |
| VLookup | used when there are more than two columns in the array (lookup table). |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.