Top 10 Excel Interviews Questions - How to pass any Excel Assessment Test

EXCEL INTERVIEW QUESTIONS // Interviewing for a data-focused job or a job that requires Excel skills?
1- Conditional Formatting
2- Absolute Reference vs Relative Cell Reference
3- Spell Checking
4- Removing Duplicated Data
5- Putting a Border around our Table
6- Most frequently used Charts
7- Different Views and their use
8- IF function and how to use it
9- VLOOKUP function and how to use it
10- PIVOT TABLES and how to use them
#dataanalyst #excel

[@samantha6670]

soft music and calm voice, it makes it easier. Thank you.

[@qikong7269]

This is very helpful! Thanks for sharing:)

[@anitachinwe]

Great video! Very easy to follow.

[@thinkpink0608ify]

I can't grasp this for nothing. My previous job didn't use this as much so I feel so new to this.

[@kiransonawane1403]

Nice quality and music of video 😍

[@StepByStepExcelTutorials]

Really useful video especially for those looking to do interview prep, thanks for uploading!

[@kiransonawane1403]

And very nicely u explain everything.

[@samsoninuwa9556]

Thanks so much for everything

[@raysun1681]

Good stuff, thank you.

[@xiaoyangmeng9195]

thank you for your high quality teaching and I like the BGM.

[@SR-om8zy]

This is very usefu! Thank you

[@sachinbodke6694]

very good explain

[@kellyknights1783]

Spelling: F7 on the keyboard is faster

[@DarkGT]

I wish the actual Excel tests were that easy.

[@obakengmasibi7461]

Are they really difficult?...I have an interview and i know excel but I'm not perfect

[@DarkGT]

First and foremost don't worry. It's just a test, you either make it or learn where you need more practice. In both situations you are one step closer to landing a job.
Remember most common interview scenarios. Practice them until you no longer question yourself.
Even if you don't know what to do during the interview you can ask if you can seek the information you need online. This is not a weakness, by doing that quickly, you show you can get out of difficulty with ease on your own. Even if the interviewer say no at the end, just reply - thank you for the opportunity given.
Best of luck.

[@Interestingboy642]

My Excel test tomorrow

[@DarkGT]

@@Interestingboy642 Let me know if you made it. Good luck.

[@obakengmasibi7461]

@@Interestingboy642 good luck brotherman 👍🤝

[@AssistantParth]

helpful

[@hyuming2577]

ty

[@adventurenights7051]

Great

[@berylroy8188]

Wait, how did you highlight the cells for the pie chart?????????????????pls

[@beatricekwamboka6327]

very clear

[@anilhatkar9003]

Can you share one another video on data normalisation

[@shinobabu]

❤

[@joekinder7562]

For switching between relative and absolute referencing you can select the cell in your formula and then press F4 to cycle through referencing type.

[@skyful9]

Can you please provide us with data used in this tutorial?

[@anitachinwe]

You can google "sample excel data free download". This will get you free data to practise on. Good luck!

[@NieImieZLosowymiLiczbami]

Pls dont use pie chart to demonstrate that kind of data.
It's missleading and hard to see what's on the chart

[@DarkGT]

That's why you create annotations in your charts. The person in the video just didn't have a good example for a pie chart. It's just showing the years.

[@paryonoono5019]

Is this for real? Is excel test that easy?

[@tutsecret499]

The music is loud overlapping the voice of the training. Very disrupting. You will get more audience without the music.

[@nairobi203]

If you elminate the background music and change the voice it would be perfect

[@fyro16]

VLOOKUP is outdated 😅

[@jayashreesujay]

Kindly cut the BGM

[@govadaanusha-y2y]

please remove background music🙁

[@HerbSterbermerbler]

The ai voice is terrible.