๐ Scenario 1:
Question: You're given a huge dataset of customer orders. How would you identify the top 5 customers by total sales?
Answer:
I would use a Pivot Table to summarize sales by customer. Then, Iโd sort the sales column in descending order and filter the top 5 customers using the "Top 10 Filter" option in the Pivot Table.
๐ Scenario 2:
Question: You find duplicate entries in your Excel sheet. How would you identify and remove them efficiently?
Answer:
Iโd select the relevant data range, go to the Data tab, and use the Remove Duplicates feature. Before removing, I might highlight duplicates using Conditional Formatting for visual confirmation.
๐ Scenario 3:
Question: You need to calculate the number of working days between two dates excluding weekends and holidays. What function would you use?
Answer:
I would use the NETWORKDAYS() function.
Example:
=NETWORKDAYS(start_date, end_date, holidays_range)๐ Scenario 4:
Question: You want to track monthly sales trends over time. How would you visualize this in Excel?
Answer:
Iโd summarize the data in a Pivot Table by month, then insert a Line Chart or Column Chart to visualize trends clearly.
โ๏ธ Scenario 5:
Question: You need to apply the same formula across thousands of rows. What's the best way?
Answer:
Iโd write the formula in the first cell and double-click the fill handle to auto-fill it down. Alternatively, I could use structured tables or dynamic arrays for efficiency.
๐ Double Tap โฅ๏ธ For More