Data entry interview question || Data validation in excel

Подписаться 134 тыс.

Просмотров 1,9 млн

50% 1

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

Опубликовано:

3 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 503

@rajneeshsingh8544 Год назад

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

@DKTECH Год назад

Ye kewal example h baki data validation ka use krke hum bde bde data ko fatafat complete kr skte h

@ShivamPal-px2dg Год назад

Sahi hai bhai😂

@DKTECH Год назад

😊

@vandansingh601 Год назад

Mai bhi😅

@saranshsrivastava2703 Год назад

Ghanta

@tharabhai6955 11 месяцев назад

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

@YashMeerwal 4 месяца назад

Mein bhi yeh soch raha tha copy paste fast h dta validation se 😂

@DKTECH 2 месяца назад

Example ko dekhe to apki bat shi h 😊

@imgovind77 Год назад

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

@DKTECH Год назад

Ha ese bhi ho jayega lakin is trick se hum kesi bhi list bna skte h jisme bde bde data ko ftafat complete kr skte h

@User_xyz_ 10 месяцев назад

Hn para data aise given hoga toh hi possible hai alternative rehta hai toh

@DKTECH 10 месяцев назад

Alternative data h to uske according hum data validation me condition change kr skte hai

@dailyupdate777 2 месяца назад

Use multiple copy paste..

@DKTECH 2 месяца назад

Normally we do copy paste but there we are talking about data validation

@JOKER-ew6ud 11 месяцев назад

Computer Gyan channel m bhaut ache se samjhta ta h wo 👍👍

@HarAmar-h9y Год назад

Superb

@DKTECH Год назад

Thanks

@pritus9537 Год назад

Nice trick..

@DKTECH Год назад

Thanks 😊

@manishkr8522 11 месяцев назад

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

@DKTECH 11 месяцев назад

U are right brother but in this trick example is normal main focus on data condition formula which is used for create custom data according user requirements 😊

@NehaSonkar-ym3ez 7 месяцев назад

Wow super 😍

@DKTECH 7 месяцев назад

Thanks 😊

@munkujyotshnasingh2621 4 месяца назад

Shaandar

@DKTECH 4 месяца назад

Thanks 😊

@kaushikdave1469 11 месяцев назад

Good job

@DKTECH 11 месяцев назад

Thanks 😊

@vishaljain880 Год назад

Better to filter male at a time and paste male

@DKTECH Год назад

Right bro but ye small example h and we can use this trick for handling big data in short time

@moonlightcomputer2644 11 месяцев назад

good

@DKTECH 11 месяцев назад

Thanks 😊

@werewolf35 10 месяцев назад

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 ❤

@DKTECH 10 месяцев назад

U r right but in this short example is simple but most thing for learn is conditional formatting trick 😊

@vaishalichache2919 5 месяцев назад

Wow

@DKTECH 5 месяцев назад

Thanks 😊

@Udyavar 2 месяца назад

Option

@KomalsajjadAli 4 месяца назад

What wha

@luvkhanna4037 6 месяцев назад

if function is applicable here.

@DKTECH 6 месяцев назад

Yes we do this by using conditional function i.e. if

@mudassirkhan6461 6 месяцев назад

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

@DKTECH 6 месяцев назад

Ese bhi ho jayega but yha par aap kewal example dekh rhe h jo ki simple hai jbki isme data validation ki trick jyada useful h isse hum bde bde data ko customize krke ftaft complete kr skte h 😊

@mohitsharma5080 5 месяцев назад

Ek baar male likho ek baar female fir jitne bhi male ke blank column hai unko ctrl se select krlo or paste krdo same with female

@DKTECH 5 месяцев назад

Ha ese hi krte lakin yha data validation ki trick btai h 😊

@makemefine3692 Год назад

Agar ek ek entry hogaya to fir F or M type karne se hi aajata aur drop down se fast v hota....😂😂😂😂

@DKTECH Год назад

Baat to sshiii hhh 😊 Lakin aap example par focus kr rhe ho jo ki normal h lakin same trick se bde bde custom data to ftafat complete kr skte h

@chaturvedianjali 10 месяцев назад

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

@DKTECH 10 месяцев назад

exectly you got right thing of this video. Otherwise many of guys are seeing example only except data validation . Thanks for your valuable feedback 😊

@LeadLifeWithEaseNow 9 месяцев назад

Just enter M or F.

@DKTECH 9 месяцев назад

Yes but we do multiple operation by using data validation

@Nishayar 6 месяцев назад

Bro...Issey bhi asan tareeqa hai...reply Karo to m bta deta hoon😂

@DKTECH 6 месяцев назад

Isko copy paste, data entry form or filter se bhi kr skte h Lakin isme aap kewal example dekh rhe h jo ki simple hai jbki isme data validation ki trick h usse hum bde bde data ko customize krke ftaft complete kr skte h

@ashutoshmaurya2281 Год назад

Mai bhi kuch Gyan ki bat likhna chahta hu

@DKTECH Год назад

Why not....

@tanmayyerankollu1484 6 месяцев назад

You can use also if formula

@DKTECH 6 месяцев назад

Yes

@Alita_Neelu Год назад

Interview me yehi pucha Gaya tha ki aap bana k bata rahe ho

@DKTECH Год назад

Jo questions interview me puche jate h unse similar questions hi trick me btaya jata h example ke tor par

@ajay-s1i1n8g9h Год назад

Bhai agar column me male and female dono aa gaye uske baad M press kro enter maro F press kro enter maro Isse teji se ho jayega

@DKTECH Год назад

Shi kha apne 😊 Akin isme example normal h baki Jo data validation ki trick h usse hum bde bde custom data to ftafat complete kar skte h

@ajay-s1i1n8g9h Год назад

@@DKTECH sir apko example hi thoda hard pakadna chahiye tha

@DKTECH Год назад

@ajay-s1i1n8g9h ok

@YRSHAHI 11 месяцев назад

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

@DKTECH 11 месяцев назад

Yes brother, but in this example data validation trick is most important more then example

@Karanskashyapp 3 месяца назад

Bhai if ka formula karo and fhir and lga do usse honjyaga yrr

@DKTECH 3 месяца назад

Is example me normally ek bar male or female type krne ke bad normally m or f type krne se hi ho jayega. But isme data validation ki trick btai h jiska use krke hum bde bde data ko customize krke ftaft complete kr skte h 😊

@ashwinswain1649 Год назад

i would used if name ends with vowel its female n then cross check karta puri list

@itsmeqadir864 2 месяца назад

Raju..

@ishahab1000 Месяц назад

Name ku filter lgake bhi hojaata

@DKTECH Месяц назад

@KanhaiyaSain-p5l Месяц назад

Bhai if condition se bhee ho sakta hai ye aur bar bar click karne ki bhee jarurat nhe hai

@DKTECH Месяц назад

@@KanhaiyaSain-p5l Ha honjayega but isme data validation ke bare me btaya h jisse in cells me kewal male or female hi add kr skte h iske alawa kuch nhi

@abdulkafikhan5648 Год назад

Custam me aur easy hoga😊

@DKTECH Год назад

Yes

@VIKASHkumar1998-q2y 23 дня назад

Kyan isme countif( A3:A23,"male","female") Yeh formula work nahi karega

@DKTECH 13 дней назад

Nhi

@Annie_R18 4 месяца назад

Copy all “male” in entire column. Where there is need to enter female jus add “Fe” before “male” Smart trick 😂😂

@DKTECH 4 месяца назад

Normally ese hi krte h 😊

@BMbypowerofmoney 5 дней назад

Enter bottom hi kafi hai bhai 😅😅😂😂

@DKTECH 5 дней назад

Ha normally ese hi krte but isme data validation ke bare me btaya h 😊

@Kajal-2525 3 месяца назад

Excell is smarter than u man F click karte hi female auto type ho jate hai M click karte hi male auto type hote hai

@DKTECH 3 месяца назад

Right 👍 but don't look example because it's so simple and there are telling about data validation trick 😊

@AiCatsVideoss 5 месяцев назад

Sub per male likh do phr Female pr focus kro hahaha

@DKTECH 5 месяцев назад

Ha normally hum esa hi krte h Or abhi aap kewal aap example dekh rhe h jo ki simple hai jbki isme data validation ki trick btai h jiska use krke hum bde bde data ko customize krke ftaft complete kr skte h 😊

@Sayyed.Sameer.786 2 месяца назад

Trika to sahi he le kin select kerne ka trika thoda fast hona cahiye ager 10000 Colem hoto kiya hoga

@DKTECH 2 месяца назад

Jyada entry ho to filter apply krke ek sath fill kr denge

@vishwanathrao5698 10 месяцев назад

Abey video ka anchor... Yeh Kya pat pada Raha hai???? Tooo Jo pat pada Raha hai naa? Kya tuje khud ke Liye bhee Samaj Mai aata hai Kya??? .... Chala doosaron Ko pat padane... Jo isako khud Samaj Mai naahi aata.... Hoo... 😮😮

@DKTECH 10 месяцев назад

Agr aapka processer khrab h to iska mtlb ye nhi ki data incorrect hai

@tarunmandal2850 6 месяцев назад

Aur jaldi chahiye to computer screen pe permanent marker se bhi male female likh sakte hai

@DKTECH 6 месяцев назад

Intelligent guys

@ABHISHEK-237 Год назад

Main bataunga isse easy way

@DKTECH Год назад

Good 👍

@ERCIVIL8154 Год назад

1bar male or female likh de fir jo male h uske aage m likhega tbhi apne aap male aa jayega aap se tej bhi hoga

@DKTECH Год назад

Ha ese bhi kr skte h lakin is trick se aap alg alg data or jitne bhi option ho vha apni choice ka data fatafat type kr skte hai

@theaveshansari Год назад

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

@rolishukla9589 Год назад

What about raja

@theaveshansari Год назад

@@rolishukla9589 'raja' is not in this list. Ye trick isi perticular list pr lagegi sabhi women names bhi "A" pr thodi end hote h but is list me ho rhe h.

@rasmiranjan6867 Год назад

@@theaveshansariRenu?

@iamhassu Год назад

Correct

@suhailahmed4686 4 месяца назад

Aap bahut fast bolte ho...... it's very difficult to understand

@DKTECH 4 месяца назад

Speed to normal hi h or ye short video h jo 59 sec me hi topic cover Krna pdta h Aap ek bar fir se dekhiye pkkaa samjh me ayega 😊

@gameover00007 7 месяцев назад

i need data entry job

@DKTECH 7 месяцев назад

Firse learn MS office and comuter basic fundamentals (Printing, documents editing etc) and try in your nearest offices, schools, hospitals 😊

@mr.pradeepkumar9336 4 месяца назад

अबे बेवकूफ डेटाबेस वेलेशन लगाने के बाद भी तो नाम देखना ही पड़ेगा फायदा क्या है इससे

@DKTECH 4 месяца назад

जिन्ह कें रही भावना जैसी प्रभु मूरत तिन्ह देखी तैसी🎉

@aryansingh5647 3 месяца назад

सबमें मेल लिख के कॉपी पेस्ट कर दो फिर सिर्फ फीमेल नाम के आगे फीमेल लिख के कॉपी कर लो और पेस्ट करते जाओ😂

@DKTECH 3 месяца назад

नॉर्मली ऐसे ही करते लेकिन यहां data validation की ट्रिक बताई है 😊

@ravityagi9743 5 месяцев назад

Normal Isse tez hoga m dbate hi Male, f dbate hi female

@DKTECH 5 месяцев назад

Aap isme kewal example dekh rhe h jo ki simple hai jbki isme data validation ki trick btai h jiska use krke hum bde bde data ko customize krke ftaft complete kr skte h 😊

@deepali5024 7 месяцев назад

Sb me male scroll krdo...end m dekh dekh kr fe likh do....simple female bn jyega✅✅

@DKTECH 7 месяцев назад

Ha ese bhi simple ho jayega. Lakin AAP yha kewal example dekh rehhe h jbki isme data validation ki trick use ki h us trick se hum custome data bnakr fataft complete kr skte h

@statuswithyou143 8 месяцев назад

Pagal f ya m write karna rahega only

@jimmykhan5627 Год назад

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

@DKTECH Год назад

great

@Sagar_006 Год назад

Bhai ye data agr 1lakh ka h fr yehi kroge 😅

@DKTECH Год назад

We have multiple options it's depends on situation that which is best for same 😊

@Evaya9821 6 месяцев назад

@@Sagar_006drop down me bhi to manual karna hoga. Alt arrow wala Jada speadly Hota he, believe me But iss video me intention data validation ka list option samjhana tha.

@DKTECH 6 месяцев назад

Aap ne shi kha Is video me date validation ke bare me hi btaya h Great 😊

@phycogamer5536 7 месяцев назад

Kunhal bechara female bann gaya😅.... But thanks for this video❤❤❤

@DKTECH 7 месяцев назад

वाह, क्या दूरदृष्टि हैं आपकी 😂

@Jatinsharma-1996 8 месяцев назад

copy paste kr leta teri trha he hoga koi

@MovieWebs_lover Год назад

Bekaar idea isme bhi to click krna padhega iss achhe sab par ek sath male likh do fir name dekh kr female copy kr jaha jaha female ho waha paste kr do

@DKTECH Год назад

Example normal h but same trick se bde-bde data me fastly Kam complete kr skte h

@rahulraghuwanshi6896 6 месяцев назад

Nonesense trick

@DecentxR 9 месяцев назад

F ya M daal do baad main replace kardo F to female and M to Male🤦

@DKTECH 9 месяцев назад

Ha ese bhi kr skte h

@MeghaKajaniya-13 2 месяца назад

Btane ka tarika thoda casual hai 😮😂

@shubhampandey1035 3 месяца назад

Maine kaise kiya ... sare me female paste kiya aur Phir Male walo ke liye "fe" hta diya 😂🤣😂👊

@DKTECH 3 месяца назад

पर्भु तेरे संसार में भांति भांति के लोग 😊 🤣

@77nuni Год назад

Male aur female ke baad M or F type karo khatam

@realpad8738 6 месяцев назад

Kis kis ko laga ye kaam ki video hogi😅

@kalpeshjagtap7535 Год назад

Time waste

@SHvibess 4 месяца назад

Bro isse bi easy trick hai 😂 ek condition lgake drop down krdo sb ajyega.

@DKTECH 4 месяца назад

👍 😊

@rashilk 4 месяца назад

Practice ke liye same workbook ka download link do

@dipikanjali1266 Месяц назад

Maim toh m likh deti uske baad ctrl+f se sbhi m ko male me convert or same f ko bhi female type kr deti 😅

@DKTECH Месяц назад

Ha agr hum kewal example dekhenge to normally sb ese hi krte . But yha humne data validation ki condition lgana btai h 😊

@rk_brajwasi 9 месяцев назад

Formula bhi to hoga ishka kuch

@DKTECH 9 месяцев назад

Data Validation option me Jake hum condition set kr skte h

@Rohitkumar-mm5iz 4 месяца назад

Hai koy jo hindi ya english ki typing me mujsey shart laga sake

@DKTECH 4 месяца назад

Lga lo 👍

@MangVaiphei-zu5ni Месяц назад

😂😂ise acha idar udar janeki vaje male and female banake double click kardi😂

@DKTECH Месяц назад

Agr aap kewal example dekhoge to apka khna shi h normally m/f type kr denge but yha data validation ke bare me btaya h jisme hum Data condition fix kr di ki yha male or female ke alawa dusri value nhi dal skte 😊

@Tukeshsinha12 9 месяцев назад

Copy paste wale like kre

@rubykumari9099 Год назад

Bhae arrow ko slow kar do

@DKTECH Год назад

Shi to h

@ccountant777 Год назад

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

@Alita_Neelu Год назад

@mohfizchabba1623 Год назад

A and u and i

@rummytube9716 8 месяцев назад

Renu

@tushar8938 2 месяца назад

There is any formula?

@DKTECH 2 месяца назад

No formula used. It's data validation option

@Jashan-d3z 7 дней назад

Data Entry job me future kya he re, usse accha Auto chalao 😍

@DKTECH 7 дней назад

ये तो हर आदमी की वैल्यू और स्थिति पर निर्भर करती है क्योंकि हर आदमी डाटा एंट्री नही कर सकता और हर आदमी ऑटो नही चला सकता और वैसे नोकरी करने से लाख गुना बेहतर है ऑटो चलाना

@dayasagarsahu6360 5 месяцев назад

😂😅 ise to achha sab ko female kardo uske bad jo male hai fe ko delete kardo .

@DKTECH 4 месяца назад

Agr is example ki bat kre to Normally esa hi krte h , Lakin is video me data validation ki conditional trick btai h jiska use krke hum bde bde bde data ko customize krke ftaft complete kr skte h

@pankajsinghbangari8593 6 месяцев назад

Jitna time ye lagaya hai usse pahle to type karke sheet ready ho jati hai

@DKTECH 6 месяцев назад

Ho jayega lakin AAP yha kewal example dekh rhe h Jbki example se jyada data validation ki trick jyada useful h isse hum bde bde data ko customize krke ftaft manage kr skte h

@yashshekhawat6327 3 месяца назад

Copy paste left the chat

@DKTECH 3 месяца назад

Normally copy paste hi krte h . But isme data validation ke bare me btaya h 😊

@sarmadkhan5051 4 месяца назад

Bhai contact C Kr k Control V kr deta😅

@DKTECH 4 месяца назад

Agr aap kewal example ko dekhenge to Normally ese hi krte h Lakin isme data validation ki conditional formatting ke bare me btaya h 😊

@StraightThings1 Месяц назад

Drop down dena hi tha to ekdam upar wale column se start krta har ek cell me dalne ki kya jarurat

@prakash_1315 Год назад

Bhai auto cell fill hojata h same word se male hi female h m f likhte jao bs 😂

@DKTECH Год назад

Example small h but same trick se hum kafi complected ya bde data ko fast complete kr skte hai

@neerajsinghrawat5490 3 месяца назад

Faltu 😅😅😅

@GeetaDevi-dg8et 3 месяца назад

Sabhi colum me female paste karke phir male wale naam ke samne se fe hata do

@DKTECH 3 месяца назад

आइडिया अच्छा है लेकिन अगर एंट्री ज्यादा हो तो मेल, फीमेल देख देख कर डिलीट करने में बहुत टाईम वेस्ट होगा 🫢 दूसरा स्मार्ट तरीका ये भी है: ru-vid.comFDAgSulSoAs?feature=share

@vishalmumbaiwala Год назад

Bhai ye smart trick nahi lagta kyunki jab dekh kar he select karna hai to typing he sahi hai

@NoshadKhan-xq5pz 3 месяца назад

Copy paste is far batter😂

@DKTECH 3 месяца назад

Normally ese hi krte lakin isme data validation ki bat kr rhe h 😊

@tarle_engineer9372 6 месяцев назад

😂😂

@DKTECH 6 месяцев назад

Tum Jo has has ke bat krte ho...... Bas yhi bat jmane ko buri lgti hai.... 😂 😂

@kunaldate8829 5 месяцев назад

Sanju mere male bhi aur female hain😂😂😂😂

@DKTECH 5 месяцев назад

🫢 😁

@jay-qy1ww 4 месяца назад

Hahhaha

@nikitagarwal9044 2 месяца назад

Bhai ek baar likh diya to third wale me sirf ek alfa bat dalna hai

@DKTECH 2 месяца назад

Ha normally ese ho jayega but isme data validation ki conditional formatting ke bare me btaya h 😊

@nvduk3 3 месяца назад

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.

@DKTECH 3 месяца назад

Excellent 👍

@Sandepe_kumar 3 месяца назад

भाई एक बार मेल और फीमेल लिख लो। और आगे बस मेल है तो M लिखो और फीमेल है तो F लिखो अपने आप हो जायेगा। ड्रॉप डाउन लिस्ट से सेलेक्ट करने में 3 से 4 गुना कम टाइम लगेगा

@DKTECH 3 месяца назад

नॉर्मली हम ऐसा ही करते ह लेकिन इसमें डाटा वैलिडिशन की ट्रिक बताई है 😊

@Sandepe_kumar 3 месяца назад

@@DKTECH Yes bro

@mahandilover-w9d 2 месяца назад

bahut achha krte ho bhai isse achha to video hi mt dàlte😡

@DKTECH 2 месяца назад

@@mahandilover-w9d to video dalne se pehle comment krte na ...... 😊

@rohit_55_7g5 3 месяца назад

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

@DKTECH 3 месяца назад

Great 👍

@MOHAMMADTARIQUE-tz3dn 3 месяца назад

Itna bada msg padne se acha hai type karlo😅

@tapaskumarbiswal7626 5 месяцев назад

esse accha mae copy paste na kar dun ek barr mass male and female lekh kae

@DKTECH 5 месяцев назад

Ha, lakin AAP kya kewal example dekh rhe h jbki isme data validation ki trick btai h iska use krke hum apne according custom data bna skte h

@Excelsmart23 28 дней назад

If condition sikho usse easily kr sakte ho

@DKTECH 26 дней назад

Yes

@s1proworld332 2 месяца назад

Sidha option hey male likh kar copy kr do aur female wali ko bas female type krna

@DKTECH 2 месяца назад

Yes normally ese hi krte h 😊 but isme data validation ke bare me btaya h

@dipikanjali1266 Месяц назад

@@DKTECHApka trick bhi acha jese ki quotation bnate sb chemicals ki list ke liye... Sbhi list ko drop down list bna skte hai or list me add bhi kr skte h😊

@DKTECH Месяц назад

Bilkul shi smjha apne . thanks 😊