*Complete scenario-based Excel Interview questions with answers* 📊 1️⃣ *Q: How do you calculate Year-to-Date (YTD) sales for only the "Electronics" category in Excel?* *A:* Use `=SUMIFS(Sales[Amount], Sales[Category], "Electronics", Sales[Date], "<="&TODAY())` to sum sales for "Electronics" up to today. 2️⃣ *Q: How can you find the difference in sales between the current and previous month?* *A:* Subtract last month’s sales from this month’s using `=SUMIFS(Sales[Amount], Sales[Month], "May") - SUMIFS(Sales[Amount], Sales[Month], "April")`. 3️⃣ *Q: How do you filter and display only customers with sales above ₹50,000?* *A:* Use `=FILTER(CustomerList, Sales[Amount]>50000)` in Excel 365, or apply an auto-filter for older versions. 4️⃣ *Q: How do you calculate a running total of sales by region?* *A:* Use `=SUMIFS(Sales[Amount], Sales[Region], A2, Sales[Date], "<="&B2)` where A2 is the region and B2 is the date. 5️⃣ *Q: How do you calculate each product’s percentage contribution to total sales?* *A:* Use `=SUMIFS(Sales[Amount], Sales[Product], A2) / SUM(Sales[Amount])` where A2 is the product name. *React ❤️ for more*