which of the following option when selected deletes all data validations?
Answers
Answered by
19
HEY MATE HERE IS YOUR ANSWER
•Select the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.
•Click Data >Data Validation.
•On the Settings tab, click Clear All.
•Click OK.
PLEASE MARK ME AS THE BRAINLIST ANSWER AND FOLLOW ME ALSO....
•Select the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.
•Click Data >Data Validation.
•On the Settings tab, click Clear All.
•Click OK.
PLEASE MARK ME AS THE BRAINLIST ANSWER AND FOLLOW ME ALSO....
Answered by
8
Delete all option is used when selected deletes all data validation.
Option (b)
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. This option selects the cell and removes all formatting contained in the cell.
- In this way 'data validation' is also removed from the selected cell. Only 'delete' option cannot be used in this case because it deletes the formula only from the cell and not the validation.
Learn more about data validation
What is data validation
https://brainly.in/question/5032468
Write any two data validation condition
https://brainly.in/question/5838545
Similar questions