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

📌 Scenario 31 
Question: Your manager asks you to return "Yes" if an Employee ID exists in the master list; otherwise, return "No". How would you do it? 

Answer: Use IF() with COUNTIF(). 
Example: 
=IF(COUNTIF(Master!A:A,A2)>0,"Yes","No") 

_Why it works:_ COUNTIF checks if the ID appears at least once. If >0 then "Yes".

📊 Scenario 32 
Question: You need to calculate the total sales between two specific dates. How would you do it? 

Answer: Use SUMIFS(). 

Example: 
=SUMIFS(B:B,A:A,">="&E2,A:A,"<="&F2) 
Where E2 is the start date and F2 is the end date. 

_Pro tip:_ Make sure column A is actually formatted as dates, not text.

📅 Scenario 33 
Question: Your dataset has several blank rows, and you need to remove them quickly. What should you do? 

Answer: 
Home → Find & Select → Go To Special → Blanks → Right-click → Delete → Entire Row. 

_Alternative:_ Filter for blanks and delete, or use Power Query to remove empty rows.

📈 Scenario 34 
Question: You need to calculate the percentage of total sales contributed by each product. How would you do it? 

Answer: Divide each product's sales by the total sales. 

Example: 
=B2/SUM(B2:B100) 
Format the result as a Percentage. 

_Tip:_ The $ locks the range so you can drag the formula down.

🔍 Scenario 35 
Question: You have multiple worksheets with the same structure, and your manager wants a combined summary. How do you do it? 

Answer: Use Power Query (Data → Get Data → Combine Queries) or use Consolidate (Data → Consolidate) to merge and summarize the data from multiple sheets. 

_Why Power Query wins:_ It auto-updates when new sheets/data are added.

💬 Double Tap ♥️ For More!