Question

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.

Answer 1

After selecting the row, Mitchel can use the Insert option in the drop-down menu to add a new row above or below the selected row in MS Excel.

Step-by-step explanation:

After selecting the row in MS Excel, Mitchel can right-click and select Insert from the drop-down menu, and then pick Table Rows Above (Option A) or Table Rows Below (Option B) depending on whether he wants to insert a row above or below the selected row.

Option A: If he wants to add a row above the selected row, he can choose Table Rows Above. This will insert a new row above the selected row, pushing the existing row down.

Option B: If he wants to add a row below the selected row, he can choose Table Rows Below. This will insert a new row below the selected row, pushing the existing row up.

]