โ
Excel Scenario-Based Questions for Interview & Practice ๐ง ๐
๐ Scenario 91
Question: You have sales data for multiple regions and want to automatically return the region with the highest sales. How would you do it?
Answer: Use "INDEX()" with "MATCH()" and "MAX()".
Example:
"=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10,0))"
This returns the region corresponding to the highest sales value.
๐ Scenario 92
Question: You need to calculate the average sales for transactions greater than โน50,000. How would you do it?
Answer: Use "AVERAGEIF()".
Example:
"=AVERAGEIF(B2:B100,">50000",B2:B100)"
This calculates the average of only those sales values greater than โน50,000.
๐
Scenario 93
Question: You have a list of dates and want to group them into months for reporting. How would you do it?
Answer: Use a Pivot Table.
Add the Date field to Rows โ Right-click any date โ Group โ Select Months (and Years if required).
๐ Scenario 94
Question: Your manager wants to see sales performance visually and interactively by region, product, and month. What would you use?
Answer: Create a Pivot Chart with Slicers.
Create a Pivot Table โ Insert Pivot Chart โ Add slicers for Region, Product, and other relevant fields. This allows users to filter the report interactively.
๐ Scenario 95
Question: You need to identify the 3rd highest unique sales value, even when duplicate sales amounts exist. How would you do it?
Answer: In modern Excel, combine "UNIQUE()" and "LARGE()".
Example:
"=LARGE(UNIQUE(B2:B100),3)"
This returns the 3rd highest distinct sales value.
๐ฌ Double Tap โฅ๏ธ For More!
3August 22, 2026 760 3
