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.

Question

Quizplus · Accepted Answer

When you insert a column in a worksheet, Excel automatically updates the cell references of the formulas in the affected columns to reflect the new layout. This ensures that the formulas continue to reference the correct cells after the new column has been added. Therefore, option A is the best choice.

When You Insert a Column in a Worksheet, What Happens