✅ 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!