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

📌 Scenario 81

Question: You have a list of sales transactions and need to calculate a running total that updates as you move down the rows. How would you do it?

Answer: Use SUM() with an expanding range.

Example:

=SUM($B$2:B2)

Copy the formula down. Each row will show the cumulative sales up to that transaction.

📊 Scenario 82

Question: Your manager wants to compare this year's sales with last year's sales and calculate the growth percentage. How would you do it?

Answer: Use the percentage growth formula.

Example:

=(B2-C2)/C2

Where B2 is the current year's sales and C2 is the previous year's sales. Format the result as a Percentage.

📅 Scenario 83

Question: You have a list of employee joining dates and want to identify employees who joined within the last 30 days. How would you do it?

Answer: Use IF() with TODAY().

Example:

=IF(AND(A2>=TODAY()-30,A2<=TODAY()),"Joined Last 30 Days","Older")

📈 Scenario 84

Question: Your sales report contains values such as "₹1,000", "₹2,500", and "₹5,000" stored as text. How would you convert them into numbers?

Answer: Remove the currency symbol and convert the remaining text to a number.

Example:

=VALUE(SUBSTITUTE(A2,"₹",""))

This converts the text value into a numeric value that can be used in calculations.

🔍 Scenario 85

Question: You need to compare two lists of Employee IDs and identify which IDs are missing from the second list. How would you do it?

Answer: Use XLOOKUP() with ISNA().

Example:

=IF(ISNA(XLOOKUP(A2,List2!A:A,List2!A:A)),"Missing","Found")

This identifies whether each Employee ID from the first list exists in the second list.

💬 Double Tap ♥️ For More!