Which of the Following Is True About Inserting Cells in a Worksheet

question 75

Multiple Choice

Which of the following is true about inserting cells in a worksheet?

• A) Excel automatically adjusts cell references to reflect new formula locations.
• B) You need to adjust cell references in all formulas that have moved.
• C) You cannot insert cells in a worksheet.
• D) Cells below the inserted cells are always moved downward.

---

Definitions:

Common Stock

A type of equity security that represents ownership in a corporation, with rights to share in its profits through dividends and capital appreciation.

Sold Shares

Refers to the act of transferring ownership in a corporation's stock from one party to another in exchange for money or other compensation.

Dividend

A portion of a company's earnings that is distributed to shareholders as a return on their investment.

Trading Portfolio

A collection of financial assets held by an individual or institution primarily for the purpose of short-term trading and profit.