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:

Dividends Expected

The forecasted payments made by a corporation to its shareholders, typically derived from the company's profits.

Constant Dividend

A dividend policy in which a company pays a fixed dividend per share, unaffected by its earnings volatility.

Rate of Return

The increase or decrease in the value of an investment during a predetermined timeframe, represented as a proportion of the investment's original price.

Dividend Next Year

The projected amount of money to be paid to shareholders from a company's earnings in the forthcoming fiscal year.