Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?
A) Right-click and select Insert from the drop-down menu,and pick Table Rows Above.
B) Right-click and select Insert from the drop-down menu,and pick Table Rows Below.
C) Click on the Design tab in the Tools group,and then click Remove Duplicates.
D) Click the arrow next to Delete on the Home tab,in the Cells group,and then click Delete Table Rows.

Question

Quizplus · Accepted Answer

After selecting the row, the best choice would be to click the arrow next to Delete on the Home tab, in the Cells group, and then click Delete Table Rows. This will remove the selected row from the table. Option A and B are incorrect as they are for inserting a new row, not removing an existing row. Option C is incorrect as it is for removing duplicate values in a table, not a row.

Mitchel Wants to Remove a Row of Unnecessary Data in a Table