#13

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return, a product number or product price?

#17

The syntax of RAND function is, include the = sign and the ()?

#19

When entering information into the If Function, the second argument tell what to do if the first argument is?

#20

When one wishes to select the largest number from a set of data, one should use which function? Include the equal sign and the ().

#21

What function lets you test if something is true or false and then do different things depending on which result you get? (include the =, but don't need to include the conditions)