Crack Jobs #9 - How to Crack MIS Excel Interview? | MIS Interview Questions and Answers | Hindi
HTML-код
- Опубликовано: 16 сен 2024
- Learn about How to clear Excel interview?
Excel Formulas & Function based real time interview question faced to clear Excel Job Interview. Mis Job Seeker interview experience revealed.
Excel Interview Questions and Quiz in Hindi.
1.Calculate the total amount based on sales amount and quantity(Tricky Question)
2. Custom Sorting Question
3. Total a in Range (Substitute and len question)
4. Find out expensive mobile name (Vlookup Question)
5. Create a Pivot Table based on data
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-MIS Interview Cracker-Crack Jobs #9.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#excelinterviewquestions #excelquestions #Innozant #Exceltutorial #exceltips #interviewcracker
Nice video sir. You always come out with very detailed and precise questions and Answers. And personally I like the 2nd question based on sorting the month in order.🙏👍
Thanks Harivansh ji,Hope you like the Questions and done it❤️
Thank you for the suggestion. I used this approach to solve question no. 1 =VALUE(SUBSTITUTE($D6,"KG",""))*$C6 there is no need for helper column and custom formatting to multiple of quantity and sales amount.
Very Good attempt Ashish Ji..keep innovating..👍❤️🙏
Sir aaj mene ek company ka Pura test solve kr Diya aapki wjah se thank you so much 💞
Wow...God bless You
Namstai Sir ji. You are genious Teacher. God bless u..
Thanks Sandeep for your appreciation
that sorting question was a next level question sir ji great job. I have learnt advanced excel but they didn't teach me as the way you teach here.
Thanks Ankit..God bless You..Happy learning ❤️
I can learn properly through this video.. Thank u sir
2:17
sir isme total krne ke liye hum
=8203*substitute("12 kg","kg","") bhi kr skte h.(mere is function me values ki jgh cell name bhi use kr skte h).
and second method me ek column insert krne "12 kg" se sirf "12" likh lo fir flash fill se sari values automatic aa jayegi.
fir unko multiply kro sales amount se🙏😊
Haan Kar sakte hain but Ishu 8203 to static rhega na..yadi value change Hoga phir humara ye substitute nhi krega na Sahi work,Thorasa aur improvise krke sochiye aur bataiye mujhe ki yadi value dynamic ho to (I mean bi value koi aur )
Haan second method Sahi socha Aapne..👍Good Ishu❤️
Abhi aap Interview series Kar re hain Practice ya concept?saare concept bhi Apne clear Karte rehna Saath Saath.Ok.
@@Innozant sir mene apne comment me bola to shi bracket me
ki cell names bhi use kr skte h
mene isi liye bola tha vo bat bracket me.cell names use krne se dynamic ho jayega vo function. (i mean=c5*substitute(d5,"kg","") )
mene to us function me values example ke liye type ki thi.
reality me to cell names hi use krna h sir 😊🙏
👍👍Good Tiwari Ji❤️🙏
Very good question sir
Thanks Bhoopendra ji❤️
Amazing sir ji.....aise hi interview questions late rahiye sir.....❤️😍
Sure Altaf ji .Seekhte rhiye aur apne andar ka interview ka dar khatam kriye itna practice kriye
I'm watching your videos and your teaching method make me understand so very well. Great! Love from Pakistan
Thanks Zahoor
Very good questions and thank you for helping us. Your efforts will not go in vain as we are following you.
Thanks Honey .God Bless You dear
Bahut interesting but ek bar karne se yaad nhi rehta aur samajh mein bhi nhi ata bahat practice karna padhega. Thank you sir
Yes..mkeeo learning.keep exploring
Awesome, superb,very confident.!
Very good Question s
Thanks for such a valuable appreciation ❤️.
Lovely sir and thanks to build-up our confidence for solving many types of questions 🙏🏻
Thanks dear.
❤️❤️👍
Sir you're video always time is amazing 😎😎
Oosam sir👌
Thanks Dev
Left formula lga kr v unit nikal skte h sare KG me 2 hi digit h Jo common h (=sales*left(text,number of characters me 2 pass kr denge )
Great video
Nice sir for help to me
Amazing
Thanks Jaspal ji❤️
Thanku so much
Immediate subscribed.. reason Mis interview today
Aap k first question k leye ek aur way se calculate kar sakte hain without changing the format. Hum left function use kar k values ko multiply kar sakte. Zyada tor main aisa he karta hoon...
Jaise ki ? Aap left bhi use kroge tab bhi value the extract karna hi hoga na.i mean we need to conver it into no. Any how..Isn't it?
Achi baaat hai aap effort lagate hain ,kuch naya try karne ki koshish krte hai..Good hai..keep learning.
Q1 =sale amount*LEFT( quantity ,FIND(" ", quantity )) sir we can also use this formula
sir 2023 mein kis type ke excel ke practical questions pooche ja rahe hai interview me.sir explain kar sakte hai
Sir aapki every video very helpful
Thanks Moinu
Je baat
thank you sir for such a helpful video but how can be get spreadsheet with content like this?
sir aap sbhi vdos me bolte h subscribe or bell icon ko press krne ke....i swear sir jis kisi ne bhi aapki atleas two vedios bhi dhyan se dekhi h na..wo glti se bhi subscribe krna nhi bhulega
God bless You Keep Learning.Keep Growing
Thank you Sir very nice
😍😍😍😍😍😍😍
This video was uploaded on 2nd Aug 20. Although Unlock 2.0 had started but interview or recruitment had begun .🤔
Anyway loved your content and *STYLE*
aapne dhyan nhi diya ..Maine Telephonic interview ka jikra kiya hai ..lockdown hua tha job milna thore hi band hua tha dear ❤
Tq sir for valvubule information
Hope you like the questions
Sir !! Agar ek cell mein entry 2+3+4+5. Text ke form mein tab uska sum kaise nikala jaye
Sir aap left formula ka use karte to best hota
♥️👍
Sir, Q 3 me sum karne ki kya jarurat thi?
q3: another solution
=IF(MONTH(D5)>3, MONTH(D5)-3, MONTH(D5)+ 8)
sir aap example dete ho ya sahi me interview dete ho har Saturday ko
Aap sake liye ye mehnat dear...concept clear kariye aur interview cracker attempt kariye ..sure job lag jayegi
Nice video sir
Thanks
Thnq sir sir 2007 ms mein custom list kaha par hoti hai excel ki aur sir muje ek shoti c problem aa rahi aa lapy mein jab main ms excel open kata hun oh file blank book nhi show karta how jo save meine pehle se ki hai file wo hi open kar deta hai sir plc iska bhi salotion batadijiye
Office button top left me hoga uspe click krke create kriye..Gaurav ab new office 2013 ya 2019 install Kar lijiye..isme ab bht saare Jaye formula milenge
❤️❤️❤️❤️❤️
Jo aap files provide karte ho wo unsolved condition mein provide kardiya karo ussey hamein practice karne mein kaafi mehnat karni padhti hai jo ki achi baat hai. Aapne pehle hi solved files provide karwadi usse kya help hogi.
Aap jab practice start karen us wat answer hata Diya kriye aur khud se practice kriye..jab nahi ho paaye aapse tab aap answer sheet dekhna
@@Innozant Asal mein jab mein answer hatane ki koshish kar raha tha tow mujhe kaafi effort lagane padh rahe thei otherwise aapki mehnat ko salaam ki aap itne effort kar rahe ho ham sabko sikhane ke liye.
Sir isme jo length wala question kia..jisne a ki value nikalni thi..usme formula laga k ctrl shift enter ku kia..sidha enter ku nhi kia
Mil gaya sir answer
Good
Sir question no 2 me mera answer enter krne pr nhii aa rha hai or Ctrl shift enter pr answer right aa rha hai
If I insert left side one column before quality and take number and apply flash fill and side a digit no. Multiple to amount so??
Flash Fill work on data pattern..
i aply for mis operator in muncipality in nepal
Q.1 -- Sir can we use flash fill and only take numbers and not "KG" text?
Krutika Flash fill will follow Data pattern,So better use flash fill one then remove TEXT(KG) using substitute or find or replace with blank.
@@Innozant thanks for your quick reply with precision, sir. This is the main reason why I love to watch your videos and follow you.
Thanks Krutika ,You may save Whatsapp no. 7065069985 .
If I am unable to reply or may be your query you won't able to explain via comment box ,You are welcome to message/call me will surely try to respond .
Example ' Agar name likha hai , Rahul Kumar Singh , isko sort cut me kaise karenge sir
Means..kya shortcut like..kya chahte Hain aap bataiye .data me se
👍😎
🙏❤️
I want to become expert in excel
Offcourse banenge mehnat krenge to
👍
Sir Q1 m simply "Sales amt * Value(Qty)" s bhi kr skte h.
haan kar skte h
Sir Ctrl shift enter ku press krte hai
Jab single array function ya formula executive karna hota hai...
Playlist se pehle concept Seekhiye aayega samajh
Sir
Agar Qty kg me Text format me hai or cell Qty jayada hai to use no me convert karna chahiye har cell me qty manually change karne pe time waist hoga
Haan phir pehle use value me convert kr lenge phir formula apply ,❤️🙏
sir plz answer my question (Sir freshers se aaise hi question puchte hai kya) sir mai fresher hu parso mera interview hai amazon company me but sir mujhe aapke question slove karne me problem ho rahi hai SIR PLZ HELP ME what should i do...??
Wao....
Sir,MIS executive ka qualification kya lagte hai? Kaun sa computer course jaroori hai?please bataiye sir...
Graduate hain to achi BAAT hai , Graduation to chaiye HOTA hai ,Mis executive ke liye adv Excel strong kijiye Saath hi SQL air VBA kar lenge to ye complete package ho Gaya ye ache profile par switch kar jayenge aramse
@@Innozant sir,ye SQL aur VBA kya hai....thoda bataiye...
Aur sirf advance excel se ye MIS job kya nahi milegi?
Aap Basic excel playlist me 2nd video dekhiye ..appke saare doubt clear ho jayenge
VBA automation tool hai air SQL database query language
F4 press means $ symbol is not coming what is the issue
If you are using laptop kindly press F4 with Function key
Apko excel ki file send krna Chahta hun us ma problems hain wo mathod seekhnay hain excel ki file kaisay apko send kron? Email?
@innozantofficiap telegram id
Q2 SENCOND SOLVE NAHI HUA SIR
Interview me select hote ho ya reject video bana se phle interview ki ??
Nhi samjh aaya dear aapki baat..kya puch rahe hain ..ek Baar Sahi se repeat kijiye .🙏
@@Innozant bhaiya ap har video me kehte h fresh interview deke aaya hu toh aap job ke liye interview dete hai ya video banane ke liye... Aur agr job k liye toh har interview me select hote h aap??
Dear Aakash ,Video ke madhyam se aaplogon ko ye batane ki koshish hai meri ki chahe aap job me Hain ya nhi.. koshish yhi rhna chaiye ki Interview dete rhna chaiye isse Apne skills Ka pata chalta rhta hai ki hum Kahan stand Kar rahe hain..Rahi baat meri😁to aplogon ke life me value add Karne ke liye mujhse Jo bhi ho sakta hai humesha karta rahunga jisse Aaplog seekhne real time prob kaise face karte hain aurvaage badhen life me..yhi main Live interview series aur Interview cracker ke madhyam se seekhana chahta hu..umeed hai ap seekh rahe honge aur apni skills enhance Kar re honge..Happy learning Aakash Ji..🙏❤️🙂
Aap khud decide kijiye.yadi Aise Interview Questions ko aap BHI attempt karenge to Aapka selection Hoga na🙏👍
@@Innozant thank you so much for wishes.. but kal hi ek MIS ke interview me reject ho gya vlook up ke error ki wjh se meri bhi job chali gayi h
@@Innozant agr ap delhi me rehte h aur koi vacancy ho toh btaiyega mujhe
Sir Substitute wala thoda kam samajh aaya
Kyu Amit .phirse dekhiye ek baar recap krke video..still issue.. contact me
Sir shirt me vedio banaya karo, T-shirt me nhi, sir aap shirt me jyada achche lagte ho
Ok..Nisha Thanks dear for suggestion..oh apne notice Kiya ye to Maine kbhi dhyan hi nhi diya tha..Ok shirt bhi pehnenge dear
sir file nahi mil rahi........
Common link Description dekhiye.. excel Interview cracker folder me jaiye wahah file rakha hoga Crack Jobs #9
I want talk with you