Can You Pass This Excel Interview Test?

Try this Excel Interview test to see your level!
👉 Take our Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-busines…
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/644287dcb3a5b097c0a5e7df

This Excel Interview Test has a total of 4 questions going from easy to hard. First we use conditional formatting to find the bottom 10 values. Second, we use a combination of an IF and an AND statement to accept or reject a project based on two criteria. Third, we use the goal seek tool on Excel under what if analysis to reach 5000 in profit. Finally, we use 2 different formulas to find the revenue in France for each month. For this we first use a SUMIFS with relative references. Second we use the XLOOKUP combined with the ampersand (&) so we can filter using multiple criteria.

LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation…
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-busines…
🧑‍💻 The Data Analyst Program: www.careerprinciples.com/career-track/the-data-ana…
🚀 All our courses: www.careerprinciples.com/all-courses

SOCIALS:
🎬 My Company YouTube Channel:    / @careerprinciples  
📸 Instagram - www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - www.tiktok.com/@career_principles
🧑‍💻 LinkedIn - www.linkedin.com/company/careerprinciples/

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Question 1 (Easy)
1:17​ - Question 2 (Intermediate)
4:15 - Question 3 (Advanced)
6:30 -Questio