Solved

What Does the Excel "=SUMPRODUCT(A1:A5,C6;C10)" Function Do

Question 12

Multiple Choice

What does the Excel "=SUMPRODUCT(A1:A5,C6;C10) " function do?


A) Sums each range and multiplies the sums.
B) Sum each pair of cells and multiples each sum.
C) Multiplies the contents of cells containing the =SUM() command.
D) Multiplies each pair of cells in two arrays matched by position and sums the products.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions