With Reference to the SUMPRODUCT Function, Which of the Following

question 2

Multiple Choice

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.