Program Statement

Create an Employee Table with the fields: EmpID, EName, Experience, Performance Rating (out of 5). Enter data for 15 employees and add computed columns using logical functions.

---

Dataset (15 Employees)

---

Computed Columns & Formulas

=== 1. Eligibility for Promotion ===
=IF(AND(C2>=5, D2>=4), "Eligible", "Not Eligible")

=== 2. Job Status ===
=IF(D2<2, "Needs Improvement", "Satisfactory")

=== 3. Performance Grade (Nested IF) ===
=IF(D2>=4.5,"Excellent", IF(D2>3.5,"Very Good", IF(D2>=2.5,"Good","Poor")))

=== 4. Salary Increment Status (Nested IFS) ===
=IF(AND(C2>=8,D2>=4),"High Increment",
   IF(AND(C2>=5,D2>=3),"Medium Increment",
      IF(AND(C2>=2,D2>=2),"Low Increment","No Increment")))

---

Output & Formatting Steps

Conditional Formatting:

1. Select the Performance Grade column
2. Home → Conditional Formatting → Highlight Cell Rules → Equal To → "Excellent" → Green Fill
3. Repeat for "Poor" → Red Fill

Sort in Descending Order of Performance Rating:

1. Click any cell in the Performance Rating column
2. Data → Sort → Sort by: Performance Rating → Order: Largest to Smallest
3. Click OK