Last 25 seats | Batch closing this week!
โ
โ๐๐ & ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ (๐ก๐ผ ๐๐ผ๐ฑ๐ถ๐ป๐ด ๐ก๐ฒ๐ฒ๐ฑ๐ฒ๐ฑ)
E&ICT Academy, IIT Roorkee is closing admissions for their Data Science & AI Certification on 2nd August 2026.
โ No coding background needed
โ IIT faculty-led program
โ Certificate from E&ICT IIT Roorkee
๐๐ฝ๐ฝ๐น๐ ๐ฏ๐ฒ๐ณ๐ผ๐ฟ๐ฒ ๐๐ฒ๐ฎ๐๐ ๐ณ๐ถ๐น๐น ๐๐ฝ:-
https://pdlink.in/4aYWald
๐ซDeadline: 2nd August 2026
โ
โ๐๐ & ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ (๐ก๐ผ ๐๐ผ๐ฑ๐ถ๐ป๐ด ๐ก๐ฒ๐ฒ๐ฑ๐ฒ๐ฑ)
E&ICT Academy, IIT Roorkee is closing admissions for their Data Science & AI Certification on 2nd August 2026.
โ No coding background needed
โ IIT faculty-led program
โ Certificate from E&ICT IIT Roorkee
๐๐ฝ๐ฝ๐น๐ ๐ฏ๐ฒ๐ณ๐ผ๐ฟ๐ฒ ๐๐ฒ๐ฎ๐๐ ๐ณ๐ถ๐น๐น ๐๐ฝ:-
https://pdlink.in/4aYWald
๐ซDeadline: 2nd August 2026
โค5
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee ID | Employee Name | Sales
--- | --- | ---
101 | John | 12,000
102 | Sarah | 18,000
103 | Mike | 15,000
104 | David | 20,000
How would you return "Yes" if an employee's sales are greater than or equal to 15,000, otherwise return "No"?
๐ ๐ฒ: Challenge accepted! ๐ช
=IF(C2>=15000,"Yes","No")
๐ก Explanation:
The IF() function checks whether a condition is true or false.
C2>=15000 checks if the sales value is at least 15,000.
If the condition is TRUE, Excel returns "Yes".
If the condition is FALSE, Excel returns "No".
๐ฏ Expected Output Example
๐ Bonus (Using Nested IF)
=IF(C2>=20000,"Excellent", IF(C2>=15000,"Good","Needs Improvement"))
This formula categorizes employees into three performance levels:
โข Excellent โ Sales โฅ 20,000
โข Good โ Sales โฅ 15,000
โข Needs Improvement โ Sales < 15,000
๐ The IF() function is one of the most frequently asked Excel interview topics. Once you're comfortable with it, practice:
IFS()
IFERROR()
AND()
OR()
SWITCH()
These logical functions are widely used in reports, dashboards, and business decision-making.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee ID | Employee Name | Sales
--- | --- | ---
101 | John | 12,000
102 | Sarah | 18,000
103 | Mike | 15,000
104 | David | 20,000
How would you return "Yes" if an employee's sales are greater than or equal to 15,000, otherwise return "No"?
๐ ๐ฒ: Challenge accepted! ๐ช
=IF(C2>=15000,"Yes","No")
๐ก Explanation:
The IF() function checks whether a condition is true or false.
C2>=15000 checks if the sales value is at least 15,000.
If the condition is TRUE, Excel returns "Yes".
If the condition is FALSE, Excel returns "No".
๐ฏ Expected Output Example
+----------+--------+----------+
| Employee | Sales | Eligible |
+----------+--------+----------+
| John | 12,000 | No |
| Sarah | 18,000 | Yes |
| Mike | 15,000 | Yes |
| David | 20,000 | Yes |
+----------+--------+----------+
๐ Bonus (Using Nested IF)
=IF(C2>=20000,"Excellent", IF(C2>=15000,"Good","Needs Improvement"))
This formula categorizes employees into three performance levels:
โข Excellent โ Sales โฅ 20,000
โข Good โ Sales โฅ 15,000
โข Needs Improvement โ Sales < 15,000
๐ The IF() function is one of the most frequently asked Excel interview topics. Once you're comfortable with it, practice:
IFS()
IFERROR()
AND()
OR()
SWITCH()
These logical functions are widely used in reports, dashboards, and business decision-making.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค21
๐๐๐ฒ ๐๐๐ญ๐๐ซ ๐๐ฅ๐๐๐๐ฆ๐๐ง๐ญ - ๐๐๐ญ ๐๐ฅ๐๐๐๐ ๐๐ง ๐๐จ๐ฉ ๐๐๐'๐ฌ ๐
Learn Coding From Scratch - Lectures Taught By IIT Alumni
๐ซUpskill on the most in-demand skills in the market
๐๐ถ๐ด๐ต๐น๐ถ๐ด๐ต๐๐:-
๐ผ Avg. Package: โน7.2 LPA | Highest: โน41 LPA
๐ Trusted by 7500+ Students
๐ค 500+ Hiring Partners
Eligibility: BTech / BCA / BSc / MCA / MSc
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ ๐:-
https://pdlink.in/42WOE5H
Hurry! Limited seats are available.๐โโ๏ธ
Learn Coding From Scratch - Lectures Taught By IIT Alumni
๐ซUpskill on the most in-demand skills in the market
๐๐ถ๐ด๐ต๐น๐ถ๐ด๐ต๐๐:-
๐ผ Avg. Package: โน7.2 LPA | Highest: โน41 LPA
๐ Trusted by 7500+ Students
๐ค 500+ Hiring Partners
Eligibility: BTech / BCA / BSc / MCA / MSc
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ ๐:-
https://pdlink.in/42WOE5H
Hurry! Limited seats are available.๐โโ๏ธ
โค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 count the number of unique departments?
๐ ๐ฒ: Challenge accepted! ๐ช
=COUNTA(UNIQUE(B2:B6))
๐ก Explanation:
The UNIQUE() function extracts distinct department names, and COUNTA() counts how many unique values are returned.
UNIQUE(B2:B6) returns: IT, HR, Finance.
COUNTA() counts these unique values.
The result is the total number of unique departments.
This challenge tests your understanding of: โ UNIQUE()
โ COUNTA()
โ Dynamic Arrays
โ Data Analysis
๐ฏ Expected Output Example
Formula | Result
=COUNTA(UNIQUE(B2:B6)) | 3
(The unique departments are IT, HR, and Finance.)
๐ Bonus (For Older Excel Versions)
=SUMPRODUCT((B2:B6<>"")/COUNTIF(B2:B6,B2:B6))
This formula counts unique values without using the UNIQUE() function, making it compatible with older versions of Excel.
๐ Tip for Excel Job Seekers:
Modern Excel functions are becoming increasingly common in interviews. Be familiar with:
UNIQUE()
FILTER()
SORT()
SEQUENCE()
TEXTSPLIT()
These dynamic array functions simplify complex formulas and are widely used in Microsoft 365.
โค๏ธ 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 count the number of unique departments?
๐ ๐ฒ: Challenge accepted! ๐ช
=COUNTA(UNIQUE(B2:B6))
๐ก Explanation:
The UNIQUE() function extracts distinct department names, and COUNTA() counts how many unique values are returned.
UNIQUE(B2:B6) returns: IT, HR, Finance.
COUNTA() counts these unique values.
The result is the total number of unique departments.
This challenge tests your understanding of: โ UNIQUE()
โ COUNTA()
โ Dynamic Arrays
โ Data Analysis
๐ฏ Expected Output Example
Formula | Result
=COUNTA(UNIQUE(B2:B6)) | 3
(The unique departments are IT, HR, and Finance.)
๐ Bonus (For Older Excel Versions)
=SUMPRODUCT((B2:B6<>"")/COUNTIF(B2:B6,B2:B6))
This formula counts unique values without using the UNIQUE() function, making it compatible with older versions of Excel.
๐ Tip for Excel Job Seekers:
Modern Excel functions are becoming increasingly common in interviews. Be familiar with:
UNIQUE()
FILTER()
SORT()
SEQUENCE()
TEXTSPLIT()
These dynamic array functions simplify complex formulas and are widely used in Microsoft 365.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค13
๐ ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ ๐๐ป๐๐ฒ๐ฟ๐ป๐๐ต๐ถ๐ฝ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ ๐
Company Name :- Collegedunia
โ Role: Data Analyst Intern
๐ Location: Gurugram, Haryana
๐ข Work Mode: On-site
๐ฉโ๐ป Experience: Freshers / Students
๐ ๐๐ฝ๐ฝ๐น๐ ๐ก๐ผ๐ ๐:
https://pdlink.in/3RNPbF7
โณ Apply Before the link expires!
Company Name :- Collegedunia
โ Role: Data Analyst Intern
๐ Location: Gurugram, Haryana
๐ข Work Mode: On-site
๐ฉโ๐ป Experience: Freshers / Students
๐ ๐๐ฝ๐ฝ๐น๐ ๐ก๐ผ๐ ๐:
https://pdlink.in/3RNPbF7
โณ Apply Before the link expires!
โค3
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
You have 2 minutes to solve this Excel problem.
You have the following data:
How would you rank each employee based on their sales, with the highest sales getting Rank 1?
๐ ๐ฒ: Challenge accepted! ๐ช
=RANK(C2,C2:C6,0)
๐ก Explanation:
The RANK() function returns the rank of a number within a list.
โข C2 is the sales value to rank.
โข C2:C6 is the fixed range containing all sales values.
โข 0 ranks values in descending order, so the highest sales receive Rank 1.
โข Copy the formula down to rank all employees.
This challenge tests your understanding of: โ RANK()
โ Relative & Absolute References
โ Ranking Data
โ Excel Formulas
๐ฏ Expected Output Example
๐ Bonus (Handle Duplicate Rankings)
=RANK.EQ(C2,C2:C6,0)
Or use:
=RANK.AVG(C2,C2:C6,0)
RANK.EQ() assigns the same rank to duplicate values.
RANK.AVG() assigns the average rank to duplicate values.
๐ Be comfortable using:
โข RANK()
โข RANK.EQ()
โข RANK.AVG()
โข LARGE()
โข SMALL()
These functions are frequently used in sales reports, leaderboards, and performance dashboards.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
You have 2 minutes to solve this Excel problem.
You have the following data:
+----------+--------+
| Employee | Sales |
+----------+--------+
| John | 12,000 |
| Sarah | 18,000 |
| Mike | 15,000 |
| David | 20,000 |
| Alice | 10,000 |
+----------+--------+
How would you rank each employee based on their sales, with the highest sales getting Rank 1?
๐ ๐ฒ: Challenge accepted! ๐ช
=RANK(C2,C2:C6,0)
๐ก Explanation:
The RANK() function returns the rank of a number within a list.
โข C2 is the sales value to rank.
โข C2:C6 is the fixed range containing all sales values.
โข 0 ranks values in descending order, so the highest sales receive Rank 1.
โข Copy the formula down to rank all employees.
This challenge tests your understanding of: โ RANK()
โ Relative & Absolute References
โ Ranking Data
โ Excel Formulas
๐ฏ Expected Output Example
+----------+--------+------+
| Employee | Sales | Rank |
+----------+--------+------+
| John | 12,000 | 4 |
| Sarah | 18,000 | 2 |
| Mike | 15,000 | 3 |
| David | 20,000 | 1 |
| Alice | 10,000 | 5 |
+----------+--------+------+
๐ Bonus (Handle Duplicate Rankings)
=RANK.EQ(C2,C2:C6,0)
Or use:
=RANK.AVG(C2,C2:C6,0)
RANK.EQ() assigns the same rank to duplicate values.
RANK.AVG() assigns the average rank to duplicate values.
๐ Be comfortable using:
โข RANK()
โข RANK.EQ()
โข RANK.AVG()
โข LARGE()
โข SMALL()
These functions are frequently used in sales reports, leaderboards, and performance dashboards.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค14
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
You have 2 minutes to solve this Excel problem.
You have the following data:
How would you return "High Performer" if sales are greater than or equal to 18,000, "Average Performer" if sales are between 12,000 and 17,999, otherwise return "Low Performer"?
๐ ๐ฒ: Challenge accepted! ๐ช
๐ก Explanation:
The IFS() function checks multiple conditions in sequence and returns the result for the first condition that evaluates to TRUE.
โข If sales are 18,000 or more, it returns "High Performer".
โข If sales are 12,000 or more, it returns "Average Performer".
โข Otherwise, it returns "Low Performer".
This challenge tests your understanding of:
โ IFS()
โ Logical Functions
โ Multiple Conditions
โ Data Categorization
๐ฏ Expected Output Example
๐ Bonus (Compatible with Older Excel Versions)
Nested IF() functions provide the same result and work in Excel versions that don't support IFS().
๐ Tip for Excel Job Seekers:
Logical functions are heavily used in reporting and dashboards. Make sure you're comfortable with:
โข IF()
โข IFS()
โข AND()
โข OR()
โข IFERROR()
โค๏ธ React with โค๏ธ for more Excel interview challenges!
You have 2 minutes to solve this Excel problem.
You have the following data:
+----------+--------+
| Employee | Sales |
+----------+--------+
| John | 12,000 |
| Sarah | 18,000 |
| Mike | 15,000 |
| David | 20,000 |
| Alice | 10,000 |
+----------+--------+
How would you return "High Performer" if sales are greater than or equal to 18,000, "Average Performer" if sales are between 12,000 and 17,999, otherwise return "Low Performer"?
๐ ๐ฒ: Challenge accepted! ๐ช
=IFS(
C2>=18000,"High Performer",
C2>=12000,"Average Performer",
TRUE,"Low Performer"
)
๐ก Explanation:
The IFS() function checks multiple conditions in sequence and returns the result for the first condition that evaluates to TRUE.
โข If sales are 18,000 or more, it returns "High Performer".
โข If sales are 12,000 or more, it returns "Average Performer".
โข Otherwise, it returns "Low Performer".
This challenge tests your understanding of:
โ IFS()
โ Logical Functions
โ Multiple Conditions
โ Data Categorization
๐ฏ Expected Output Example
Employee: John
Sales: 12,000
Performance: Average Performer
Employee: Sarah
Sales: 18,000
Performance: High Performer
Employee: Mike
Sales: 15,000
Performance: Average Performer
Employee: David
Sales: 20,000
Performance: High Performer
Employee: Alice
Sales: 10,000
Performance: Low Performer
๐ Bonus (Compatible with Older Excel Versions)
=IF(C2>=18000,
"High Performer",
IF(C2>=12000,
"Average Performer",
"Low Performer"))
Nested IF() functions provide the same result and work in Excel versions that don't support IFS().
๐ Tip for Excel Job Seekers:
Logical functions are heavily used in reporting and dashboards. Make sure you're comfortable with:
โข IF()
โข IFS()
โข AND()
โข OR()
โข IFERROR()
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค17
๐ ๐ ๐ฎ๐๐๐ฒ๐ฟ ๐๐ป-๐๐ฒ๐บ๐ฎ๐ป๐ฑ ๐ฆ๐ธ๐ถ๐น๐น๐ ๐ณ๐ผ๐ฟ ๐๐ฅ๐๐! ๐ป๐ฅ
Want to future-proof your career without spending a single rupee? These 4 beginner-friendly FREE courses will help you build practical, job-ready skills
๐ FREE Courses Included
๐ Business Intelligence Using Excel
๐ค Generative AI for Beginners
๐ป C Programming for Beginners
๐ซ Python Interview Questions & Answers
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4hSgTuW
๐ฅ Don't waitโstart learning today and unlock better career opportunities!
Want to future-proof your career without spending a single rupee? These 4 beginner-friendly FREE courses will help you build practical, job-ready skills
๐ FREE Courses Included
๐ Business Intelligence Using Excel
๐ค Generative AI for Beginners
๐ป C Programming for Beginners
๐ซ Python Interview Questions & Answers
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4hSgTuW
๐ฅ Don't waitโstart learning today and unlock better career opportunities!
โค2
๐ฏ ๐ง๐ผ๐ฝ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐ | ๐๐ผ๐ผ๐ธ ๐๐ฅ๐๐ ๐๐ผ๐๐ป๐๐ฒ๐น๐น๐ถ๐ป๐ด ๐ฆ๐ฒ๐๐๐ถ๐ผ๐ป ๐๐ป ๐๐ต๐ฒ๐ป๐ป๐ฎ๐ถ๐
โ
Learnfrom India's Best Mentors , Get 100% Placement Assistance
๐ซData Analytics :- https://pdlink.in/4q59ef1
โ
๐ซFullstack :- https://pdlink.in/4he12a2
โ
๐ซAI :- https://pdlink.in/4he5mpO
โ
In Today's competitive world, you need industry-relevant skills taught by the best.
โ
Learnfrom India's Best Mentors , Get 100% Placement Assistance
๐ซData Analytics :- https://pdlink.in/4q59ef1
โ
๐ซFullstack :- https://pdlink.in/4he12a2
โ
๐ซAI :- https://pdlink.in/4he5mpO
โ
In Today's competitive world, you need industry-relevant skills taught by the best.
โค1
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee: Joining Date
John: 15-Jan-2022
Sarah: 20-Mar-2021
Mike: 10-Jul-2023
David: 05-Nov-2020
How would you calculate the number of years each employee has worked in the company?
๐ ๐ฒ: Challenge accepted! ๐ช
Formula:
=DATEDIF(B2,TODAY(),"Y")
๐ก Explanation:
The DATEDIF() function calculates the difference between two dates.
B2 is the employee's joining date.
TODAY() returns the current date.
"Y" returns the number of completed years between the two dates.
Copy the formula down to calculate the years of service for all employees.
This challenge tests your understanding of:
โ DATEDIF()
โ TODAY()
โ Date Functions
โ Employee Tenure Calculation
๐ฏ Expected Output Example
Employee: Joining Date: Years of Service
John: 15-Jan-2022: 4
Sarah: 20-Mar-2021: 5
Mike: 10-Jul-2023: 3
David: 05-Nov-2020: 5
Results will change automatically as time passes because TODAY() is dynamic.
๐ Bonus: Calculate Complete Years and Months
=DATEDIF(B2,TODAY(),"Y")&" Years "&DATEDIF(B2,TODAY(),"YM")&" Months"
Example Output:
4 Years 6 Months
2 Years 3 Months
๐ Tip for Excel Job Seekers:
Date functions are commonly asked in Excel interviews. Make sure you're comfortable with:
TODAY(), NOW(), DATEDIF(), EDATE(), EOMONTH(), YEAR(), MONTH(), DAY()
These functions are widely used in HR, finance, payroll, and reporting.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee: Joining Date
John: 15-Jan-2022
Sarah: 20-Mar-2021
Mike: 10-Jul-2023
David: 05-Nov-2020
How would you calculate the number of years each employee has worked in the company?
๐ ๐ฒ: Challenge accepted! ๐ช
Formula:
=DATEDIF(B2,TODAY(),"Y")
๐ก Explanation:
The DATEDIF() function calculates the difference between two dates.
B2 is the employee's joining date.
TODAY() returns the current date.
"Y" returns the number of completed years between the two dates.
Copy the formula down to calculate the years of service for all employees.
This challenge tests your understanding of:
โ DATEDIF()
โ TODAY()
โ Date Functions
โ Employee Tenure Calculation
๐ฏ Expected Output Example
Employee: Joining Date: Years of Service
John: 15-Jan-2022: 4
Sarah: 20-Mar-2021: 5
Mike: 10-Jul-2023: 3
David: 05-Nov-2020: 5
Results will change automatically as time passes because TODAY() is dynamic.
๐ Bonus: Calculate Complete Years and Months
=DATEDIF(B2,TODAY(),"Y")&" Years "&DATEDIF(B2,TODAY(),"YM")&" Months"
Example Output:
4 Years 6 Months
2 Years 3 Months
๐ Tip for Excel Job Seekers:
Date functions are commonly asked in Excel interviews. Make sure you're comfortable with:
TODAY(), NOW(), DATEDIF(), EDATE(), EOMONTH(), YEAR(), MONTH(), DAY()
These functions are widely used in HR, finance, payroll, and reporting.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค17๐ฅฐ3
๐ ๐ ๐ฎ๐๐๐ฒ๐ฟ ๐๐ ๐๐ผ๐ฟ ๐๐ฅ๐๐ | ๐ฑ ๐ ๐๐๐-๐ง๐ฎ๐ธ๐ฒ ๐๐ผ๐ผ๐ด๐น๐ฒ ๐๐ ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ฅ
Artificial Intelligence is transforming every industryโand now you can learn directly from Google with 100% FREE AI courses!
๐ฏ Perfect For
๐ Students & Freshers
๐จโ๐ป Software Developers
๐ Data Analysts
๐ซ AI & Machine Learning Aspirants
๐ผ Working Professionals
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/45HWa5Q
๐ฅ Start your AI journey today and stay ahead in the era of Artificial Intelligence!
Artificial Intelligence is transforming every industryโand now you can learn directly from Google with 100% FREE AI courses!
๐ฏ Perfect For
๐ Students & Freshers
๐จโ๐ป Software Developers
๐ Data Analysts
๐ซ AI & Machine Learning Aspirants
๐ผ Working Professionals
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/45HWa5Q
๐ฅ Start your AI journey today and stay ahead in the era of Artificial Intelligence!
โค1
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee | Salary
John | 75,000
Sarah | 60,000
Mike | 82,000
David | 90,000
Alice | 65,000
How would you return the second highest salary?
๐ ๐ฒ: Challenge accepted! ๐ช
=LARGE(B2:B6,2)
๐ก Explanation:
The LARGE() function returns the Nth largest value from a range.
B2:B6 is the range containing salary values.
2 tells Excel to return the second largest value.
In this example, the result is 82,000.
This challenge tests your understanding of:
โ LARGE()
โ Ranking Values
โ Statistical Functions
๐ฏ Expected Output Example
Formula: =LARGE(B2:B6,2) | Result: 82,000
๐ Bonus: Return the Employee Name with the Second Highest Salary
For Microsoft 365 / Excel 2021:
=XLOOKUP(LARGE(B2:B6,2),B2:B6,A2:A6)
For older versions of Excel:
=INDEX(A2:A6,MATCH(LARGE(B2:B6,2),B2:B6,0))
These formulas return Mike, who has the second highest salary.
๐ Tip for Excel Job Seekers:
Interviewers often ask questions involving the Nth highest or Nth lowest value. Make sure you're comfortable with:
โข LARGE()
โข SMALL()
โข RANK()
โข SORT()
โข FILTER()
These functions are frequently used in dashboards, reports, and data analysis tasks.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee | Salary
John | 75,000
Sarah | 60,000
Mike | 82,000
David | 90,000
Alice | 65,000
How would you return the second highest salary?
๐ ๐ฒ: Challenge accepted! ๐ช
=LARGE(B2:B6,2)
๐ก Explanation:
The LARGE() function returns the Nth largest value from a range.
B2:B6 is the range containing salary values.
2 tells Excel to return the second largest value.
In this example, the result is 82,000.
This challenge tests your understanding of:
โ LARGE()
โ Ranking Values
โ Statistical Functions
๐ฏ Expected Output Example
Formula: =LARGE(B2:B6,2) | Result: 82,000
๐ Bonus: Return the Employee Name with the Second Highest Salary
For Microsoft 365 / Excel 2021:
=XLOOKUP(LARGE(B2:B6,2),B2:B6,A2:A6)
For older versions of Excel:
=INDEX(A2:A6,MATCH(LARGE(B2:B6,2),B2:B6,0))
These formulas return Mike, who has the second highest salary.
๐ Tip for Excel Job Seekers:
Interviewers often ask questions involving the Nth highest or Nth lowest value. Make sure you're comfortable with:
โข LARGE()
โข SMALL()
โข RANK()
โข SORT()
โข FILTER()
These functions are frequently used in dashboards, reports, and data analysis tasks.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค11๐ฅ4
๐ ๐ฐ ๐๐ฅ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ง๐ผ ๐๐ผ๐ผ๐๐ ๐ฌ๐ผ๐๐ฟ ๐ฅ๐ฒ๐๐๐บ๐ฒ๐ฅ
Add these 100% FREE certification courses to your resume and gain valuable, job-ready skills that employers look for.
โ 100% FREE Certification Courses
โ Beginner-Friendly Learning
โ Industry-Relevant Skills
โ Self-Paced Online Learning
โ Strengthen Your Resume & LinkedIn Profile
โ Improve Your Job & Internship Opportunities
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4bwkOtA
๐ฅ Invest in your skills today and give your resume the competitive edge it deserves!
Add these 100% FREE certification courses to your resume and gain valuable, job-ready skills that employers look for.
โ 100% FREE Certification Courses
โ Beginner-Friendly Learning
โ Industry-Relevant Skills
โ Self-Paced Online Learning
โ Strengthen Your Resume & LinkedIn Profile
โ Improve Your Job & Internship Opportunities
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4bwkOtA
๐ฅ Invest in your skills today and give your resume the competitive edge it deserves!
โค4
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
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 calculate the highest salary in each department?
๐ ๐ฒ: Challenge accepted! ๐ช
For Excel 365 / Excel 2021:
=MAXIFS(C2:C6,B2:B6,E2)
(Assume cell E2 contains the department name, such as IT.)
๐ก Explanation:
The MAXIFS() function returns the maximum value that meets one or more conditions.
C2:C6 is the salary range.
B2:B6 is the department range.
E2 contains the department to search for.
Excel returns the highest salary for the selected department.
This challenge tests your understanding of: โ MAXIFS()
โ Conditional Functions
โ Data Analysis
๐ฏ Expected Output Example
Department Highest Salary
IT 82,000
HR 65,000
Finance 90,000
๐ Bonus (For Older Excel Versions)
=MAX(IF(B2:B6=E2,C2:C6))
Note: In older Excel versions, confirm this as an array formula by pressing Ctrl + Shift + Enter instead of just Enter.
๐ Tip for Excel Job Seekers:
The MAXIFS() and MINIFS() functions are frequently used in business reporting. Make sure you also practice:
SUMIFS()
COUNTIFS()
AVERAGEIFS()
MAXIFS()
MINIFS()
These are among the most commonly tested Excel functions in interviews and are essential for real-world reporting and dashboard creation.
โค๏ธ 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 calculate the highest salary in each department?
๐ ๐ฒ: Challenge accepted! ๐ช
For Excel 365 / Excel 2021:
=MAXIFS(C2:C6,B2:B6,E2)
(Assume cell E2 contains the department name, such as IT.)
๐ก Explanation:
The MAXIFS() function returns the maximum value that meets one or more conditions.
C2:C6 is the salary range.
B2:B6 is the department range.
E2 contains the department to search for.
Excel returns the highest salary for the selected department.
This challenge tests your understanding of: โ MAXIFS()
โ Conditional Functions
โ Data Analysis
๐ฏ Expected Output Example
Department Highest Salary
IT 82,000
HR 65,000
Finance 90,000
๐ Bonus (For Older Excel Versions)
=MAX(IF(B2:B6=E2,C2:C6))
Note: In older Excel versions, confirm this as an array formula by pressing Ctrl + Shift + Enter instead of just Enter.
๐ Tip for Excel Job Seekers:
The MAXIFS() and MINIFS() functions are frequently used in business reporting. Make sure you also practice:
SUMIFS()
COUNTIFS()
AVERAGEIFS()
MAXIFS()
MINIFS()
These are among the most commonly tested Excel functions in interviews and are essential for real-world reporting and dashboard creation.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค13
๐ ๐๐ฅ๐๐ ๐๐ฟ๐ฒ๐๐ต๐ฒ๐ฟ ๐๐ถ๐ฟ๐ถ๐ป๐ด ๐๐ฟ๐ถ๐๐ฒ | ๐ง๐ฒ๐ฐ๐ต ๐ฅ๐ผ๐น๐ฒ๐ ๐จ๐ฝ ๐๐ผ โน๐ญ๐ฎ ๐๐ฃ๐!๐ฅ
Internship + Pre-Placement Offer
๐ผ Company: GoComet
๐ฐ Stipend: โน30,000โ35,000/Month
๐ PPO: Up to โน12 LPA
๐ Assessment Centres: Pune | Hyderabad | Noida | Chennai | Bangalore
๐ ๐๐ฝ๐ฝ๐น๐ ๐ก๐ผ๐ ๐:
Full Stack Intern:- https://pdlink.in/4z3vF8o
AI First SDET Interns :- https://pdlink.in/4hS1Am2
โณ Limited Hiring Slots Available
Internship + Pre-Placement Offer
๐ผ Company: GoComet
๐ฐ Stipend: โน30,000โ35,000/Month
๐ PPO: Up to โน12 LPA
๐ Assessment Centres: Pune | Hyderabad | Noida | Chennai | Bangalore
๐ ๐๐ฝ๐ฝ๐น๐ ๐ก๐ผ๐ ๐:
Full Stack Intern:- https://pdlink.in/4z3vF8o
AI First SDET Interns :- https://pdlink.in/4hS1Am2
โณ Limited Hiring Slots Available
โค3
๐ ๐๐๐ ๐๐ฅ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐
Upgrade your tech skills with 100% FREE IBM certification courses and build a strong foundation in AI, Data Science, Cloud Computing, SQL, Python, and Machine Learning.
๐ฏ Perfect For
๐ Students & Freshers
๐จโ๐ป Software Developers
๐ Data Analysts
๐ค AI & Data Science Aspirants
๐ผ Working Professionals
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/45KgqDR
๐ฅ Start learning today and prepare yourself for high-paying opportunities in the tech industry!
Upgrade your tech skills with 100% FREE IBM certification courses and build a strong foundation in AI, Data Science, Cloud Computing, SQL, Python, and Machine Learning.
๐ฏ Perfect For
๐ Students & Freshers
๐จโ๐ป Software Developers
๐ Data Analysts
๐ค AI & Data Science Aspirants
๐ผ Working Professionals
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/45KgqDR
๐ฅ Start learning today and prepare yourself for high-paying opportunities in the tech industry!
โค4
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
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