Here's the question bank on all the computer awareness topics.
Which allows you to enter only that data in a cell which satisfies the criteria ?
The correct answer is Data validation.Data validation allows you to enter only that data in a cell that satisfies the criteria.Data validation is used to restrict the type of data or the values that users enter into a cell.One of the most common data validation uses is to create a drop-down list.It allows you to enter only that data in a cell that satisfies the criteria.1.We can restrict a user to enter a whole number between 0 and 10. Select B2 Cell. A data validation Pop-Up will open on the screen. On the Settings tab, Click on Allow drop-down under validation Criteria. Select the Whole number, then some more required options will be enabled on the screen. Select between from the drop-down of Data list, Enter the Minimum and Maximum number for restriction. And click on ok option. All settings will apply to the selected cell.Now Enter 1 in cell B2-It will allow a user to enter any whole number from 0 to 10. Now Enter 11 in cell B2- It will show by default error on the screen.
Scan QR code to download our App for
more exam-oriented questions
OR
To get link to download app