5 Excel Questions Asked in Job Interviews ☑️

Рет қаралды 3,303,009

Күн бұрын

Top 5 Excel Interview Questions.Download File www.myelesson.org These MS Excel interview questions and answers are for you if are applying for a job and need to do an Excel interview. With these 5 Excel Interview questions, you can get some practice in before your Job Interview.
Download the excel sheet from this link -
www.myelesson.org
These are the top frequently asked MS Excel interview questions and answers in any Excel Job Interview test.
Almost every job these days requires you to have a basic, functional knowledge of Excel. Excel is the top spreadsheet application in the world with over a billion users, and most offices rely on Excel for many daily tasks.
If you’re applying for jobs that require any amount of tracking, data, or simple calculations, you will be expected to know Excel.
Here are some interview questions you could expect at a job interview.
Vlookup Formula in Excel
Make Charts in Excel
Use Pivot Table in Excel
Remove Duplicates in Excel
Protect Sheet in Excel
www.myelesson.org/excel-traini...
10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.org/product or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy 10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...

Пікірлер: 1 200

@RozyRoPink150 2 жыл бұрын

As a 46 year old novice who has been avoiding excel for over 20 years due to lack of confidence and anxiety, I love when you say “that’s all it is”. It puts me at ease. Thanks.

@GuruJii 2 жыл бұрын

Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

@DanAlexandruGeorge 2 жыл бұрын

@@GuruJii , what queston? Should I Vlookup it?

@davidomondi8036 6 жыл бұрын

Love how you explain in a way simple enough to be understood by practically everyone

@ms.will-i-ams1711 5 жыл бұрын

Your tutorial was so good. I literally almost fell out of my chair when you showed me how to make a chart from F11. Thank you. Most Grateful.

@dimaomar9427 5 жыл бұрын

i like it when you say;tell them yes i can do it, you are the best

@ia2291 5 жыл бұрын

hahaha - me too! :)

@Zonex123 5 жыл бұрын

also on password protection: "if you give this answer, they will be just amazed" hahah great video!

@walterlizama1359 4 жыл бұрын

Me too hahaha

@snarayanak2934 4 жыл бұрын

Yes

@nhevkurd1958 3 жыл бұрын

same here hhhhhh

@pmb5643 4 жыл бұрын

I like his Optimism. 'Yes, I can" [.. if I have the video in front of me at the interview, my thoughts]. Very good. Thanks.

@aubshkabobcabanna7097 6 жыл бұрын

THANK YOU SO MUCH FOR YOUR VIDEO!!!! You are the only one that explained it very well and so easy to follow!

@acoolbeebaugh4293 4 жыл бұрын

Watched a lot of KZfaq videos for excel. This is the perfect, to the point - teacher! Thank you so much for taking the time to do this for us (people job searching).

@bknightify 5 жыл бұрын

I have my 2nd interview next week for executive position you saved me - I havent really explored vlookup yet as I have used excel for 7 years now THANK YOU for making this lesson fun and giving us confidence, I am just going to replay this a few times for memory and practice at home on excel! THANKS

@GuruJii 5 жыл бұрын

Thanks and i wish you best of luck.

@rashmigupta2889 Жыл бұрын

@@GuruJii hii sir campus placement k time interview me jan excel k question poochte hai to kya mouse milta hai?? Kyuki m bina mouse k krti hu to mujhse gltiya ho jaati h bhot

@105mteso 7 жыл бұрын

Love your teaching style! You are clear and quick, thank you so much.

@sakil06 6 жыл бұрын

Your teaching style is simple and effective

@IAmGarimon 6 жыл бұрын

You certainly are a guru! Thank you for the easy to follow instructions!

@isharamadhushani7006 5 жыл бұрын

Your teaching style is very simple and this lesson is very important me...thank you verymuch sir.God bless you..! (from Sri Lanka 🇱🇰 )

@OTG_Youtube 5 жыл бұрын

Amazing. I came back to inform you I just rocked the interview. Thank you so much.

@GuruJii 5 жыл бұрын

Welcome Dexter. Best of luck for the new job

@funkeokeniyi6556 4 жыл бұрын

Congratulations

@reddymekala8549 3 жыл бұрын

In which company you got job bro please reply me bro .iam also a aspirant to get excel related job

@fatinnnnnnn 5 жыл бұрын

You save my life. Thank you for this.

@GuruJii 5 жыл бұрын

Welcome

@noelgonzalez9549 6 жыл бұрын

I don't usually comment on videos but this is a life saver. Well explained and to the point. Thank you!

@gdragon1268 6 жыл бұрын

thank you so much :) Have an interview soon and I've forgot finer points of excel. This was very informative and motivating. catch me in the interview saying YES, SIR. I CAN.

@Kakarbajoinsthefight 2 жыл бұрын

This was an awesome tutorial, sir! Thank very much for your time and information it was greatly appreciated! “Yes, I can do it,” lol👍

@piatale7773 6 жыл бұрын

I'm damm sure nobody can fali in the interview after watching this video. Thanks a lot for this video sir..! You are a genius 👍😇

@GuruJii 6 жыл бұрын

Thank you so much Priyanka

@gauthamjoy6839 2 жыл бұрын

Really useful, i wanted a short and accurate video which explained the basics on excel from an interview POV and i found it. Thank you for uploading this!

@emmamocanu1650 Жыл бұрын

I have an interview for a really good job, but I will need to know Excel as I am going to use it a lot. I was so scared before saying this being presented as being so simple! Thank you a lot! ❤ i wish you success in everything you want to achive!

@xotweetypiexo 6 жыл бұрын

Taught me more useful information in 10 minutes than 3 years of university. Thanks!

@mohamedalhusni6255 Жыл бұрын

That’s ridiculous

@xerge14 5 жыл бұрын

thank you my friend for this video, it helps a lot. God Bless you my friend.

@luisheran6686 Жыл бұрын

I haven't used Excel in a while and this was the perfect tool for me... You make this look too easy!!! Thank you!

@Olga-iy9bu 5 жыл бұрын

Thank you, you’re so charming. Loved your tutorial, very simple and positive ❤️

@soundfeetmarketing9328 7 жыл бұрын

Thanks! I have a question about the remove duplicates portion. Are the rows associated with the duplicates deleted too? Or would only the duplicates in the column be deleted and shifted upward (which mixes up the rows)?

@saurabhm19782 6 жыл бұрын

A very well explained video. Thank you. Excel Guru ji: will you be able to prepare a video where you show how to create a drop down (if menu bar is at top) or a pop up menu (if menu bar is at bottom) like how we have on web sites? Clicking on those menu items, user can navigate to different sections of the workbook. You help is greatly appreciated.

@s0xispatfe 5 жыл бұрын

Very nice, all the useful things in less than 11 minutes. Great work, loved your attitude. Thank you!

@msprits1 4 жыл бұрын

Oh My God, Excel Guru!! I could recognise you from your voice, brings me back my childhood days with you and our rides back home together riding away our bicycles, im sure you would have recognised me by now? Very Happy to learn from you, Great Video! Thanks, HJ!

@mjbarron51 5 жыл бұрын

Fantastic tutorial! I will have an interview working with Excel. I feel ready now! Thank you!!!

@reddymekala8549 3 жыл бұрын

Hi friend in which company you have interview please reply me

@DeathNachos00017 5 жыл бұрын

Thank You so much! You just saved a college student applying for a job!

@paeden5431 3 жыл бұрын

Congratulations however it shows the sad state of our colleges that you had to seek education elsewhere to get a job...

@gemgem3570 4 жыл бұрын

Thank you so much. You saved my life for a once in a lifetime promotion. God bless!

@dianagrace7954 5 жыл бұрын

hi, sir, this video really took me high I'm done with my computer secretarial course passed out with 99% now I don't remember them much but now the way you thought me I will never ever forget in my life. this is really useful to me I can now easily face the interviews thank you, sir, for motivating me... This the first youtube video I'm commenting. Now I will follow all ur videos THANK YOU MAY GOD BLESS

@fabinaameer2255 5 жыл бұрын

Blessed voice 😍 Thank you soo much Wishes From Kerala

@bernadineschacht8175 5 жыл бұрын

Thank you. It’s a big help for someone returning to the work force.

@GuruJii 5 жыл бұрын

Welcome and best of luck for your future

@clarelee3987 4 жыл бұрын

I am also reviewing for returning to a new job soon. Thank you

@naheedyousuf2238 6 жыл бұрын

Marvelous.. I must say.. i never thought I could learn excel in few minutes.. simply amazing and effortless learning. Thanks!

@ayeshashrivastava4428 2 жыл бұрын

This is the first video of yours that I watched, and quickly follow your channel so that I can learn more n more about excel....thankyou very much

@athanvi111 7 жыл бұрын

Easiest explanation ever, thank you!

@originalsweetz 6 жыл бұрын

Love this guy!! so positive and such simple/clear explanations :)

@surinderkhinder1674 7 жыл бұрын

Stuff was really simple and understandable. I benefitted a lot from the tutorial. Thanks. Keeps the good work.

@laurynmanu5525 5 жыл бұрын

Love this video and the way this bloke is commenting. You're soooo good.

@jesusfollower3835 5 жыл бұрын

Thank you! Excellent video and I'm heading to your website.

@GuruJii 5 жыл бұрын

😀

@PahariTrader 5 жыл бұрын

Just learned Excel in 11 minutes..😍🙌🙏

@Suvendu.Ganguly 2 жыл бұрын

I thoroughly enjoyed the confidence you were extending at all times... really motivating...

@debasmitajhimde4563 3 жыл бұрын

A wonderful teacher you are... thank you so much

@tamjidarefin6681 5 жыл бұрын

You are such a technical teacher ...easy techniques ...easy to learn..Thanks a lot..love u man.. from Bangladesh

@GuruJii 5 жыл бұрын

Thanks Dost

@ravikant8344 7 жыл бұрын

really sir your videos are most effective we are learning a lot from videos THANKS for such video

@GuruJii 7 жыл бұрын

Thank you dear, you might find this video also helpful kzfaq.info/get/bejne/gd99nZt5qqiycZ8.html

@poohsree 5 жыл бұрын

Thank u so much, i was able to learn something at the last moment before an interview !

@skdunmire9210 6 жыл бұрын

This was so well helpful and well done. Thank you Excel Guru for sharing!

@herbertmandicheta 6 жыл бұрын

You are wonderful

@GuruJii 6 жыл бұрын

Thank you herbert mandicheta

@syedali8569 7 жыл бұрын

Very impressive and friendly way of spreading education. Wish you all the best.

@GuruJii 7 жыл бұрын

Thank you dear.

@thakur.lovelyblr4258 5 жыл бұрын

Just wow. The way you explain. Thank you so much.

@canjunhuisitbymyside1269 5 жыл бұрын

I just subscribed! I love how the way you teach sir, thank you for making it easy to follow.

@MarkStJohn-jn4lz 5 жыл бұрын

thank you, this was very informative.

@GuruJii 5 жыл бұрын

Thanks dear

@nigusechewaka6667 6 жыл бұрын

thank you so much God bless you

@GuruJii 6 жыл бұрын

Thank you for the kind words Niguse

@EmilyC12 4 жыл бұрын

Wow, thank you so much!! Hoping my “test” doesn’t happen today so I can watch this again and again!

@dm-ud1bq 4 жыл бұрын

Well simplified and easier to understand. absolutely fantastic

@gladysmoruti 6 жыл бұрын

I never really get to comment on KZfaq Videos! But this video took my hand to the keyboard and get me to type" YOU ARE A PRO"SIR! This is super easy and straight to thepoint! Thank you sharing such knowledge with us !

@GuruJii 6 жыл бұрын

Thank you so much for the kind words Ms Moruti

@vikrantrajput8211 6 жыл бұрын

I totally agree. I love the way he has given so much information in a short video. Kudos to you sir!!!!! Respect...

@sadiabanu2726 5 жыл бұрын

You are super talented you made it so easy to work wkth excel. Very helpful sir thanks.

@genevievemartinez769 5 жыл бұрын

@@GuruJii I also do not comment on videos but you have made this soooo simple. Thank you!!!

@Pandidolod 7 жыл бұрын

I am going to use this video to help me in a job interview tomorrow. Wish me luck! I need a job!!

@najlafaizus6845 2 жыл бұрын

Did you get the job?

@Pandidolod 2 жыл бұрын

@@najlafaizus6845 I did! :)

@najlafaizus6845 2 жыл бұрын

@@Pandidolod great 👍🏻

@Mojoglowfitness Жыл бұрын

I think you did very well explaining these terms in excel wonderfully and you made it so simple to understand and practice.

@chetanaanuraj2424 3 жыл бұрын

Awesome sir. This is the video that i found where i have learnt the new things regarding MS Excel. Thank you sooo much sir.

@karishmasoni5076 6 жыл бұрын

The video was so helpful and give the actual gist about the main points of excel.

@GuruJii 6 жыл бұрын

Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org

@gauudi8230 5 жыл бұрын

Excellent video. You explained the functions clear and effective. 👍🏻

@GuruJii 5 жыл бұрын

Thanks dear

@gayletrunfio7872 6 жыл бұрын

Thank you for such straightforward tips! Checking out your other tutorials.

@kunalparmar2163 Жыл бұрын

Best video on excel topics I have seen, Amazing work keep posting valuable videos like this, thank you

@AartiSharma-vu6qe 6 жыл бұрын

u r a lifesaver ... keep up the great work :)

@chefdeprestigellc8855 6 жыл бұрын

your are gorgeous

@Mahi69349 6 жыл бұрын

Good

@Anythiing-time 6 жыл бұрын

Its really helpful to make me knowledgeable.

@GuruJii 6 жыл бұрын

Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org

@madalitsochilalire5219 2 жыл бұрын

You make it sound simple, and simple it is, YES I CAN DO IT!!

@excelsimplified4231 7 жыл бұрын

Thank you for uploading the video. It was very thorough but easy to follow at the same time.

@indianspartan76 5 жыл бұрын

Using this as a refresher for an upcoming job interview. Thanks man, love it!

@srinagarmagazine9250 2 жыл бұрын

Bhai... Can u please help me out with a this question.... Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data sepetately. Please bro, it's really important.

@indianspartan76 2 жыл бұрын

@@srinagarmagazine9250 You can use pivot tables in excel.

@indianspartan76 2 жыл бұрын

@@srinagarmagazine9250 unfortunately I don't know in steps, if you have a computer in front of you, you can try to play it out. Hope that helps!

@srinagarmagazine9250 2 жыл бұрын

@@indianspartan76 Thanks anyway brother!

@paraprakash_9411 6 жыл бұрын

Great job. ..tone of voice is plausible...,.. Manner too is good

@GuruJii 6 жыл бұрын

Kumauni Boy Thank you sooo much dear.

@paraprakash_9411 6 жыл бұрын

My E-Lesson sir I want all stuff related to computer skill test.. Means exercises and practice tests.... Mainly .. Ms word,Ms Excel,Ms PowerPoint....

@joyalmariyatom9872 5 жыл бұрын

Thank you for your good lesson about excel in simple and understandable way. It was really helpful for me.

@Deepakkumar-cn9vq 2 жыл бұрын

YOU ARE A LIFE SAVIOR MAN !

@sushmitagogoi6339 7 жыл бұрын

you are amazing thank you 🤗

@GuruJii 7 жыл бұрын

Welcome Dear :) you may find this video useful kzfaq.info/get/bejne/gd99nZt5qqiycZ8.html

@sushmitagogoi6339 7 жыл бұрын

My E-Lesson sir plz can you prepare one video on ms access

@THEVIRALSTORY 6 жыл бұрын

kzfaq.info/get/bejne/leCohdh9r8zYkZc.html

@mohammedaliumair5329 5 жыл бұрын

Once

@luzy99 5 жыл бұрын

I'll be in my interview tomorrow like "yes sir, absolutely I know how" 👍💪

@drm9514 4 жыл бұрын

You can watch Excel Interview question and answer by clicking below link kzfaq.info/get/bejne/iLOTeNFj1b_Lf2w.html

@____Sonu____ 7 жыл бұрын

Wow!! Thank you for sharing, this is the best video I have come across So far... looking forward to learn more about excel through your website.

@rashirao3127 Жыл бұрын

You earned one more subscriber!! This was short, simple and the most easiest way to learn these difficult topics. Thank you so much.😇

@briancarpenter6413 6 жыл бұрын

Excellent

@GuruJii 6 жыл бұрын

Brian Carpenter Thank you

@tanyagupta8115 7 жыл бұрын

sir, you are fantabulous. so talented you are. love your videos! And do you have any video on SAP ??

@GuruJii 7 жыл бұрын

Thank you Tanya. i dont have courses on SAP :(

@rajneeshpandeyrj5806 7 жыл бұрын

gup[ta jee mail send kariy i will send u soon about sap softwere oky...my mail id is pandayrajneesh1994@gmail.com

@sailessahoo2613 7 жыл бұрын

hie Tanya ,, which module u r searching for

@fhaque6302 7 жыл бұрын

Please send me SAP software. My email ID is fhaque017@gmai.com

@sudhakarmani4076 7 жыл бұрын

Tanya Gupta hi do you need complete set of SAP video please reply

@briannahall2614 5 жыл бұрын

Thank you soooo much!! I have an interview with using excel in a few hours and I was so nervous I wouldn't be able to find any helpful material. Hopefully this covers everything they need! So easy to understand :) Thank you again!

@shubhangisrivastava2850 5 жыл бұрын

Hey, were you able to see the figures clearly in the video? Also good luck!

@PoojaDevi-jt1mf 5 жыл бұрын

Excellent video!! Such detailed information in a short time!! Thank you very much!

@amybeelicious 4 жыл бұрын

Watching this on my way to my important job interview. I lied and said I knew what a pivot was 😆😂

@ashishbairisetty984 3 жыл бұрын

Did they select you?

@amybeelicious 3 жыл бұрын

@@ashishbairisetty984 no but I was in the top 3 at least and this video still helped lol.

@prabhatghosh88 6 жыл бұрын

Liked your video...very helpful

@GuruJii 6 жыл бұрын

Thank you Prabhat

@farahulain9062 6 жыл бұрын

wonderful.. my first day of learning excel and i feel so happy :D thank u

@Kaoriwnl Жыл бұрын

You are good teacher Sir, thank you for your help!

@arohis4361 7 жыл бұрын

Very Helpful ^_^

@GuruJii 7 жыл бұрын

+Arohi S thanks. What else would you like to like learn in Excel

@ruchiparihar8422 5 жыл бұрын

u should be radio DJ . mellow voice..

@GuruJii 5 жыл бұрын

Thanks Ruchi

@francescomanier1246 7 жыл бұрын

F11.. then the magic!!! Great shortcut! Excel is all about knowledge, indeed! Thanks for sharing!

@safashaharban5293 Жыл бұрын

I already know that you are a good human being ❤️ Thank you sir :)

@eigen1255 5 жыл бұрын

Are you a Telugu speaker? You sound like my favorite actor, Rana Daggubati.

@GuruJii 5 жыл бұрын

Thank you.i love him too

@aartidave2393 7 жыл бұрын

hello sir. can u help me to sap accounting online free course searching and which is best for this course. plz sir

@GuruJii 7 жыл бұрын

Hello. i am not aware about SAP accounting, sorry, try searching youtube or google for it.

@aartidave2393 7 жыл бұрын

Ok any other computer courses can u suggest me?

@gazi4u128 7 жыл бұрын

i also want online course for sap fico, bsz I completed m.b.a finance

@csillaalfoldi6833 5 жыл бұрын

OMG this video was so simple and useful!!! Thank you! I am going to check your website now!

@PepperJoanne 7 жыл бұрын

Thank you so much for youe video! It is very clear of how to use Excel and how to do the exercises! I feel calmer knowing the information you shared! When I have more time, I will subscribe to your website!

@GuruJii 7 жыл бұрын

+PepperJoanne welcome dear. Thank so much for the love.

@snigdha2838 5 жыл бұрын

I'm going to give a interview on Excel basis if I'm selected then I let u know guys pl.pray for me it's really important for me

@GuruJii 5 жыл бұрын

Best of luck.

@snigdha2838 5 жыл бұрын

@@GuruJii thank you so much sir it means a lot for me u gave reply

@appleeye3972 5 жыл бұрын

R u selected?

@mohittheshinethakur9031 7 жыл бұрын

Hi sir I have a question, in one cell a value entered and I want to sum of this number E.g cell1-123 Cell2-9876 Cell3-3458 If I sum the value it should be in order 6 30 20 But I am unable do this through function Please help me out

@GuruJii 7 жыл бұрын

Mohit Thakur I did not understand the question

@mohittheshinethakur9031 7 жыл бұрын

My E-Lesson Hi My question was related to add value of single cell As I told previous comment Again I am reiterating I have cell, in this cell a number put e.g. 345 if I sum this number like 3+4+5 it should be come 12 I want to add single cell sum Hope you understand my question Pls reply me on below id Mohit@optum.com

@GuruJii 7 жыл бұрын

Hi, now i understand it. Yes, it can be done, you would have 1st extract the content from teh cell using LEFT or RIGHT formula in combination with FIND formula an then you can add them. Its tough to do though. You learn about these formulas on my website HTTP://WWW.MYELESSON.ORG

@mohittheshinethakur9031 7 жыл бұрын

My E-Lesson Thanks for the response So I can get my question's answered through myelession.org K if I found any difficulty then I let you know It will be more better for me if you send this my email id Thanks Mohit