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

📌 Scenario 61
Question: You have sales data for multiple products and want to calculate the average sales only for products belonging to the "Electronics" category. How would you do it?
Answer: Use AVERAGEIF().
Example:
=AVERAGEIF(A:A,"Electronics",B:B)
This calculates the average sales for the Electronics category.

📊 Scenario 62
Question: Your manager wants to find the percentage change in sales between this month and last month. How would you calculate it?
Answer: Use the percentage change formula:
=(Current_Sales-Previous_Sales)/Previous_Sales
Example:
=(B2-A2)/A2
Format the result as a Percentage.

📅 Scenario 63
Question: You need to identify whether an order was delivered late based on the promised date and actual delivery date. How would you do it?
Answer: Use IF().
Example:
=IF(C2>B2,"Late","On Time")
Where B2 is the promised date and C2 is the actual delivery date.

📈 Scenario 64
Question: You need to calculate the total number of sales transactions, excluding blank cells. How would you do it?
Answer: Use COUNT().
Example:
=COUNT(B2:B1000)
This counts cells containing numeric values.

🔍 Scenario 65
Question: Your dataset has inconsistent country names such as "India", "india", and "INDIA". How can you standardize them?
Answer: Use UPPER(), LOWER(), or PROPER() depending on the required format.
Example:
=PROPER(A2)
This converts variations such as "india" and "INDIA" into "India".

💬 Double Tap ♥️ For More!