Question

write steps for data validation

Answer 1

1). Select cell A1.
2). On the data menu, click validtion.
3). On the setting lab, click list in the Allow- drop down list.
4). By default, the ignore blank And in- cell Drop down check boxes are selected.
5). In the Soucre box, type a,b,c.

Hope it Helps! If it plz.. mark as brainliest.

Answer 2

Select one or more cells to validate.

On the Data tab, in the Data Tools group, click Data Validation.

Data Validation is located in Data tab, Data Tools group
On the Settings tab, in the Allow box, select List.

Settings tab in Data Validation dialog box
In the Source box, type your list values, separated by commas.