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.

---

Definitions:

Cash Deal

A transaction where the payment for a good, service, or acquisition is made entirely with cash instead of financing or stock exchanges.

Fair Market Value

The price at which an asset would trade in a competitive auction setting, reflecting the value of an asset in the open market.

Fixed Assets

Long-term tangible assets used in the operations of a business and not expected to be converted to cash within a year.

Long-Term Debt

Debt that is due for repayment in more than one year, often used to finance major investments or acquisitions.