Which of the Following Is the Best Way to Ensure

question 19

Multiple Choice

Which of the following is the best way to ensure that the address in a formula is not changed when it is copied or moved?

• A) Use an absolute address to represent the formula.
• B) Enable the lock formula option from the Data tab.
• C) Select the "Protect Sheet" option from the Tools menu.
• D) Use the function key F2 after copying or moving the formula.

---

Definitions:

Required Return

The minimum expected return by investors for providing capital to a company or project, considering the risk involved.

EBIT

A profitability metric for a company that omits expenses related to interest and income taxes, known as Earnings Before Interest and Taxes.

ROE

Return on Equity, a measure of a corporation's profitability that reveals how much profit a company generates with the money shareholders have invested.

Repurchase Shares

The act of a company buying back its own shares from the marketplace, reducing the amount of outstanding stock.