MICROSOFT EXCEL PRACTICAL FILE
Subject: Information Technology
Class: XII
Student Name: ____________________
Roll No.: ____________________
School Name: ____________________
Session: 2025–26
INDEX
1. Student Report Card
2. Student Grading System
3. Student Pass / Fail Program
4. Employee Salary Sheet
5. Net Salary Calculation
6. Attendance Sheet
7. Simple Interest Calculator
8. Highest and Lowest Marks
9. VLOOKUP Student Data
10. Chart Program
Practical 1: Student Report Card
Aim: To prepare a student report card and calculate total marks and percentage.
Procedure:
- Open Microsoft Excel and create a new worksheet.
- Enter student details and subject marks.
- Use SUM formula to calculate total marks.
- Calculate percentage using formula.
Formula Used: Total = SUM(C2:F2), Percentage = (Total/400)*100
Result: Student total marks and percentage are calculated successfully.
Practical 2: Student Grading System
Aim: To assign grades based on percentage.
Procedure:
- Use percentage column from report card.
- Apply IF function to assign grades.
Formula Used: IF(H2>=90,"A+",IF(H2>=75,"A",IF(H2>=60,"B",IF(H2>=45,"C","Fail"))))
Result: Grades are displayed correctly.
Practical 3: Student Pass / Fail Program
Aim: To check whether a student has passed or failed.
Procedure:
- Use percentage obtained by student.
- Apply IF function.
Formula Used: IF(H2>=33,"Pass","Fail")
Result: Result shows Pass or Fail.
Practical 4: Employee Salary Sheet
Aim: To calculate gross salary of an employee.
Procedure:
- Create columns for Basic Pay, HRA, DA.
- Use SUM function to calculate gross salary.
Formula Used: Gross Salary = SUM(B2:D2)
Result: Gross salary is calculated.
Practical 5: Net Salary Calculation
Aim: To calculate net salary after deductions.
Procedure:
- Enter gross salary and deductions.
- Subtract deductions from gross salary.
Formula Used: Net Salary = Gross Salary – Deductions
Result: Net salary is calculated correctly.
Practical 6: Attendance Sheet
Aim: To calculate number of absent days.
Procedure:
- Enter total working days.
- Enter present days.
- Subtract present days from total days.
Formula Used: Absent Days = Total Days – Present Days
Result: Absent days are calculated.
Practical 7: Simple Interest Calculator
Aim: To calculate simple interest.
Procedure:
- Enter Principal, Time and Rate.
- Apply simple interest formula.
Formula Used: Simple Interest = (P×T×R)/100
Result: Simple interest is calculated.
Practical 8: Highest and Lowest Marks
Aim: To find highest and lowest marks.
Procedure:
- Select subject marks.
- Use MAX and MIN functions.
Formula Used: Highest = MAX(), Lowest = MIN()
Result: Highest and lowest marks are displayed.
Practical 9: VLOOKUP Student Data
Aim: To retrieve student data using roll number.
Procedure:
- Create two worksheets with student data.
- Use VLOOKUP function.
Formula Used: VLOOKUP(A2,Sheet2!A:B,2,FALSE)
Result: Student data is retrieved.
Practical 10: Chart Program
Aim: To represent data using charts.
Procedure:
- Select data.
- Insert bar or pie chart from Insert menu.
Formula Used: Insert → Chart
Result: Data is represented graphically.