The condition that VLOOKUP assumes is that a. there are no ...

[tsand2]

The condition that VLOOKUP assumes is that
 a. there are no nonzero values in the range.
  b. all the arguments are of the same dimension.
  c. the first column of the table is sorted in ascending order.
  d. the columns with empty cells are to be neglected.

Question 2

Which of the following is a discrete random variable?
 a. The number of times a student guesses the answers to questions on a certain test.
  b. The amount of gasoline purchased by a customer.
  c. The amount of mercury found in fish caught in the Gulf of Mexico.
 
  d. The height of water-oak trees.

[CAPTAINAMERICA]

Answer to Question 1

c
RATIONALE: The condition that VLOOKUP assumes is that the first column of the table is sorted in ascending order.

Answer to Question 2

a
RATIONALE: A discrete random variable can only take on specified discrete values.

[tsand2]

Wow, this really help

[scottmt]

Thanks for the timely response, appreciate it