Question

To delete the table row with the record starting in cell A8 and without deleting any worksheet data outside of the table, which action should you take?

A) Highlight the entire row and press the Delete key.

B) Right-click on the row and choose the Delete Row option.

C) Use the Cut function on the row and then paste it in an empty area.

D) Select the cell in A8, go to the Data tab, and click Delete.

Answer 1

To properly delete a table row starting in cell A8, right-click on the row and choose the Delete Row option to avoid affecting other worksheet data.

Step-by-step explanation:

To delete the table row with the record starting in cell A8 and without deleting any worksheet data outside of the table, the correct action to take would be B) Right-click on the row and choose the Delete Row option.

This method ensures that only the specified row within the table is removed without affecting any other data on the worksheet. Options A and C could potentially delete or displace other worksheet data, and option D is not typically a valid action for deleting rows in a table.