« previous next »

Author Question: Excel searches for an exact match of the first argument in the first column of the data when the ... (Read 143 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?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

The transmission and flexplate (flywheel) were removed to check the exact location of this oil ... The transmission and flexplate (flywheel) were removed to check the exact location of this oil ...
Symptoms and Signs Associated with Damage to Nerves in Different Areas of the Spinal Column Symptoms and Signs Associated with Damage to Nerves in Different Areas of the Spinal Column
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
A model of the 70S ribosome based upon early structural data A model of the 70S ribosome based upon early structural data
Prove the argument using two column proof number 5 only Prove the argument using two column proof number 5 only
Anterior View of the Spinal Column Showing Anterior and Posterior Longitudinal Ligaments Anterior View of the Spinal Column Showing Anterior and Posterior Longitudinal Ligaments
Video: Introduction to Genetics

For a complete list of videos, visit our video library