[amp_mcq option1=”Delete the column from the worksheet” option2=”Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button” option3=”Select Data > Delete Record from the menu” option4=”Click the Delete button on the Standard toolbar” correct=”option3″]
The correct answer is: C. Select Data > Delete Record from the menu.
To delete a record in a table, follow these steps:
- In the table, select the row that contains the record you want to delete.
- On the Data tab, in the Records group, click Delete.
- In the Microsoft Office Excel dialog box that appears, click Yes.
Option A is incorrect because deleting a column from a worksheet does not delete any records.
Option B is incorrect because the Data Form dialog box is not used to delete records.
Option D is incorrect because the Delete button on the Standard toolbar is used to delete cells, not records.