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:

System 2 Decision

A decision-making process that involves analytical and thoughtful consideration, as opposed to quick, automatic thinking.

Carefully Planned Diet

A diet meticulously outlined to meet nutritional needs, often for specific health conditions or fitness goals.

Driving Route

The predetermined path or directions followed when operating a vehicle from one location to another.

Availability Heuristic

A mental shortcut that relies on immediate examples that come to mind when evaluating a specific topic, concept, method, or decision.