Question:
You want to restrict the values entered in a cell to a specified set, such as hop, skip, jump. Which type of data validation should you use?.
Posted By Admin @ September 03, 2022
You want to restrict the values entered in a cell to a specified set, such as hop, skip, jump. Which type of data validation should you use?.
The data validation that could be used when restricting the values entered in a cell to a specified set, such as hop, skip, jump is Lookup table.
Data validation serves as a way of checking the accuracy and quality of source data before utilization.
Various validation can be performed based on destination constraints or objectives.
Learn more about Data validation at,