described below

I. location, the location of data validity in excel table. Note that the name is Data Validation.

Second, the type, the type of validity verification is shown in the figure below. This option Excel is the same as WPS, which will be explained together later, without distinction. Use Excel20 16 for all screenshots. By default, the validation condition is "any value", which means that no data validation is required and any value can be used. Verify other options accordingly.

Thirdly, the verification of "sequence" is common in daily use.