« previous next »

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

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Thyroid conditions may make getting pregnant impossible.

The dorsal-column medial-lemniscus system. The pathways from only one side of the body are shown. The dorsal-column medial-lemniscus system. The pathways from only one side of the body are shown.
Schematic of the rectifying column Schematic of the rectifying column
Hubbard’s Predication of Peak in U.S Oil Production with Actual Data Hubbard’s Predication of Peak in U.S Oil Production with Actual Data
Determine exact value of tan2x,sin2x, and cos2x Determine exact value of tan2x,sin2x, and cos2x
Doty's data show a very rapid drop in late adulthood in the ability to identify smells Doty's data show a very rapid drop in late adulthood in the ability to identify smells
Algebraically determine the exact value of sin(-π/6)+cos (7 π/4) Algebraically determine the exact value of sin(-π/6)+cos (7 π/4)
Video: Five phases of cardiac cycle & Atrial contraction

For a complete list of videos, visit our video library