Which of the following happens when you insert a new row into a worksheet?
A)The new row is added at the end of the sheet.
B)The new row is added at the beginning of the sheet.
C)The new row is added and the remaining rows shift down to accommodate it.
D)The new row is added and the remaining rows shift up to accommodate it.

Question

Quizplus · Accepted Answer

When a new row is inserted into a worksheet, the existing rows below the insertion point shift down to make space for the new row. This ensures that the data remains intact and the new row is accommodated without overwriting any existing data.

Which of the Following Happens When You Insert a New