𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Department Salary

John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000

How would you find the average salary of employees who earn more than 70,000?

𝗠𝗲: Challenge accepted! 💪

=AVERAGEIF(C2:C6,">70000",C2:C6)

💡 Explanation:

AVERAGEIF() calculates the average of values that meet a specific condition.

C2:C6 is the salary range.

">70000" filters salaries greater than 70,000.

The result is the average of the qualifying salaries.

This challenge tests your understanding of: ✅ AVERAGEIF()
✅ Conditional Calculations
✅ Criteria-Based Analysis

🎯 Expected Output Example

Employee Salary

John 75,000
Mike 82,000
David 90,000

Average salary:

82,333.33

🚀 Bonus (Multiple Conditions)

Find the average salary of employees in the IT department who earn more than 70,000:

=AVERAGEIFS(C2:C6,B2:B6,"IT",C2:C6,">70000")

This combines multiple criteria using AVERAGEIFS().

❤️ React with ❤️ for more Excel interview challenges!