« previous next »

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

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa
Summary of US Census Data Summary of US Census Data
Treatment of Depression with Ketamine The graph shows the effects of ketamine on symptoms of depress Treatment of Depression with Ketamine The graph shows the effects of ketamine on symptoms of depress
Before starting the process of adjusting the valves, look up the specifications and exact ... Before starting the process of adjusting the valves, look up the specifications and exact ...
The data link connector (DLC) can be located in various locations. The data link connector (DLC) can be located in various locations.
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
Video: SNP Polymorphysim Microarray Chip - How to Test a Person's DNA

For a complete list of videos, visit our video library