“Here, the data is sorted by the second column in descending order and the first five rows are returned.”

🔟 How would you analyze sales performance month over month in Excel?

Sample Answer:

“I would first aggregate sales by month, usually using a PivotTable or Power Query.

Then I would compare each month's sales with the previous month and calculate the percentage change.”

=(Current_Month-Previous_Month)/Previous_Month

“I would then visualize the trend using an appropriate chart and investigate significant increases or decreases to understand the underlying business reasons.”

📌 Important Excel areas for Data Analyst interviews:

• Lookup functions

• Conditional functions

• Text functions

• Date functions

• PivotTables

• Power Query

• Data cleaning

• Dynamic arrays

• Charts and dashboards

Double Tap ❤️ For More