Advanced Functions of Spreadsheets

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

Used to assist in organizing spreadsheet information

Used to calculate a period of time:

Calculates the difference in days between two dates

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

Limits data entry to specific choices programmed into the functions:

An IF statement is__________.

Returns the current date:

Used when there are more than 2 columns in the array