✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 101
Question: You have a list of employees and their sales. You need to return the employee name who achieved the highest sales. How would you do it?

Answer: Use "XLOOKUP()" with "MAX()".

Example: "=XLOOKUP(MAX(B2:B100),B2:B100,A2:A100)"

This returns the employee associated with the highest sales.

📊 Scenario 102
Question: Your manager wants to calculate the total sales for the current month automatically. How would you do it?

Answer: Use "SUMIFS()" with date boundaries.

Example: "=SUMIFS(B:B,A:A,">="&EOMONTH(TODAY(),-1)+1,A:A,"<="&EOMONTH(TODAY(),0))"

This calculates sales from the first day through the last day of the current month.

📅 Scenario 103
Question: You need to determine the number of days between an order date and delivery date, but negative values should not appear. How would you handle it?

Answer: Use "MAX()".

Example: "=MAX(0,C2-B2)"

This returns the actual number of days when the delivery date is later, otherwise it returns "0".

📈 Scenario 104
Question: Your dataset contains sales values with occasional negative numbers representing refunds. Your manager wants total sales excluding refunds. How would you calculate it?

Answer: Use "SUMIF()" with a condition greater than zero.

Example: "=SUMIF(B2:B1000,">0",B2:B1000)"

This adds only positive sales values.

🔍 Scenario 105
Question: You have a column containing "First Name", "Last Name", and "Department", and you need to create a unique employee identifier such as "John_Smith_IT". How would you do it?

Answer: Combine the fields using "&" or "TEXTJOIN()".

Example: "=TEXTJOIN("_",TRUE,A2,B2,C2)"

This combines the values using an underscore separator.

💬 Double Tap ♥️ For More!