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

[samantha]

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

[thinkpinkify]

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

[DarkGT]

I wish the actual Excel tests were that easy.

[StepByStepExcelTutorials]

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

[qikong]

This is very helpful! Thanks for sharing:)

[kellyknights]

Spelling: F7 on the keyboard is faster

[homelyfoodandfun]

Very informative video.. Thanks alot for sharing😊

[joekinder]

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

[xiaoyangmeng]

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

[berylroy]

Wait, how did you highlight the cells for the pie

[saqibtamboli]

IT'S A VERY USEFULL KNOWLEDGE FOR DATA ANALYSING

[nagasai]

30 seconds into the video and my eyes shut

[tutsecret]

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

[NieImieZLosowymiLiczbami]

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

[anilhatkar]

Can you share one another video on data normalisation

[BlueSkyGoldSun]

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

[nairobi]

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

[paryonoono]

Is this for real? Is excel test that easy?

[francishubertovasquez]

TED, what have you learned when I put you under Christ Rule because you're irritating me every morning upon waking up in radio as if you my fan? Seeing things in Crystals those you want to interact with and those within your group to filter whose spies or not? and voiced things in angular Crystals? I think you've learned something there. Those puppet Angels of yours are murmuring outside. My fans also?