Question 12: You can use the (F4) key can be used to create absolute and mixed cell references.

1. True
2. False

Question 13: The IF function can display one of two results depending on the criteria set.

1. True
2. False

Question 14: Which statement is correct regarding mixed cell references?

1. They contain a combination of relative and absolute references.
2. They contain relative references only.
3. They contain absolute references only.
4. They contain neither relative nor absolute references.

Question 15: Lookup functions always search for an exact match between the lookup value and the entries in the lookup table.

1. True
2. False

Question 16: If you enter a pair of consecutive quotation marks as the value_if_true or value_if_false arguments, Excel will return a blank cell for these entries.

1. True
2. False