With reference to the SUMPRODUCT function, which of the following ...

[KimWrice]

With reference to the SUMPRODUCT function, which of the following statements is true?
 a. The range of cells for each array must contain only nonzero values.
  b. Any cell that does not satisfy the specified given condition or criteria will not be considered.
  c. The array appearing as the first argument must be sorted in ascending order.
  d. The arrays that appear as arguments must be of the same dimension.

Question 2

Which statement is true about mutually exclusive events?
 a. If events A and B cannot occur at the same time, they are called mutually exclusive.
  b. If either event A or event B must occur, they are called mutually exclusive.
  c. P(A) + P(B) = 1 for any events A and B that are mutually exclusive.
  d. None of these.

[scrocafella]

Answer to Question 1

d
RATIONALE: The arrays that appear as arguments to the SUMPRODUCT function must be of the same dimension.

Answer to Question 2

a

[KimWrice]

Wow, this really help

[triiciiaa]

Great answer, keep it coming