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.

---

Definitions:

Zero

The numerical digit that represents the absence of any quantity or value.

Mark Clearly

The act of identifying or labeling something in a way that is easily visible and understandable to others.

Technical Communication

The discipline and practice of effectively conveying technical or specialized information to a specific audience.

Potential Drawback

A possible disadvantage or negative outcome that could arise from a decision, action, or situation.