When you have worksheets where numerous people have access to input data, you want to make sure that the correct data is inputted to ensure that when you pull stats or information from the worksheet that it is correct.

Data validation allows you to set rules to limit the type of data that can be inserted in to a cell and tell people what information to input into particular cells.