Multiple Choice
Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B1:B4) "?
A) A1*A4 + B1*B4
B) A1*B1 + A2*B2 + A3*B3 + A4*B4
C) (A1+A4) *(B1+B4)
D) (A1+A2+A3+A4) *(B1+B2+B3+B4)
E) A1 + A4*B1 + B4
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q110: In the custom footer box, there is
Q111: In Excel, how can one select cells
Q112: What are the two main reasons why
Q113: _ is the model that contains the
Q114: A(n) _ is a quantity or factor
Q116: The sample standard deviation is found by
Q117: In Excel, what combination of functions can
Q118: Sometimes the things you learn about the
Q119: How do you know that you have
Q120: In the Excel MATCH function, which argument