Data entry interview question || Data validation in excel #shorst

Data entry interview question || Data validation in excel #shors

Your Queries :
computer class
excel tutoring
excel formula for job interview
excel for fresher
data entry work in excel
excel formula hacks
ms excel interview questions and answers
excel world
excel interview questions
excel office
advance excel jobs for freshers
ms office interview questions and answers
excel trick shots
excel interview questions and answers
ms office in hindi
excel work from home jobs
back office executive work
advance excel interview questions and answers
advanced excel interview questions and answers
computer interview questions and answers
back office work in hindi
ms word interview questions and answers
exl work full course
excel questions asked in interviews
excel work job
computer interview
advance excel job interview
excel office job work
computer job interview
excel work interview

#excelinterviewquestions
#shrots
#dktech
#viral
#trending
#excelviraltricks

[LUCKYTREHAN-qo]

Use copy paste option more eassy with key shortcuts

[YRSHAHI]

I think you could do it faster by setting filters to those 2 columns, tick whichever is male/female then just drag down

[rajneeshsingh]

Bhai isse jyada tez toh mai keyboard se type hi kr dunga😂😂

[tharabhai]

Are salon isse zayada speed se to copy past ho jati hai😂😂😂😂

[imgovind]

Ek baar male ek baar female likh do fir m/f key type krne se bhi kaam jaldi ho jayega

[zohaibasgharkiyani]

Formula aik cell ma lga lo baki drag kr do phr b jaldi ho jata ha data validation pe time lgta ha

[panakjgohil]

I will write it will be faster that selecting

[jimmykhan]

Drop down list bnane ki jarurat hai ek bar male and female type krne ke bad alt+down arrow krne se list mil jayegi

[saazaurawaaz]

Count if formula is more suitable for this kind of task

[nvduk]

basically he showed us how to create a drop down menu in excel with the options of our choice. Interviewer must have explained his requirement properly which is missing in this video I suppose.

[rashilk]

Practice ke liye same workbook ka download link do

[ccountant]

If you notice most of the female names ends with " a " so you can use "if and right" function combined for all the females.

[jayasreeframes]

This one is good...but copy paste is more better way

[werewolf]

Once entering male and female in 3 and 4th cell list automatically ban jati hai us list ko open krne kai lia alt down arrow daba sakte hai but good one ❤

[theaveshansari]

You can use filter, if the name ends with 'a' its female.

[manishkr]

Copy and paste in front to male and female. You need to type only once both and then copy

[vishaljain]

Better to filter male at a time and paste male

[rohit__g]

Drop down Lelo aur files mei jaakr advanced option mei "When presss enter curson goes right hoga usko ap down mei kar dijiye jisse kbhi bhi aap enter click kare toh woh automatic down jaye apko mouse ya direction bar ka use na karna pade" yeh sab 2 min ka kaam hai par humesha rahega yeh sab krne ke baad ap data validation mei jaakr jaise bataye gya hai video same waise kijiye par video mei last mei dikhaye woh mouse se usko male aur female click kr rha hai ap mat kijiye ap sidha keyboard mei ek baar male aur female likh dijiye uske baad sirf enter dabaiye aur next cell mei sirf uska first word likihiye apne aap ho jayega

[mudassirkhan]

Sare Male me "dot" laga do Female blank chhod do, then "Replace" option sey Dot ko Male krdo aur Blank ko Female.

[chaturvedianjali]

Why you guys are behaving like this 😂😂...his only purpose of the video was to introduce data validation through the example.. otherwise he knew how to do faster