Question

Which of the following options when selected deletes all data validation​

Answer 1

Answer:

The data validation is a function in microsoft -excel that is used to restrict the values a user can enter into a cell.⚡⚡

Delete formatting selects the cells from user want to remove all of the formatting.

Delete all delete all contents and format that are contained in the selected cells.

So it deletes all data validation.

Delete formula just delete the formula applied to a cell or a column.

Delete me just deletes the selected cell or row.

Hence the correct answer is (b) delete all

Hope it helps u❄❄

Good Morning♥♥

✨✨✨✨✨✨✨✨

Answer 2

Answer:

Delete all option is used when selected deletes all data validation. Explanation: The function of 'data validation' in MS-Excel is to restrict the value contents entered by a user. To remove this function from a cell one needs to select the "delete all" option.