Take this Excel Interview Test and Avoid Interview Embarrassment

Excel Interview Test. Can you pass?

In this Excel interview test, you'll be tested in your excel proficiency through a 5-question Excel interview test from easy to hard. The first question is on conditional formatting, the second on using the IF statement and relative referencing. Thirdly, you'll have a data cleaning question using the textsplit formula of the text to columns feature. Fourth, you'll have a data analytics question using pivot tables, and finally you'll hvae a lookup question where you'll learn to use the XLOOKUP and the INDEX MATCH. At the very end, we'll also have a bonus question using the find & replace tool in Excel.

LEARN:

SOCIALS:

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

Chapters:
0:00​ -​ Intro
0:22​ - Q1 (Easy)
1:58​ - Q2 (Comfortable)
4:00​ - Q3 (Intermediate)
6:28​ - Q4 (Hard)
8:13 - Q5 (Very Hard)
10:22 - Bonus Question (Expert)

[ahamedarif]

Thank you Kenji for the test. I have finished the test in 7 min. In the future i want you to make a more video like this. it will help our Excel knowledge. Love you man.

[gemini]

@KenjiExplains, I've been watching your videos for some time now, I was able to complete all the questions without following along with the video, however I will watch now to get other ideas on how to solve. Thank you!

[吉戸凛-ji]

Lied about my experience with excel (haven’t used it in 8 years) and was panicking about a job interview but this video saved my life!

[lunagale]

thank you for going over both the text split formula and the text to columns options. It makes it very accessible.

[lynnw]

Thank you. I took a timed test, only 30 seconds per question and that was daunting.

[abzino]

i learnt something new with the CTRL+H trick, but you still have the space after your sentence, so a cleaner formula would be TEXTBEFORE. In cell D6 enter =TEXTBEFORE(C6, " (").

[malmedia]

For the bonus I probably would have used textsplit or text to columns. But Learning the wildcard option in find and replace it great. I can see myself using that for quick results. Thanks!

[patricksanchez]

That bonus question got me. Thank you! 😊

[qfit]

Excellent Excel proficiency exercises. Keep up the good work!

[lvsingh]

Hi Kenji, I used the function textbefore for the bonus question and used "(" as the delimiter. That worked too.

[excelgazialimuhiddinhacibekir]

Great video and a diverse array of fundamental Excel questions. Thank you Kenji!
For the BONUS QUESTION, I'd go by the formula *=LEFT($C6, SEARCH("(", $C6)-2)* since the parentheses appear only at the end of company names in column C.

[shabchique]

That was fun! I even got the bonus question because I learned it from you, on another video. 😆🙏

[thesonofasniper]

So an excel test I had the other week involved using LEFT to pull a code from a larger file name, using those codes for a v look up on a 2nd sheet. A pivot table for client costs, and some basic maths formula

[stevejauna]

This exercise is great but I thought of a better solution for Q5 which uses SUMIF: =SUMIF(B6:B16, F6, D6:D16). If Sarah was to work part-time in one department and part-time in another, then she would occur twice in the table, so you would need to sum for the two occurences. XLOOKUP would only reference the first occurence. In your example, Xlookup works fine, but only because Sarah only occurs once in the table. Also if instead you wanted to know the revenue for a department like Sales (3 occurences), then SUMIF would be better.

[mysticz]

Hi Kenji, for the last question, I would use text to columns separated by (; your solution is obviously more elegant

[bemohyx]

Really great prep help!! Cheers, Kenji!!, could you do a video on how to make a quality MIS report in excel

[waynez]

I have passed your test using the exact same solutions shown in this video. You are truly my master ^_^

[TerraDefensor]

Awesome video 🤝 Here's an additional solution for your bonus question that works when you need to erase text after or before specific characters. So, you can use the same function REPLACE (CTRL+F) and use (* to delete whole text after it finds last character "( ", or if you want to delete text before certain character you can use logic *( to delete all text before last character in this case "(".
Best regards, Stevan

[willzinner]

had no idea about the * in the bonus q thanks

[lizmcneill]

Great video thanks Kenji. I did another of your excel common questions earlier which really helped when I did this one. Chuffed with myself 🙂