✅ Practical Excel Exercises: Mastering Functions, Filters, and Analysis

📘 Excel Practical Questions – IF, VLOOKUP, Pivot Table, Macro & More

✅ IF Function

• Write a formula using IF to return "High" if salary is more than 50,000, and "Low" otherwise.
• Use IF to check if a student scored above 35. If yes, return "Pass", else "Fail".
• Apply nested IF to assign grades:
  • 90+: "A"
  • 80–90: "B"
  • 70–80: "C"
  • <70: "D"
• Check if stock is >= 100, then return "Sufficient"; else return "Reorder Needed".
• Determine if a person is eligible to vote using IF (age ≥ 18).

• Pass/Fail Check:
• If marks are greater than or equal to 40, return "Pass", else return "Fail".
• Grade Assignment:
  If marks are 90 or above, return "A", else return "B".
• Stock Check:
  If quantity is 0, return "Out of Stock", else return "Available".
• Discount Eligibility:
  If purchase amount is ₹1000 or more, return "Eligible", else return "Not Eligible".
• Working Hours:
  If hours worked are more than 8, return "Overtime", else return "No Overtime".
• Age Classification:
  If age is 18 or above, return "Adult", else return "Minor".
• Salary Status:
  If salary is greater than ₹30,000, return "High Salary", else return "Low Salary".
• Attendance Check:
  If attendance is greater than or equal to 75, return "Eligible", else return "Not Eligible".
• Even or Odd:
  If the number is divisible by 2, return "Even", else return "Odd".
• Exam Fee Status:
  If student has paid (enter "Yes"), return "Allowed", else return "Not Allowed".
• Free Delivery:
  If order amount is above ₹500, return "Free Delivery", else return "Delivery Charges Apply".
• Recharge Status:
  If recharge is "Yes", return "Active", else return "Inactive".
• Temperature Warning:
  If temperature is above 40°C, return "Too Hot", else return "Normal".
• Employee Attendance:
  If status is "P", return "Present", else return "Absent".
• Income Classification:
  If income is ₹50,000 or more, return "Taxable", else return "Non-Taxable".
• Senior Citizen Check:
  If age is 60 or above, return "Senior Citizen", else return "Not Eligible".
• Membership Discount:
  If customer is a member ("Yes"), return "Discount Applied", else return "No Discount".
• File Size Check:
  If file size is more than 25MB, return "Too Large", else return "Upload Allowed".
• Holiday Check:
  If day is "Sunday", return "Holiday", else return "Working Day".
• Scholarship Eligibility:
  If marks are above 85 and attendance is more than 80, return "Qualified", else return "Not Qualified".
  Hint: Use nested IF or use AND inside the IF function.