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

📌 Scenario 51
Question: You have sales data by employee and need to calculate the total sales for each employee. How would you do it?
Answer: Use a Pivot Table.
Select the dataset → Insert → PivotTable → Drag Employee Name to Rows → Drag Sales to Values.

📊 Scenario 52
Question: You need to extract the first 5 characters from an Order ID. How would you do it?
Answer: Use the LEFT() function.
Example:
=LEFT(A2,5)

📅 Scenario 53
Question: You need to extract the last 4 digits of a Customer ID. Which function would you use?
Answer: Use the RIGHT() function.
Example:
=RIGHT(A2,4)

📈 Scenario 54
Question: You have a column containing full names and need to extract only the first name. How would you do it?
Answer: Use TEXTBEFORE() in newer Excel versions.
Example:
=TEXTBEFORE(A2," ")
This extracts everything before the first space.

🔍 Scenario 55
Question: You need to extract the domain name from an email address such as "employee@company.com". How would you do it?
Answer: Use TEXTAFTER().
Example:
=TEXTAFTER(A2,"@")
This returns company.com.

💬 Double Tap ♥️ For More!