« previous next »

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

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

Did you know?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

Did you know?

Anti-aging claims should not ever be believed. There is no supplement, medication, or any other substance that has been proven to slow or stop the aging process.

The nitrogen cycle. Numbers represent fluxes as 1012 g N per year (data from Schlesinger 1991, after The nitrogen cycle. Numbers represent fluxes as 1012 g N per year (data from Schlesinger 1991, after
Women who are monozygotic twins and have the same genes are more similar in their marital happiness Women who are monozygotic twins and have the same genes are more similar in their marital happiness
Attributed to Apollodorus, Column of Trajan, Rome (detail). Attributed to Apollodorus, Column of Trajan, Rome (detail).
Distillation column with heat pump Distillation column with heat pump
Data management questions Data management questions
The Anatomic Dimensions of the Vertebral Column (Anterior, Left Lateral, and Posterior) The Anatomic Dimensions of the Vertebral Column (Anterior, Left Lateral, and Posterior)
Video: Hyperglycemia Animation

For a complete list of videos, visit our video library