Try this Excel Interview test to see your level!
Take our Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/644287...

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:
Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
Power BI for Business Analytics: https://www.careerprinciples.com/cour...
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
My Company YouTube Channel:    / @careerprinciples  
Instagram https://www.instagram.com/careerprinc...
TikTok   / career_principles  
‍ LinkedIn   / careerprinciples  

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

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

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.