« previous next »

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

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

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

The cladistic approach from molecular genetic data The cladistic approach from molecular genetic data
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
An example of a Material Safety Data Sheet (MSDS). An example of a Material Safety Data Sheet (MSDS).
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 ...
data data
Sturtevant’s Recombination Data for Five X-Linked Genes in Drosophila Sturtevant’s Recombination Data for Five X-Linked Genes in Drosophila
Video: Brain Anatomy Animation (Part 1 of 2)

For a complete list of videos, visit our video library