« previous next »

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

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Foliage height diversity and bird species diversity (data from MacArthur and MacArthur 1961). Foliage height diversity and bird species diversity (data from MacArthur and MacArthur 1961).
Extent of agricultural activity across the planet (data from Foley et al. 2005). Extent of agricultural activity across the planet (data from Foley et al. 2005).
Attributed to Apollodorus, Column of Trajan, Rome. Attributed to Apollodorus, Column of Trajan, Rome.
Material safety data sheets (MSDS), now called safety data sheets (SDS), should be readily available ... Material safety data sheets (MSDS), now called safety data sheets (SDS), should be readily available ...
How to calculate the mean for grouped data How to calculate the mean for grouped data
Satellite data showing net primary production. Productivity is coded as red (highest) down through o Satellite data showing net primary production. Productivity is coded as red (highest) down through o
Video: How to find out if a population is evolving?

For a complete list of videos, visit our video library