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:

Capital

Funds provided by investors or owners of a company to finance its operations and growth, often invested in assets.

Publicly Held

Refers to companies whose shares of stock are traded on public stock exchanges, allowing for public ownership and investment.

Ownership

The legal right or interest that an individual or entity has in an asset or property.