Advanced Functions of Spreadsheets

Match it! Select the correct answer from the pull down...Good luck!

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

An IF statement is__________.

Used to compute interest rates, due dates/payment terms, and financial projections

There are two types of ______________ functions: Validated and Non-Validated.

An IF statement will render a result if_________.

Used for two column vectors

Used to assist in organizing spreadsheet information

Used when there are more than 2 columns in the array