« previous next »

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

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

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Dimensions for gathering data Dimensions for gathering data
Ventral View of the Spinal Column Ventral View of the Spinal Column
Attributed to Apollodorus, Column of Trajan, Rome (detail). Attributed to Apollodorus, Column of Trajan, Rome (detail).
Inferring Productivity from Data on Output and Factor Accumulation Inferring Productivity from Data on Output and Factor Accumulation
Data Used to Analyze Productivity in Country 1 and Country 2 Data Used to Analyze Productivity in Country 1 and Country 2
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
Video: Glucose anabolism reactions: Glycogenolysis and Gluconeogenesis

For a complete list of videos, visit our video library