Common Validations are - List, Date, Time, Text Length etc.
List Validation - It will create a drop down containing a range or defined values
Select the Cell/Range to Validate -> Goto Data -> Data Validation -> select the Validation criteria here and press OK. Now cell will take only defined values
Circle Invalid Data - It will put circle on cell containing Invalid values, when validation is defined after entering values.
