Most common Excel Interview Test Questions you need to know.
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...

🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62ffa6...

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/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS

SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok -   / career_principles  
🧑‍💻 LinkedIn -   / careerprinciples  

GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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.