โ
Excel Scenario-Based Questions for Interview & Practice ๐ง ๐
๐ Scenario 86
Question: You have a sales dataset with multiple transactions for the same customer. Your manager wants to calculate each customer's total sales without creating a Pivot Table. How would you do it?
Answer: Use SUMIF().
Example:
=SUMIF($A$2:$A$100,A2,$B$2:$B$100)
Where A contains Customer IDs and B contains Sales.
๐ Scenario 87
Question: You need to find the percentage of sales contributed by each region compared with total company sales. How would you calculate it?
Answer: Divide the region's sales by the total sales.
Example:
=B2/SUM($B$2:$B$10)
Format the result as a Percentage.
๐
Scenario 88
Question: Your manager wants to know whether each transaction occurred on a weekend. How would you identify it?
Answer: Use WEEKDAY() with IF().
Example:
=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")
With 2 as the second argument, Monday = 1 and Sunday = 7.
๐ Scenario 89
Question: You have a list of sales values and need to calculate the median sales amount instead of the average. Which function would you use?
Answer: Use MEDIAN().
Example:
=MEDIAN(B2:B100)
This returns the middle value when the sales values are arranged in order.
๐ Scenario 90
Question: Your dataset contains product names with unwanted line breaks copied from another system. How would you remove them?
Answer: Use CLEAN().
Example:
=CLEAN(A2)
For extra spaces as well, you can combine it with TRIM():
=TRIM(CLEAN(A2))
๐ฌ Double Tap โฅ๏ธ For More!
3August 22, 2026 737 1
