Question

write steps for data validation

Answer 1

Data validation is a feature available in Microsoft Excel. It allows you to do the following: 

Make a list of the entries that restricts the values allowed in a cell.

Create a prompt message explaining the kind of data allowed in a cell.

Create messages that appear when incorrect data has been entered.

Check for incorrect entries by using the Auditing toolbar.

Set a range of numeric values that can be entered in a cell.

Determine if an entry is valid based on calculation in another cell.


This article describes some of the ways to use the data validation feature in Microsoft Excel as well as examples to illustrate how to implement this feature. 

NOTE: The examples below assume you are working with a new Microsoft Excel workbook and that you start with the first example and continue through the examples in the order in which they are presented.

Make a List of Entries Allowed in the Cell

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:


Select cell A1.

On the Data menu, click Validation.

On the Settings tab, click List in the Allowdrop-down list.

By default, the Ignore blank and In-cell Dropdown check boxes are selected. 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.