Like this study set? Create a free account to save it.

Sign up for an account

Already have a Quizlet account? .

Create an account

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.


number of cells in a range that contain numbers.


number of cells in a range that contain value or letter.


cells that meet a condition set forth in the formula.

Date function

used to calculate a period of time.


calculates difference in days between two dates.

IF Statements

conditional operators.


used to assist in organizing spreadsheet information.


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.


returns the current date.

Validated List

limits data entry to specific choices programmed into the function.


used when there are more than two columns in the array (lookup table).

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions and try again


Reload the page to try again!


Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

Voice Recording