« previous next »

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

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

The carbon cycle. Numbers are storage as 1015 g or fluxes as 1015 g per year (data from Schlesinger The carbon cycle. Numbers are storage as 1015 g or fluxes as 1015 g per year (data from Schlesinger
Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry. Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry.
An example of a Material Safety Data Sheet (MSDS). An example of a Material Safety Data Sheet (MSDS).
Absorption column with all inlet and outlet feeds Absorption column with all inlet and outlet feeds
Column of Trajan Column of Trajan
A square matrix P is called a permutation matrix if each row and column of P contains exactly ... A square matrix P is called a permutation matrix if each row and column of P contains exactly ...
Video: Sex-Linked Traits! How are eye colors inherited in fruit flies?

For a complete list of videos, visit our video library