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

question 115

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

---

Definitions:

Centimeter

A unit of length in the metric system, equal to one hundredth of a meter, commonly used for measuring small distances.

Millimeter

A metric unit of length equal to one thousandth of a meter.

Line Of Best Fit

The line of best fit, in statistics, is a straight line drawn through the center of a group of data points on a scatter plot, used to describe the relationship between variables and predict future data points.

Data Points

Individual pieces of factual information recorded and used for the purpose of analysis.