What happens when a user inserts a new row into an MS Excel worksheet?

Correct option is B

When a user inserts a new row into an MS Excel worksheet, the existing rows are shifted down to accommodate the new row. The newly inserted row will appear above the selected row, and all the data in the rows below will be moved one row down. This ensures that no existing data is overwritten, and the new row can hold new data without disrupting the layout of the worksheet.
Important Key Points:
1. Row Insertion: The new row is inserted at the specified position in the worksheet, and all rows beneath it are moved downward.
2. Data Integrity: No data is overwritten in this process; all existing data is preserved.
3. Dynamic Adjustments: Excel automatically adjusts the references and formulas when rows are inserted, ensuring that the worksheet remains consistent.
4. Flexible Insertion: The user can insert a row anywhere in the worksheet, and Excel will adjust the surrounding data accordingly.
Knowledge Booster:
· The new row is added at the bottom of the worksheet: This is incorrect because rows are added wherever the user specifies, not only at the bottom.
· The existing data in the row is overwritten: This is incorrect; inserting a row does not overwrite any existing data, as all the existing rows below the insertion point are simply shifted down.
· The existing rows are shifted to the right: This is incorrect. Inserting a row does not affect the columns, only the rows are shifted down.