In Excel, when you insert or delete cells from a spreadsheet, ____.
A) Excel automatically adjusts cell references to reflect new locations
B) you have to manually adjust all formulas
C) formulas will appear as errors
D) None of the above. You cannot insert or delete cells from a spreadsheet.

Question

Quizplus · Accepted Answer

When cells are inserted or deleted from a spreadsheet, Excel automatically adjusts the cell references in formulas to reflect the new locations. This saves time and effort, as you do not have to manually adjust each formula in the affected cells.

In Excel, When You Insert or Delete Cells from a Spreadsheet