โ
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!
4August 24, 2026 924 6
