Automating Data Entry using Data Validation in Excel

This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...