Program Statement

Create a worksheet named "Employee_Analysis" with 10 employee records and perform the following tasks using Excel formulas and features.

---

Task 1: Create the Dataset

Create a table with the columns below and enter 10 records:

---

Task 2: Mathematical Calculations

Add computed columns:

1. Annual Salary → =C2*12 (Basic Salary × 12)
2. Experience Bonus (%) → Nested IF:

• Experience ≥ 5 years → 10%
• Experience 2–4 years → 5%
• Experience < 2 years → 2%

1. Bonus Amount → =Annual Salary * Bonus %

---

Task 3: Logical Functions (IF & Nested IF)

1. Performance Category (Nested IF):

• Score > 4.5 → Excellent
• Score 3.5–4.4 → Very Good
• Score 2.5–3.4 → Good
• Below 2.5 → Needs Improvement

1. Bonus Eligibility:

• Eligible if Performance Score ≥ 3.5 AND Experience ≥ 3 years
• Else → Not Eligible

---

Task 4: Logical + Math Combination

1. Final Bonus Amount → If Eligible → Bonus Amount, else → 0
2. Revised Annual Salary → Annual Salary + Final Bonus Amount

---

Task 5: Advanced Logical Functions

1. Salary Grade (IFS / Nested IF):

• Revised Salary ≥ ₹6,00,000 → Grade A
• ₹4,00,000–₹5,99,999 → Grade B
• Below ₹4,00,000 → Grade C

1. Promotion Recommendation:

• Promote if Grade = A OR Performance Category = Excellent
• Else → Review Required

---

Task 6: Summary Calculations (at the bottom of the sheet)

---

Task 7: Conditional Formatting

• Green Fill → Performance Category = "Excellent"
• Blue Fill → Salary Grade = "A"
• Red Fill → Bonus Eligibility = "Not Eligible"

---

Task 8: Chart Creation

Create a Clustered Column Chart:

• Chart Title: Employee Revised Annual Salary
• X-Axis: Employee Name
• Y-Axis: Revised Annual Salary
• Add data labels showing salary values
• Place the chart in the same worksheet below the table

---

Key Formulas Used

=== Annual Salary ===
=D2*12

=== Experience Bonus % ===
=IF(E2>=5, 10%, IF(E2>=2, 5%, 2%))

=== Bonus Amount ===
=G2*H2

=== Performance Category ===
=IF(F2>4.5,"Excellent",IF(F2>=3.5,"Very Good",IF(F2>=2.5,"Good","Needs Improvement")))

=== Bonus Eligibility ===
=IF(AND(F2>=3.5, E2>=3), "Eligible", "Not Eligible")

=== Final Bonus Amount ===
=IF(J2="Eligible", I2, 0)

=== Revised Annual Salary ===
=G2+K2

=== Salary Grade ===
=IFS(L2>=600000,"A", L2>=400000,"B", L2<400000,"C")

=== Promotion Recommendation ===
=IF(OR(M2="A", N2="Excellent"), "Promote", "Review Required")