Solved

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

Question 58

Multiple Choice

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

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

Related Questions

Q53: Research has shown that most spreadsheet model

Q54: In Excel, relative references are indicated by

Q55: Define and describe a model.

Q56: The Excel function that multiplies corresponding numbers

Q57: In the custom footer box in Excel,

Q59: A scenario is a specific set of

Q60: For the Data Table feature in Excel,

Q61: When the "Formulas" box is checked under

Q62: Uncontrollable inputs are also called _.<br>A) decision

Q63: In Excel, what are the three arguments