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

📌 Scenario 36
Question: Your manager asks you to return the second highest sales value in the dataset. How would you do it?
Answer: Use the "LARGE()" function.
Example:
=LARGE(B:B,2)
This returns the second highest sales value.

📊 Scenario 37
Question: You need to highlight all duplicate Employee IDs automatically whenever new data is added. How do you do it?
Answer: Use Conditional Formatting → Highlight Cells Rules → Duplicate Values.
Any duplicate Employee ID will be highlighted automatically.

📅 Scenario 38
Question: You want to calculate the age of an employee from their Date of Birth. How would you do it?
Answer: Use the "DATEDIF()" function.
Example:
=DATEDIF(A2,TODAY(),"Y")
This returns the employee's age in years.

📈 Scenario 39
Question: Your manager wants to know whether each employee has achieved the sales target of ₹75,000. How do you display the result?
Answer: Use the "IF()" function.
Example:
=IF(B2>=75000,"Achieved","Not Achieved")

🔍 Scenario 40
Question: You need to display today's date automatically whenever the workbook is opened. How do you do it?
Answer: Use the "TODAY()" function.
Example:
=TODAY()
It automatically updates to the current date whenever the workbook is recalculated.

💬 Double Tap ♥️ For More!