𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
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
Question: How would you calculate the total salary for employees who belong to the IT department and earn more than 80,000?
𝗠𝗲: Challenge accepted! 💪
💡 Explanation:
The SUMIFS() function adds values based on multiple conditions.
• C2:C6 is the range to sum (Salary)
• B2:B6,"IT" includes only employees from the IT department
• C2:C6,">80000" includes only salaries greater than 80,000
Excel returns the total salary for employees meeting both conditions.
This challenge tests your understanding of:
✅ SUMIFS()
✅ Multiple Criteria
✅ Conditional Aggregation
✅ Data Analysis
🎯 Expected Output Example
Formula:
Result: 82,000
(Only Mike meets both conditions.)
🚀 Bonus (Using Cell References for Dynamic Criteria)
If:
E2 = IT
F2 = 80000
The formula becomes dynamic and updates automatically when the criteria change.
🚀 Tip for Excel Job Seekers:
SUMIFS() is one of the most frequently used Excel functions in reporting and dashboards. Be comfortable using it with multiple conditions such as:
Department + Salary
Region + Month
Product + Category
Employee + Performance
Mastering SUMIFS() is essential for Excel interviews and real-world business reporting.
❤️ React with ❤️ for more Excel interview challenges!
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
Question: How would you calculate the total salary for employees who belong to the IT department and earn more than 80,000?
𝗠𝗲: Challenge accepted! 💪
=SUMIFS(C2:C6,B2:B6,"IT",C2:C6,">80000")
💡 Explanation:
The SUMIFS() function adds values based on multiple conditions.
• C2:C6 is the range to sum (Salary)
• B2:B6,"IT" includes only employees from the IT department
• C2:C6,">80000" includes only salaries greater than 80,000
Excel returns the total salary for employees meeting both conditions.
This challenge tests your understanding of:
✅ SUMIFS()
✅ Multiple Criteria
✅ Conditional Aggregation
✅ Data Analysis
🎯 Expected Output Example
Formula:
=SUMIFS(C2:C6,B2:B6,"IT",C2:C6,">80000") Result: 82,000
(Only Mike meets both conditions.)
🚀 Bonus (Using Cell References for Dynamic Criteria)
=SUMIFS(C2:C6,B2:B6,E2,C2:C6,">"&F2)
If:
E2 = IT
F2 = 80000
The formula becomes dynamic and updates automatically when the criteria change.
🚀 Tip for Excel Job Seekers:
SUMIFS() is one of the most frequently used Excel functions in reporting and dashboards. Be comfortable using it with multiple conditions such as:
Department + Salary
Region + Month
Product + Category
Employee + Performance
Mastering SUMIFS() is essential for Excel interviews and real-world business reporting.
❤️ React with ❤️ for more Excel interview challenges!
❤5
🚀 𝗧𝗼𝗽 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗔𝘀𝗸𝗲𝗱 𝗯𝘆 𝗟𝗲𝗮𝗱𝗶𝗻𝗴 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 📊
💼 Companies hiring Power BI professionals include: Microsoft, Deloitte, Accenture, Capgemini, TCS, Infosys, Cognizant, EY, PwC, KPMG, IBM, Wipro, and many more.
✅ Frequently Asked Interview Questions
✅ Beginner to Advanced Level Coverage
✅ Improve Your Problem-Solving Skills
✅ Build Interview Confidence
✅ Prepare for Top MNC Hiring Drives
𝐋𝐢𝐧𝐤👇:-
https://pdlink.in/4xqxg6v
🔥 Master Power BI interview concepts and take one step closer to landing your dream Data Analytics job!
💼 Companies hiring Power BI professionals include: Microsoft, Deloitte, Accenture, Capgemini, TCS, Infosys, Cognizant, EY, PwC, KPMG, IBM, Wipro, and many more.
✅ Frequently Asked Interview Questions
✅ Beginner to Advanced Level Coverage
✅ Improve Your Problem-Solving Skills
✅ Build Interview Confidence
✅ Prepare for Top MNC Hiring Drives
𝐋𝐢𝐧𝐤👇:-
https://pdlink.in/4xqxg6v
🔥 Master Power BI interview concepts and take one step closer to landing your dream Data Analytics job!
❤1
𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
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 employee with the highest salary in the IT department?
𝗠𝗲: Challenge accepted! 💪
💡 Explanation:
This formula combines MAXIFS() and XLOOKUP() to find the employee with the highest salary within a specific department.
MAXIFS() finds the highest salary where the department is IT.
XLOOKUP() searches for that salary in the Salary column.
It returns the corresponding employee name.
This challenge tests your understanding of:
✅ MAXIFS()
✅ XLOOKUP()
✅ Multiple Criteria
✅ Combining Excel Functions
🎯 Expected Output Example
Department | Highest Salary | Employee
IT | 82,000 | Mike
🚀 Bonus (Dynamic Department)
If cell E2 contains the department name:
Now you can change E2 to HR, Finance, or another department and get the corresponding highest-paid employee.
⚠️ Interview Tip:
If two employees have the same highest salary, XLOOKUP() returns the first matching employee. Be ready to explain how you would modify the formula if the interviewer wants all employees tied for the highest salary.
❤️ React with ❤️ for more Excel interview challenges!
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 employee with the highest salary in the IT department?
𝗠𝗲: Challenge accepted! 💪
=XLOOKUP(
MAXIFS(C2:C6,B2:B6,"IT"),
C2:C6,
A2:A6
)
💡 Explanation:
This formula combines MAXIFS() and XLOOKUP() to find the employee with the highest salary within a specific department.
MAXIFS() finds the highest salary where the department is IT.
XLOOKUP() searches for that salary in the Salary column.
It returns the corresponding employee name.
This challenge tests your understanding of:
✅ MAXIFS()
✅ XLOOKUP()
✅ Multiple Criteria
✅ Combining Excel Functions
🎯 Expected Output Example
Department | Highest Salary | Employee
IT | 82,000 | Mike
🚀 Bonus (Dynamic Department)
If cell E2 contains the department name:
=XLOOKUP(
MAXIFS(C2:C6,B2:B6,E2),
C2:C6,
A2:A6
)
Now you can change E2 to HR, Finance, or another department and get the corresponding highest-paid employee.
⚠️ Interview Tip:
If two employees have the same highest salary, XLOOKUP() returns the first matching employee. Be ready to explain how you would modify the formula if the interviewer wants all employees tied for the highest salary.
❤️ React with ❤️ for more Excel interview challenges!
❤7
𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 📊
Start learning with FREE courses from leading companies and build in-demand skills for 2026.
🔹 Data Analytics Essentials — Cisco
🔹 Introduction to Data Science — Cisco
🔹 Python for Data Science — IBM
🔹 Azure Data Fundamentals — Microsoft
🔹 Google Analytics — Google
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-
https://pdlink.in/45QpA1I
🔥 Start learning today and upgrade your resume with job-ready Data & Analytics skills!
Start learning with FREE courses from leading companies and build in-demand skills for 2026.
🔹 Data Analytics Essentials — Cisco
🔹 Introduction to Data Science — Cisco
🔹 Python for Data Science — IBM
🔹 Azure Data Fundamentals — Microsoft
🔹 Google Analytics — Google
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-
https://pdlink.in/45QpA1I
🔥 Start learning today and upgrade your resume with job-ready Data & Analytics skills!
❤2👍1
🚀 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 📊🔥
Build in-demand Data Analytics skills with Microsoft and strengthen your resume with FREE learning opportunities.
✅ Beginner-Friendly
✅ Learn at Your Own Pace
✅ Build Job-Ready Data Skills
✅ Improve Your Resume & LinkedIn Profile
✅ Prepare for Data Analyst & BI Careers
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-
https://pdlink.in/4hXL4Ru
🔥 Start learning today and take your first step toward a career in Data Analytics & Business Intelligence
Build in-demand Data Analytics skills with Microsoft and strengthen your resume with FREE learning opportunities.
✅ Beginner-Friendly
✅ Learn at Your Own Pace
✅ Build Job-Ready Data Skills
✅ Improve Your Resume & LinkedIn Profile
✅ Prepare for Data Analyst & BI Careers
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-
https://pdlink.in/4hXL4Ru
🔥 Start learning today and take your first step toward a career in Data Analytics & Business Intelligence
❤1
15 Advanced Excel Shortcut Keys
• Navigation
1. Move to last used cell → Ctrl + End
2. Move to first cell → Ctrl + Home
3. Select to last used cell → Ctrl + Shift + End
4. Select to first cell → Ctrl + Shift + Home
• Rows Columns
5. Insert entire row → Ctrl + Shift + +
6. Delete entire row → Ctrl + -
7. Hide selected rows → Ctrl + 9
8. Unhide rows → Ctrl + Shift + 9
9. Hide selected columns → Ctrl + 0
10. Unhide columns → Ctrl + Shift + 0
• Formatting
11. Open Format Cells → Ctrl + 1
12. Apply General format → Ctrl + Shift + ~
13. Apply Number format → Ctrl + Shift + !
14. Apply Percentage format → Ctrl + Shift + %
15. Apply Currency format → Ctrl + Shift + $
Double Tap ♥️ For More
• Navigation
1. Move to last used cell → Ctrl + End
2. Move to first cell → Ctrl + Home
3. Select to last used cell → Ctrl + Shift + End
4. Select to first cell → Ctrl + Shift + Home
• Rows Columns
5. Insert entire row → Ctrl + Shift + +
6. Delete entire row → Ctrl + -
7. Hide selected rows → Ctrl + 9
8. Unhide rows → Ctrl + Shift + 9
9. Hide selected columns → Ctrl + 0
10. Unhide columns → Ctrl + Shift + 0
• Formatting
11. Open Format Cells → Ctrl + 1
12. Apply General format → Ctrl + Shift + ~
13. Apply Number format → Ctrl + Shift + !
14. Apply Percentage format → Ctrl + Shift + %
15. Apply Currency format → Ctrl + Shift + $
Double Tap ♥️ For More
❤14🔥1
🚀 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗯𝘆 𝗧𝗼𝗽 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀🔥
Get FREE access to company-specific interview kits, previous questions, preparation strategies, and important resources! 👇
Google :- https://pdlink.in/4xtUyIG
Amazon :- https://pdlink.in/45Q0YWR
Microsoft :- https://pdlink.in/3Up1bha
Wipro :- https://pdlink.in/4fMo1rA
Infosys :- https://pdlink.in/3TRn8p0
📌 share it with friends preparing for placements
Get FREE access to company-specific interview kits, previous questions, preparation strategies, and important resources! 👇
Google :- https://pdlink.in/4xtUyIG
Amazon :- https://pdlink.in/45Q0YWR
Microsoft :- https://pdlink.in/3Up1bha
Wipro :- https://pdlink.in/4fMo1rA
Infosys :- https://pdlink.in/3TRn8p0
📌 share it with friends preparing for placements
𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗿:
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!
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!
❤9
🚀 𝗚𝗼𝗼𝗴𝗹𝗲 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 🎓
Want to upgrade your resume with Google skills and certifications Explore FREE learning opportunities and build in-demand skills for today's job market.
👉Artificial Intelligence & Generative AI
📊 Data Analytics
☁️ Cloud Computing
📢 Digital Marketing
🔐 Cybersecurity
💻 Tech & Career Skills
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-
https://pdlink.in/4z9pdgf
🔥 Don't just collect certificates — build skills that can help you stand out in 2026!
Want to upgrade your resume with Google skills and certifications Explore FREE learning opportunities and build in-demand skills for today's job market.
👉Artificial Intelligence & Generative AI
📊 Data Analytics
☁️ Cloud Computing
📢 Digital Marketing
🔐 Cybersecurity
💻 Tech & Career Skills
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-
https://pdlink.in/4z9pdgf
🔥 Don't just collect certificates — build skills that can help you stand out in 2026!
❤4
𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄e𝗿:
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 second highest salary in the IT department?
𝗠𝗲: Challenge accepted! 💪
=LARGE(FILTER(C2:C6,B2:B6="IT"),2)
💡 Explanation:
This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.
- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.
The result is 75,000.
This challenge tests your understanding of: ✅ FILTER()
✅ LARGE()
✅ Conditional Filtering
✅ Combining Excel Functions
🚀 Bonus (Without FILTER)
For older Excel versions, you can use:
=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)
Here:
14 represents LARGE.
6 ignores errors.
B2:B6="IT" filters the calculation to the IT department.
2 returns the second largest value.
❤️ React with ❤️ for more Excel interview challenges!
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 second highest salary in the IT department?
𝗠𝗲: Challenge accepted! 💪
=LARGE(FILTER(C2:C6,B2:B6="IT"),2)
💡 Explanation:
This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.
- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.
The result is 75,000.
This challenge tests your understanding of: ✅ FILTER()
✅ LARGE()
✅ Conditional Filtering
✅ Combining Excel Functions
🚀 Bonus (Without FILTER)
For older Excel versions, you can use:
=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)
Here:
14 represents LARGE.
6 ignores errors.
B2:B6="IT" filters the calculation to the IT department.
2 returns the second largest value.
❤️ React with ❤️ for more Excel interview challenges!
❤6👍1
🚀 DATA ANALYTICS + AI: YOUR NEXT CAREER MOVE!
Data is everywhere. The right skills can put you ahead.
Join the PW Skills Data Analytics With AI Course and learn Excel, SQL, Python, Power BI & AI tools through live sessions and real-world projects.
✨ What you get:
✅ Industry-relevant Data Analytics skills
✅ AI-powered learning
✅ Microsoft collaboration
✅ Hands-on projects
✅ Job assistance*
✅ Live classes in Hinglish
📅 Starts: 14th August 2026
⏳ Duration: 5 Months
🔥 Ready to become a future-ready Data Analyst?
👉
Enroll Now & Start Your Upskilling Journey!
https://lp.pwskills.com/data-analytics-with-gen-ai-online-course?utm_source=telegram&utm_medium=influencer&utm_campaign=deepakDAonline
Data is everywhere. The right skills can put you ahead.
Join the PW Skills Data Analytics With AI Course and learn Excel, SQL, Python, Power BI & AI tools through live sessions and real-world projects.
✨ What you get:
✅ Industry-relevant Data Analytics skills
✅ AI-powered learning
✅ Microsoft collaboration
✅ Hands-on projects
✅ Job assistance*
✅ Live classes in Hinglish
📅 Starts: 14th August 2026
⏳ Duration: 5 Months
🔥 Ready to become a future-ready Data Analyst?
👉
Enroll Now & Start Your Upskilling Journey!
https://lp.pwskills.com/data-analytics-with-gen-ai-online-course?utm_source=telegram&utm_medium=influencer&utm_campaign=deepakDAonline
❤4