✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 46
Question: Your sales dataset contains blank cells. Instead of displaying "0", you want the result to appear blank. How would you do it?
Answer: Use the IF() function.
Example:
=IF(A2="","",A2*10)
This returns a blank if A2 is empty; otherwise, it performs the calculation.

📊 Scenario 47
Question: Your manager wants to know how many unique customers made purchases this month. How do you calculate it?
Answer: Excel 365: Use the UNIQUE() function with COUNTA().
Example:
=COUNTA(UNIQUE(A2:A1000))
This returns the count of distinct customers.

📅 Scenario 48
Question: You have sales data in separate worksheets for each month. How do you calculate the total annual sales?
Answer: Use a 3D Reference.
Example:
=SUM(Jan:Dec!B2)
This adds the value in cell B2 across all worksheets from Jan to Dec.

📈 Scenario 49
Question: Your manager wants to identify all transactions above the average sales value. How would you do it?
Answer: Use the AVERAGE() and IF() functions.
Example:
=IF(B2>AVERAGE(B2:B100),"Above Average","Below Average")

🔍 Scenario 50
Question: You need to replace all occurrences of "N/A" with "Not Available" throughout the worksheet. What's the fastest way?
Answer: Use Find & Replace.
Press Ctrl + H → Find what: "N/A" → Replace with: "Not Available" → Click Replace All.

💬 Double Tap ♥️ For More!