Project: Student Result & Employee Performance Analyzer

Create a workbook containing two sections.

Part A — Student Result Analyzer

Student	English	Maths	Science	Total	Result	Grade
Amit	78	85	72
Neha	65	35	58
Rahul	92	88	95
Priya	45	52	48
Simran	32	38	41

Required Formulas

Total Marks

=SUM(B2:D2)

Pass/Fail

=IF(AND(B2>=40,C2>=40,D2>=40),”Pass”,”Fail”)

Grade

=IFS(E2>=270,”A+”,E2>=225,”A”,E2>=180,”B”,E2>=120,”C”,E2<120,”Fail”)

Part B — Employee Performance Analyzer

Employee	Sales	Attendance %	Performance
Amit	125000	95%
Neha	85000	92%
Rahul	150000	88%
Priya	45000	96%
Simran	70000	75%

Use IF, AND, OR, IFS, and IFERROR to classify employee performance.

Final Challenge

Create a Logical Decision Dashboard containing:

• Student Pass/Fail
• Student Grade
• Employee Performance
• Target Status
• Error-free calculations
• Conditional formatting for important results