Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is
a. TRUE. b. NULL.
c. FALSE. d. EXACT.
Q. 2The _______________ probability distribution can be used to estimate the number of vehicles that go through an intersection during the lunch hour.
a. binomial
b. normal
c. triangular
d. Poisson
Q. 3The VLOOKUP with range set to _________ takes the first argument and searches the first column of the table for the last row that is strictly less than the first argument.
a. FALSE b. TRUE
c. LESS d. NULL
Q. 4All of the following are examples of discrete random variables except
a. number of tickets sold.
b. marital status.
c. time.
d. population of a city.
Q. 5The 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.
Q. 6Which 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.
Quick Reply
