Author Question: Excel searches for an exact match of the first argument in the first column of the data when the ... (Read 160 times)

ishan

  • Hero Member
  • *****
  • Posts: 546
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.

Question 2

The _______________ 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



wilsonbho

  • Sr. Member
  • ****
  • Posts: 322
Answer to Question 1

c
RATIONALE: If the range in the VLOOKUP function is FALSE, Excel searches for an exact match of the first argument in the first column of the data.

Answer to Question 2

d
RATIONALE: The Poisson probability distribution is often useful in estimating the number occurrences of an event over a specified interval of time or space.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question


 

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

For a complete list of videos, visit our video library