« previous next »

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

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

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?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Osteoporosis. (a) A section through normal spongy bone. (b) A section through a bone with osteoporos Osteoporosis. (a) A section through normal spongy bone. (b) A section through a bone with osteoporos
The spinal column. The spinal column.
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 ...
Column of Trajan Column of Trajan
Algebraically determine the exact value of sin(-π/6)+cos (7 π/4) Algebraically determine the exact value of sin(-π/6)+cos (7 π/4)
A 16-input multiplexer is to be used to perform parallel-to-serial data conversion. Which of ... A 16-input multiplexer is to be used to perform parallel-to-serial data conversion. Which of ...
Video: The 4 steps of translation Animation

For a complete list of videos, visit our video library