Advanced Spreadsheet Functions Review

IF statements are conditional operators.

• TRUE
• FALSE

IF statements can be written to carry out an action.

• TRUE
• FALSE

What are the DATE functions used to calculate?

• the future
• a period of time
• how many
• predictions

The NOW function does what?

• returns a comparison
• returns the possible time
• returns the current date
• returns the number of days

DATE 360 

• returns the current date
• calculates the number of days in a year
• calculated the difference in days between 2 dates
• shows how many days we have been in school

A Lookup function is 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.
• when you want to locate something in a long list
• calculate the date
• Validate the time

The List functions is used to do all of the following except?

• Assist
• Create
• Control
• Date

What are the two type of lists?

• Menu and Drop Down Lists
• Validated and Non-Validated
• Menu Options
• Date

The COUNT function is used to?

• Add a range
• Return the number of cells in a range.
• Sum a Column
• Choose the List

COUNTA returns the number of cells in a range that contain?

• the date
• the name
• any value/label
• the month