« previous next »

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

ishan

  • Hero Member
  • *****
  • Posts: 546
on: Jun 24, 2018
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
Reply #1 on: Jun 24, 2018
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

ishan

  • Hero Member
  • *****
  • Posts: 546
Reply #2 on: Jun 24, 2018
Thank you


wilsonbho

  • Sr. Member
  • ****
  • Posts: 322
Reply #3 on: Jun 24, 2018
No problemo


« previous next »
 

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

According to research, pregnant women tend to eat more if carrying a baby boy. Male fetuses may secrete a chemical that stimulates their mothers to step up her energy intake.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

A revised animal phylogeny based on molecular data of SSU rRNA A revised animal phylogeny based on molecular data of SSU rRNA
Lake position in the landscape and proportion of water received as groundwater (data from Webster et Lake position in the landscape and proportion of water received as groundwater (data from Webster et
The Lion Gate of Mycenae (detail)—two lionesses flank the central column, c. 1300 B The Lion Gate of Mycenae (detail)—two lionesses flank the central column, c. 1300 B
Osteoporosis. (a) A section through normal spongy bone. (b) A section through a bone with osteoporos Osteoporosis. (a) A section through normal spongy bone. (b) A section through a bone with osteoporos
Bones of the spinal column. Bones of the spinal column.
Data for a Hypothetical Paternity Test Using 13 CODIS Genes Data for a Hypothetical Paternity Test Using 13 CODIS Genes
Video: Automated external defibrillator (AED)

For a complete list of videos, visit our video library