Data Analyst Excel Test Example for Interviews 2024 | Intermediate

[@YiannisPi]

How long did it take you to complete this test?

[@ergaming3335]

today i am going to do this and then i will let you know much it would take

[@YiannisPi]

waiting to see!

[@ergaming3335]

@@YiannisPi it took me around 1 hour because i am at beginner😶

[@YiannisPi]

@@ergaming3335 No worries! with practice you will bring it down to less than 15 mins!

[@tatasmit]

Hello, Yiannis! Thank you for your video, very helpful!! should we ignore some empty cells that have effect on results? or ask for clarification?

[@YiannisPi]

hey, how do they have effect on the result? If you can clarify, always do!

[@tatasmit]

@@YiannisPi I thought it would affect average price but it doesn't. Sorry

[@pallavisingh4527]

Can you please share the excel file to practice?

[@YiannisPi]

check the video description, it's in my git-hub repo

[@jaysonmagee6339]

In the second to last question where it asked for price per average fuel, wouldnt you need to get the average of fuel then do price/Average fuel? you did price/fuel which is just price per fuel, not price per average fuel. I may be wrong just curious. Great video!

[@YiannisPi]

You are right, it's down to interpretation I would say as both can work. My question should have been cleared

[@jaysonmagee6339]

@@YiannisPi thank you!

[@me-zv4so]

I have test tomorrow thanks soo much for this🥲

[@YiannisPi]

Best of luck!

[@me-zv4so]

@YiannisPi thankss mann watching this whole series...can you suggest what else shld i prepare for excel round