Elsa has collated information for a meeting using Excel. Due to certain developments, some of the data in her worksheet is now redundant. She deletes three rows from her worksheet to reflect the developments. Which of the following will happen to the rest of the rows in the worksheet when Elsa deletes three rows?
A)There will be an empty space where the deleted rows were.
B)The data from the rows will be shifted to rows at the bottom of the worksheet.
C)The data from the rows will be shifted to the rows at the beginning of the worksheet.
D)The remaining rows will shift up to take the place of the rows that were deleted.

Question

Quizplus · Accepted Answer

When rows are deleted in Excel, the remaining rows automatically shift up to fill the gap left by the deleted rows, ensuring there are no empty spaces in that part of the worksheet.

Elsa Has Collated Information for a Meeting Using Excel