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

📌 Scenario 1

Question: You have sales data across multiple regions and want to summarize total sales per region.

Answer: Use a Pivot Table: Select the data → Insert → PivotTable → Drag Region to Rows and Sales to Values.

🔁 Scenario 2

Question: You need to clean a dataset with extra spaces, duplicate entries, and inconsistent text formats.

Answer:

• Use TRIM() to remove extra spaces.

• Use REMOVE DUPLICATES under the Data tab.

• Use PROPER(), UPPER(), or LOWER() for text formatting.

📆 Scenario 3

Question: You want to calculate the number of working days between two dates.

Answer: Use NETWORKDAYS(StartDate, EndDate) to exclude weekends and optionally holidays.

🔒 Scenario 4

Question: You’re sharing a file with sensitive formulas. How do you prevent others from editing them?

Answer:

• Select formula cells → Right-click → Format Cells → Protection tab → Lock.

• Then go to Review → Protect Sheet with a password.

📈 Scenario 5

Question: How do you automatically highlight all sales below the monthly target of ₹50,000?

Answer: Use Conditional Formatting → New Rule → Format cells that are less than ₹50,000 → Apply color.

💬 Double Tap ♥️ For More!