When You Insert a Column in a Worksheet, What Happens

question 462

Multiple Choice

When you insert a column in a worksheet, what happens to formulas you already entered?

• A) Excel updates their cell references to reflect the new layout.
• B) The formulas remain in the same cells.
• C) The cells with formulas display an error so you can correct them.
• D) The formulas need to be updated manually.

---

Definitions:

Personal Information

Data about an individual that can be used on its own or with other information to identify, contact, or locate a single person.

Liability

The state of being legally responsible for something, typically a debt or obligation.

Vicariously Liable

The condition of being held legally responsible for the actions or omissions of another person, often in the context of employment.

Ivic v. Lakovic

A legal case involving parties Ivic and Lakovic; specifics would depend on the jurisdiction and context of the case.