« previous next »

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

The horizontal fraction bar was introduced by the Arabs.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Verterbral Column Anatomy Verterbral Column Anatomy
Letterhead stationery sizes are varied to suit the needs of the sender. Envelopes are sized to match ... Letterhead stationery sizes are varied to suit the needs of the sender. Envelopes are sized to match ...
A physician uses a portable electronic tablet to enter patient data while in the examination room. A physician uses a portable electronic tablet to enter patient data while in the examination room.
Flow data for a healthy donor (top panel) and a HIV positive patient. CD3 is a T-cell marker, CD4 is ... Flow data for a healthy donor (top panel) and a HIV positive patient. CD3 is a T-cell marker, CD4 is ...
Excel Interpretation Excel Interpretation
Ligaments and Intervertebral Discs of the Spine Lateral View of the Spinal Column (Anterior to the R Ligaments and Intervertebral Discs of the Spine Lateral View of the Spinal Column (Anterior to the R
Video: Calvin cycle (The light-independent reactions )

For a complete list of videos, visit our video library