Apps I - 4.01 Vocabulary List 3

14 terms by rhonda_siers 

Create a new folder

Advertisement Upgrade to remove ads

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

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 above and try again

Example:

Reload the page to try again!

Reload

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

NEW! Voice Recording

Create Set