Data entry interview question || Data validation in excel
HTML-код
- Опубликовано: 14 окт 2024
- 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
Bhai isse jyada tez toh mai keyboard se type hi kr dunga😂😂
Ye kewal example h baki data validation ka use krke hum bde bde data ko fatafat complete kr skte h
Sahi hai bhai😂
😊
Mai bhi😅
Ghanta
Ek baar male ek baar female likh do fir m/f key type krne se bhi kaam jaldi ho jayega
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
Hn para data aise given hoga toh hi possible hai alternative rehta hai toh
Alternative data h to uske according hum data validation me condition change kr skte hai
Use multiple copy paste..
Normally we do copy paste but there we are talking about data validation
Use copy paste option more eassy with key shortcuts
Yes
Are salon isse zayada speed se to copy past ho jati hai😂😂😂😂
Mein bhi yeh soch raha tha copy paste fast h dta validation se 😂
Example ko dekhe to apki bat shi h 😊
I think you could do it faster by setting filters to those 2 columns, tick whichever is male/female then just drag down
Yes brother, but in this example data validation trick is most important more then example
Formula aik cell ma lga lo baki drag kr do phr b jaldi ho jata ha data validation pe time lgta ha
Ha agr hum kewal example dekhe to normally esa hi krte but yha data validation ki conditional formatting ke bare me btaya h
Thnx❤️❤️❤️
I will write it will be faster that selecting
Yes, because example is normal but main thing in this video is data validation 😊
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
Great 👍
Itna bada msg padne se acha hai type karlo😅
We can do copy paste also.
Yes
Practice ke liye same workbook ka download link do
Drop down list bnane ki jarurat hai ek bar male and female type krne ke bad alt+down arrow krne se list mil jayegi
great
Bhai ye data agr 1lakh ka h fr yehi kroge 😅
We have multiple options it's depends on situation that which is best for same 😊
@@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.
Aap ne shi kha
Is video me date validation ke bare me hi btaya h
Great 😊
Copy and paste in front to male and female. You need to type only once both and then copy
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 😊
There is any formula?
No formula used.
It's data validation option
Count if formula is more suitable for this kind of task
👍
If you notice most of the female names ends with " a " so you can use "if and right" function combined for all the females.
No
A and u and i
Renu
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
Ha ese hi krte lakin yha data validation ki trick btai h 😊
Better to filter male at a time and paste male
Right bro but ye small example h and we can use this trick for handling big data in short time
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 ❤
U r right but in this short example is simple but most thing for learn is conditional formatting trick 😊
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.
Excellent 👍
Iss se Asaan Mai bata duga...
Tell...
Sare Male me "dot" laga do Female blank chhod do, then "Replace" option sey Dot ko Male krdo aur Blank ko Female.
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 😊
if function is applicable here.
Yes we do this by using conditional function i.e. if
You can use filter, if the name ends with 'a' its female.
What about raja
@@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.
@@theaveshansariRenu?
Correct
Drop down dena hi tha to ekdam upar wale column se start krta har ek cell me dalne ki kya jarurat
Thanks bro❤❤❤❤
Welcome 🤗
Option
Mele wali cell ko cntrl k sath cilect krte jao fir male likh kar cntrl+enter kar do ek hi bar m male likh jayga
Great 👍
Aap shi kh rhi h .
Lakin isme example ke sath jo data validation ki trick h usse hum bde bde data ko apne hisab se customize krke ftaft complete kr skte h
@@DKTECH yes
Think you
Welcome
Wow super 😍
Thanks 😊
You can use also if formula
Yes
If condition sikho usse easily kr sakte ho
Yes
Computer Gyan channel m bhaut ache se samjhta ta h wo 👍👍
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
exectly you got right thing of this video. Otherwise many of guys are seeing example only except data validation .
Thanks for your valuable feedback 😊
Write one time male and female for the particular name and Press m for male and enter then press f for female and emter thats it
Yes it's a best way for do this job. But in this video Dara Validation Trick is important more than example
Copy paste bhi kar sakte hai
Ha , lakin isme aap kewal normal example h vo dekh rhe h jbki isme Jo data validation ki trick h usse hum bde bde data ko customize krke ftaft complete kr skte h 😊
Wow
Thanks 😊
This one is good...but copy paste is more better way
Yes you are right that copy paste can be batter way but we explained data validation trick in this video.
Thanks for your valuable feedback ☺️
@@DKTECH 👍
Name ku filter lgake bhi hojaata
Ok
Sb me male scroll krdo...end m dekh dekh kr fe likh do....simple female bn jyega✅✅
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
Bhai apko sirf ek baar male/female type krna hoga uske baad M ya F be type kroge to automatically male female type ho jyga
Apki bat shi h lakin isme aap kewa example dekh rhe ho jbki isme data validation ke trick se hum bde bde data ko ftafat complete kr skte h
Bhai if condition se bhee ho sakta hai ye aur bar bar click karne ki bhee jarurat nhe hai
@@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
Bhai fir wapas filter ko hatane ke liye kya karna hai
Heading select krke Ctrl+shift+L press kr do ho jayega
Excellent.
Ise bhi atcha trick he meri pass
Btaiye
Jitna time ye lagaya hai usse pahle to type karke sheet ready ho jati hai
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
Is se aasan formula bar formula fit kro or pure list me drag kr do
Ha simply ho jayega bro
But isme aap ke example dekh rhe h jbki yha data validation ke bare me btaya h
Agar ek ek entry hogaya to fir F or M type karne se hi aajata aur drop down se fast v hota....😂😂😂😂
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
i would used if name ends with vowel its female n then cross check karta puri list
Raju..
Aur jaldi chahiye to computer screen pe permanent marker se bhi male female likh sakte hai
Intelligent guys
Isse bhi easy trick hai
Bhai if ka formula karo and fhir and lga do usse honjyaga yrr
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 😊
Aur ek tarika hai pehle male sirf m type karo aur filter lagao aur male ctrl d karo ..firse blank filter lagake female ctrl d karo…
Great 👍
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
Example normal h but same trick se bde-bde data me fastly Kam complete kr skte h
Sidha option hey male likh kar copy kr do aur female wali ko bas female type krna
Yes normally ese hi krte h 😊 but isme data validation ke bare me btaya h
@@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😊
Bilkul shi smjha apne . thanks 😊
Trika to sahi he le kin select kerne ka trika thoda fast hona cahiye ager 10000 Colem hoto kiya hoga
Jyada entry ho to filter apply krke ek sath fill kr denge
Yaar aap filter use kr skte ho iske liye
Filter selected data ko show krne ke liye use Kiya jata h
Data aad/type krne ke liye nhi
Kyan isme countif( A3:A23,"male","female")
Yeh formula work nahi karega
Nhi
Formula bhi to hoga ishka kuch
Data Validation option me Jake hum condition set kr skte h
Ek baar mail aur ek baar female likh dene ke baad bs M ya F press karna aur tab dabane jitna kaam reh jata hai
Ha aap shi kh rhe h ese ho jayega
Lakin AAP yha kewal example dekh rhe h jo ki simple h lakin jo data validation ki trick btai h usse hum bde bde data ko customize kr ke ftaft complete kr skte h
@@DKTECH bro.. Im very much curious about how these GST tool excel sheet works. Please let me know if there is videos available of yours in this regard.
@@DKTECH I want to master ms excel in all respect. be it VBA script or other advance functions.
Pls visit: ruclips.net/p/PLJi6TcTY-9BmNJF2kT20cwXkXK5s_mpnK&si=u3Ellr2HgdRDZW6t
Shaandar
Thanks 😊
Use macro here
Yes
Just enter M or F.
Yes but we do multiple operation by using data validation
Let me know short key
Use shortcut key for fast working
Alt+A+V+V
nice
Thanks 😊
Thik you sir
Welcome 😊
Use formula if then result ok 👍
Good 👍
Superb
Thanks
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
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
@@DKTECH sir apko example hi thoda hard pakadna chahiye tha
@ajay-s1i1n8g9h ok
Shandar
Bro...Issey bhi asan tareeqa hai...reply Karo to m bta deta hoon😂
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
Nice trick..
Thanks 😊
❤❤❤❤
Cr cell select & copy paste
Yes
bhai isse fast koi tarika hai toh batana
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
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
Interview me yehi pucha Gaya tha ki aap bana k bata rahe ho
Jo questions interview me puche jate h unse similar questions hi trick me btaya jata h example ke tor par
Filter se aur jaldi kar sakte hai
Isme example chota h but same trick se bde data me hum ftaft work kr skte h
Isa better h 1bar copy karo or jah male h phela wah copy krta joe simply
Ha ese hum easily kr skte h lakin isme exqmpl se jyada data validation ki trick important h 😊
Are yar pahle first row me male and secend row me female fir fill formatting kar do 5 secend me ho jayega
Aap shi kh rhe ho lakin yha pe example normal h jbki data validation ki is trick se bde-bde data ko ftafat complete kr skte h
भाई एक बार मेल और फीमेल लिख लो। और आगे बस मेल है तो M लिखो और फीमेल है तो F लिखो अपने आप हो जायेगा। ड्रॉप डाउन लिस्ट से सेलेक्ट करने में 3 से 4 गुना कम टाइम लगेगा
नॉर्मली हम ऐसा ही करते ह लेकिन इसमें डाटा वैलिडिशन की ट्रिक बताई है 😊
@@DKTECH Yes bro
Data Entry job me future kya he re, usse accha Auto chalao 😍
ये तो हर आदमी की वैल्यू और स्थिति पर निर्भर करती है क्योंकि हर आदमी डाटा एंट्री नही कर सकता और हर आदमी ऑटो नही चला सकता
और वैसे नोकरी करने से लाख गुना बेहतर है ऑटो चलाना
Nice tq😊
Welcome 😊
Enter bottom hi kafi hai bhai 😅😅😂😂
Ha normally ese hi krte but isme data validation ke bare me btaya h 😊
i need data entry job
Firse learn MS office and comuter basic fundamentals (Printing, documents editing etc) and try in your nearest offices, schools, hospitals 😊
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
Right 👍 but don't look example because it's so simple and there are telling about data validation trick 😊
Mai bhi kuch Gyan ki bat likhna chahta hu
Why not....
One type male or female select mele or female copy and past🤭
Yes
Male aur female ke baad M or F type karo khatam
Bhai ek baar likh diya to third wale me sirf ek alfa bat dalna hai
Ha normally ese ho jayega but isme data validation ki conditional formatting ke bare me btaya h 😊
Btane ka tarika thoda casual hai 😮😂
Custam me aur easy hoga😊
Yes
Copy paste Sy jaldi nahi hojata ?
Ha, agr example dekhe to normally ese hi honjata but isme data validation ki trick btai h 😊
Kunhal bechara female bann gaya😅.... But thanks for this video❤❤❤
वाह, क्या दूरदृष्टि हैं आपकी 😂
Sabhi colum me female paste karke phir male wale naam ke samne se fe hata do
आइडिया अच्छा है लेकिन अगर एंट्री ज्यादा हो तो मेल, फीमेल देख देख कर डिलीट करने में बहुत टाईम वेस्ट होगा 🫢
दूसरा स्मार्ट तरीका ये भी है:
ruclips.net/user/shortsFDAgSulSoAs?feature=share
Thanks 👍👍
Bhai ye smart trick nahi lagta kyunki jab dekh kar he select karna hai to typing he sahi hai
Aap bahut fast bolte ho...... it's very difficult to understand
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 😊
👍
Good job
Thanks 😊