Question Bank - Computer Awareness

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 ?

A.
Data validation
B.
Data mailing
C.
Data definition
D.
Data design

Solution:

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.

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.