Write a steps of Vallidation?
Answers
Answered by
1
You can make a list of the entries you will accept for a cell on a worksheet. You can then restrict the cell to accept only entries taken from the list by using the data validation feature.
To create a drop-down list and restrict values in the cell to these entries, follow these steps:
1 Select cell A1.On the Data menu,
2 click Validation.On the Settings tab, 3click List in the Allowdrop-down list.By default, the Ignore blank and In-cell Dropdown check boxes are selected.
4 Do not change them.In the Source box, type a,b,c. Click OK.
NOTES:
You can also enter a named range or cell reference if it contains a list of values. Both must be preceded by an equal sign.
There is a 255 character limitation for this dialog.Cell A1 now has a drop-down list next to it and you can use this list to select the value to enter in the cell.Click the drop-down list and then click any item it contains.This value will be entered in the cell.
NOTE: You can manually enter "a", "b", or "c", (without quotation marks) in the cell; you do not have to select these from the list. If you try to manually enter anything other these values, a stop message appears and you are unable to keep the value in this cell. Your only options are Retry or Cancel.
To create a drop-down list and restrict values in the cell to these entries, follow these steps:
1 Select cell A1.On the Data menu,
2 click Validation.On the Settings tab, 3click List in the Allowdrop-down list.By default, the Ignore blank and In-cell Dropdown check boxes are selected.
4 Do not change them.In the Source box, type a,b,c. Click OK.
NOTES:
You can also enter a named range or cell reference if it contains a list of values. Both must be preceded by an equal sign.
There is a 255 character limitation for this dialog.Cell A1 now has a drop-down list next to it and you can use this list to select the value to enter in the cell.Click the drop-down list and then click any item it contains.This value will be entered in the cell.
NOTE: You can manually enter "a", "b", or "c", (without quotation marks) in the cell; you do not have to select these from the list. If you try to manually enter anything other these values, a stop message appears and you are unable to keep the value in this cell. Your only options are Retry or Cancel.
Answered by
12
In computer science, data validation is the process of ensuring data have undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful. It uses routines, often called "validation rules" "validation constraints" or "check routines", that check for correctness, meaningfulness, and security of data that are input to the system. The rules may be implemented through the automated facilities of a data dictionary, or by the inclusion of explicit application program validation logic.
______________________
I HOPE IT HELPS U.
MARK AS BRAINLIEST ANSWER.
______________________
I HOPE IT HELPS U.
MARK AS BRAINLIEST ANSWER.
Similar questions