Question

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.

Answer 1

Answer: Option(d) is the correct option

Explanation:

Excel sheets are the spreadsheets which consists of rows and columns for arrangement and display of values.It is used for mathematical function and computation .

According to the question, as Elsa is performing deletion of three rows is done for development, other rows will tend to shift upwards and settle in the deleted row spaces accordingly as per arrangement.

• Other options are incorrect because deleted rows will not be indicated through empty spaces,row data won't shift to bottom of sheet and neither shift of data will take place at the starting of sheet.
• Thus the correct option is option(d).