Most common Excel Interview Test Questions you need to know.
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62ffa6861b896ee5dd7f0649
In this video we go over 5 of the most common excel interview test questions for business & finance roles such as a business analyst or a financial analyst. The questions are:
Q1: Use two different formulas to look for a value within a table. You can use vlookup, xlookup, or index match for this
Q2: Find the quantity sold to reach 10k in profit. You can use goal seek under what if analysis for this
Q3: Clean this raw set of data. For this you can use the text to columns feature, alongside the conditional formatting to identify the relevant values
Q4: Visualize the data. For this you can use a combo chart with two different axis
Q5: Show by quarter, the quantity sold, the total sales, and the average sale price. This can be found using a pivot table
Note: there is more than one way to do these questions. If you have any other methods, comment them below!
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Q1
2:25 - Q2
4:03 - Q3
7:03 - Q4
9:08 - Q5
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.