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.
Correct Answer:

Verified
Correct Answer:
Verified
Q1: The _ button in the Formula Auditing
Q3: Which of the following tools provides an
Q4: The modeling process begins with the framing
Q5: Using only the "SUMIF" function, complete
Q6: The _ function pairs each element of
Q7: A _ decision is one in which
Q8: The influence in an influence diagram is
Q9: The average cost/unit for the production
Q10: Excel's _ tool allows the user to
Q11: The _ function allows the user to