How can we help?

You can also find more resources in our Help Center.

14 terms

Apps I - 4.01 Vocabulary List 3

STUDY
PLAY
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).