Question

You want to restrict data entry to whole numbers greater than 100. what do you create to enforce this data-entry restriction

Answer 1

You can use data validation to restrict the type of data or the values (say whole numbers greater than 100) that users enter into a cell. The most commonly used data validation is to create a drop-down list to an Excel cell.