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.

Question

Quizplus · Accepted Answer

When cells are inserted in a worksheet, Excel automatically adjusts cell references in formulas to reflect new formula locations. Therefore, there is no need to manually adjust cell references. Cells below the inserted cells are indeed moved downward by default, but this is not always the case if other options are selected during the insert cell process. And, inserting cells is a common task in Excel and is done using various methods such as the Insert command on the Ribbon, right-clicking cells, or using shortcut keys.

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