Solved

Which of the Following Is Equivalent to "=SUMPRODUCT(A1:A4,B2:B6)

Question 100

Multiple Choice

Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B2:B6) "?

A) A1*A4 + B2*B6
B) A1*B2 + A2*B3 + A3*B4 + A4*B5
C) (A1+A4) *(B2+B6)
D) (A1+A2+A3+A4) *(B2+B3+B4+B5+B6)
E) This is an invalid function.

Related Questions

Q95: In Excel, which function returns the number

Q96: A model needs to do more than

Q97: For the Goal Seek feature in Excel,

Q98: In Excel, Goal Seek is found under

Q99: What are the six steps to developing

Q101: The Excel function that returns the z-value

Q102: _ analysis deals with studying the changes

Q103: In Excel, what are the keystrokes for

Q104: In Excel, what does the formula "=MAX(B25:D25)"

Q105: How many arguments does the MATCH function