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