Prior Knowledge spreadsheets

IF statements are conditional operators.

• TRUE
• FALSE

IF statements can be written to carry out an action.

• TRUE
• FALSE

The NOW function does what?

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

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

The COUNT function is used to?

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

COUNTIF returns the number of cells that meet a condition set forth in a ________________.

• Condition
• Criteria
• Formula
• Date

interest rates, due dates, payment terms, and financial projections are all examples of 

• functions
• formulas
• advanced functions

conditional operators are also known as 

• mathematical operators
• if statements
• date functions

another name for a spreadsheet is 

• math sheet
• workbook
• access