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.

---

Definitions:

Genus

A term that denotes a general category or class under which species and individuals are subsumed, often used in hierarchical classification.

Species

A class of things regarded as a subcategory of a wider class (a genus).

Box

A container often made of cardboard or wood, used for storage or shipping.

Referent

The actual thing or idea to which a word or phrase refers or applies.