« previous next »

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

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

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?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Electronic service information is available from aftermarket sources, such as All-Data and ... Electronic service information is available from aftermarket sources, such as All-Data and ...
Distribution of Thunderstorms: Detailed data on cloud-to-ground lightning flashes have been ... Distribution of Thunderstorms: Detailed data on cloud-to-ground lightning flashes have been ...
Flow data for a healthy donor (top panel) and a HIV positive patient. CD3 is a T-cell marker, CD4 is ... Flow data for a healthy donor (top panel) and a HIV positive patient. CD3 is a T-cell marker, CD4 is ...
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
A square matrix P is called a permutation matrix if each row and column of P contains exactly ... A square matrix P is called a permutation matrix if each row and column of P contains exactly ...
The Hfr chromosome time-of-entry map is assembled from the recombinant data The Hfr chromosome time-of-entry map is assembled from the recombinant data
Video: EpiPen Animation (Part 1)

For a complete list of videos, visit our video library