Your question is Using Excel for Financial Analysis. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are given a financial dataset in Excel and need to turn it into a usable analysis for decision-making. The goal is to explain how you would structure the workbook, clean the data, and calculate key financial metrics.
Explain how you would use Excel to perform a financial analysis. Focus on the workflow you would follow, the formulas or features you would use, and how you would present the results clearly.
Keep your answer practical and structured. The interviewer expects you to cover data preparation, core calculations, and how you would summarize findings for finance stakeholders.