File Name

Data_Validation_Practice.xlsx

Employee Dataset

Employee ID	Employee Name	Department	City	Age	Salary	Joining Date
EMP001	Amit Kumar	Sales	Sirsa	28	35000	10-Jan-2026
EMP002	Neha Sharma	HR	Hisar	32	42000	15-Feb-2026
EMP003	Rahul Singh	IT	Sirsa	29	50000	20-Mar-2026
EMP004	Priya Gupta	Finance	Fatehabad	35	48000	05-Apr-2026
EMP005	Simran Kaur	Marketing	Hisar	26	32000	12-May-2026

Tasks

Task 1 — Department Drop-down

Create:

Sales, HR, IT, Finance, Marketing

Task 2 — City Drop-down

Create:

Sirsa, Hisar, Fatehabad, Abohar

Task 3 — Age Validation

Allow only:

18–60

Task 4 — Salary Validation

Allow:

₹10,000–₹2,00,000

Task 5 — Joining Date

Allow dates only from:

01-Jan-2026 to 31-Dec-2026

Task 6 — Employee ID

Create custom validation to prevent duplicate IDs.

Task 7 — Input Messages

Add appropriate instructions for:

• Age
• Salary
• Department
• Joining Date

Task 8 — Error Alerts

Use Stop for invalid Age and Salary entries.

Final Challenge — Employee Data Entry Form

Create a professional entry form containing:

Field	Validation
Employee ID	Unique
Employee Name	Text
Department	Drop-down
City	Drop-down
Age	18–60
Salary	₹10,000–₹2,00,000
Joining Date	2026 only

The final sheet should allow users to enter data while minimizing incorrect entries.