Crack Jobs #9 - How to Crack MIS Excel Interview? | MIS Interview Questions and Answers | Hindi

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

[@harivanshgautam3424]

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.🙏👍

[@Innozant]

Thanks Harivansh ji,Hope you like the Questions and done it❤️

[@moinusaifi3164]

Sir aaj mene ek company ka Pura test solve kr Diya aapki wjah se thank you so much 💞

[@Innozant]

Wow...God bless You

[@Aashishrocks17]

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.

[@Innozant]

Very Good attempt Ashish Ji..keep innovating..👍❤️🙏

[@MonsVurivoj]

I can learn properly through this video.. Thank u sir

[@ankitmehra3074]

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.

[@Innozant]

Thanks Ankit..God bless You..Happy learning ❤️

[@ishutiwari5567]

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🙏😊

[@Innozant]

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.

[@ishutiwari5567]

@@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 😊🙏

[@Innozant]

👍👍Good Tiwari Ji❤️🙏

[@Altaf_Alam]

Amazing sir ji.....aise hi interview questions late rahiye sir.....❤️😍

[@Innozant]

Sure Altaf ji .Seekhte rhiye aur apne andar ka interview ka dar khatam kriye itna practice kriye

[@muhammadzahoor2093]

I'm watching your videos and your teaching method make me understand so very well. Great! Love from Pakistan

[@Innozant]

Thanks Zahoor

[@HeartymindAlways]

Very good questions and thank you for helping us. Your efforts will not go in vain as we are following you.

[@Innozant]

Thanks Honey .God Bless You dear

[@sandeepaswal8944]

Namstai Sir ji. You are genious Teacher. God bless u..

[@Innozant]

Thanks Sandeep for your appreciation

[@KaranSaim]

Sir you're video always time is amazing 😎😎

[@SaurabhGupta-ns8gx]

Immediate subscribed.. reason Mis interview today

[@snehashis_09]

Bahut interesting but ek bar karne se yaad nhi rehta aur samajh mein bhi nhi ata bahat practice karna padhega. Thank you sir

[@Innozant]

Yes..mkeeo learning.keep exploring

[@jaishrisaxena1083]

Awesome, superb,very confident.! Very good Question s

[@Innozant]

Thanks for such a valuable appreciation ❤️.

[@Ann_2208]

Lovely sir and thanks to build-up our confidence for solving many types of questions 🙏🏻

[@Innozant]

Thanks dear. ❤️❤️👍

[@hairavyadav6579]

Hello sir, For first question we can use this approach by making any changes in question given by interviewer .. My approach (SUBSTITUTE(B2,"kg"," ")+0)*A2

[@bhoopendraraghav9781]

Very good question sir

[@Innozant]

Thanks Bhoopendra ji❤️

[@Sai-tek]

Great video

[@ShabbirKhan-pq8iq]

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 )

[@prashantgurav8785]

Nice sir for help to me

[@afnanforyou]

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...

[@Innozant]

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.

[@rabiraul623]

Thank you Sir very nice

[@moinusaifi3164]

Sir aapki every video very helpful

[@Innozant]

Thanks Moinu

[@sudeshrajkumar7664]

Thanku so much

[@historypoint1381]

Oosam sir👌

[@Innozant]

Thanks Dev

[@MohitBadgotra-of7xu]

Q1 =sale amount*LEFT( quantity ,FIND(" ", quantity )) sir we can also use this formula

[@Abhisheksoni8738]

sir 2023 mein kis type ke excel ke practical questions pooche ja rahe hai interview me.sir explain kar sakte hai

[@Sonditya1k]

thank you sir for such a helpful video but how can be get spreadsheet with content like this?

[@yashanandmanikpuri4672]

Je baat

[@jaspalrana9541]

Amazing

[@Innozant]

Thanks Jaspal ji❤️

[@mostofaakash6898]

Thank you sir.

[@explomediapramod5289]

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*

[@Innozant]

aapne dhyan nhi diya ..Maine Telephonic interview ka jikra kiya hai ..lockdown hua tha job milna thore hi band hua tha dear ❤

[@sumansoni3223]

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

[@Innozant]

God bless You Keep Learning.Keep Growing

[@hemukosuru5286]

Tq sir for valvubule information

[@Innozant]

Hope you like the questions

[@binnipal9071]

Nice video sir

[@Innozant]

Thanks

[@reena-k-verma]

Sir, Q 3 me sum karne ki kya jarurat thi?

[@SatishKumar-jd5it]

sir aap example dete ho ya sahi me interview dete ho har Saturday ko

[@Innozant]

Aap sake liye ye mehnat dear...concept clear kariye aur interview cracker attempt kariye ..sure job lag jayegi

[@TheVaibhav1982]

Sir !! Agar ek cell mein entry 2+3+4+5. Text ke form mein tab uska sum kaise nikala jaye

[@haneefsalmani5165]

😍😍😍😍😍😍😍

[@amandev7371]

q3: another solution =IF(MONTH(D5)>3, MONTH(D5)-3, MONTH(D5)+ 8)

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@priyankasharma-xz9io]

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

[@priyankasharma-xz9io]

Mil gaya sir answer

[@Innozant]

Good

[@krutikashelar6521]

Q.1 -- Sir can we use flash fill and only take numbers and not "KG" text?

[@Innozant]

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.

[@krutikashelar6521]

@@Innozant thanks for your quick reply with precision, sir. This is the main reason why I love to watch your videos and follow you.

[@Innozant]

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 .

[@johndas8173]

Sir aap left formula ka use karte to best hota

[@Innozant]

♥️👍

[@gauravbhatia7987]

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

[@Innozant]

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

[@AR-il5qj]

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??

[@Innozant]

Flash Fill work on data pattern..

[@sanjupaul9827]

Sir,MIS executive ka qualification kya lagte hai? Kaun sa computer course jaroori hai?please bataiye sir...

[@Innozant]

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

[@sanjupaul9827]

@@Innozant sir,ye SQL aur VBA kya hai....thoda bataiye...

[@sanjupaul9827]

Aur sirf advance excel se ye MIS job kya nahi milegi?

[@Innozant]

Aap Basic excel playlist me 2nd video dekhiye ..appke saare doubt clear ho jayenge

[@Innozant]

VBA automation tool hai air SQL database query language

[@abhishekjadli1566]

Sir Q1 m simply "Sales amt * Value(Qty)" s bhi kr skte h.

[@Innozant]

haan kar skte h

[@HeartymindAlways]

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.

[@Innozant]

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

[@HeartymindAlways]

@@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.

[@aakashparmar6704]

Interview me select hote ho ya reject video bana se phle interview ki ??

[@Innozant]

Nhi samjh aaya dear aapki baat..kya puch rahe hain ..ek Baar Sahi se repeat kijiye .🙏

[@aakashparmar6704]

@@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??

[@Innozant]

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🙏👍

[@aakashparmar6704]

@@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

[@aakashparmar6704]

@@Innozant agr ap delhi me rehte h aur koi vacancy ho toh btaiyega mujhe

[@ajaysukarwal1018]

Sir question no 2 me mera answer enter krne pr nhii aa rha hai or Ctrl shift enter pr answer right aa rha hai

[@sanskritisingh8118]

Example ' Agar name likha hai , Rahul Kumar Singh , isko sort cut me kaise karenge sir

[@Innozant]

Means..kya shortcut like..kya chahte Hain aap bataiye .data me se

[@halwahekya3345]

👍😎

[@Innozant]

🙏❤️

[@govindlal2253]

👍

[@sobhittiwari2932]

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...??

[@paramjeet975singh3]

Wao....

[@Nepalisanthalichannel]

i aply for mis operator in muncipality in nepal

[@haneefsalmani5165]

I want to become expert in excel

[@Innozant]

Offcourse banenge mehnat krenge to

[@arunkumar-zt7ks]

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

[@Innozant]

Haan phir pehle use value me convert kr lenge phir formula apply ,❤️🙏

[@ajaysukarwal1018]

Sir Ctrl shift enter ku press krte hai

[@Innozant]

Jab single array function ya formula executive karna hota hai... Playlist se pehle concept Seekhiye aayega samajh

[@HafizHaroonAsghar]

Apko excel ki file send krna Chahta hun us ma problems hain wo mathod seekhnay hain excel ki file kaisay apko send kron? Email?

[@Innozant]

@innozantofficiap telegram id

[@tejasr6108]

F4 press means $ symbol is not coming what is the issue

[@Innozant]

If you are using laptop kindly press F4 with Function key

[@sanjaypingale6201]

Sir

[@chiragsharma1107]

Q2 SENCOND SOLVE NAHI HUA SIR

[@nishachauhan9103]

Sir shirt me vedio banaya karo, T-shirt me nhi, sir aap shirt me jyada achche lagte ho

[@Innozant]

Ok..Nisha Thanks dear for suggestion..oh apne notice Kiya ye to Maine kbhi dhyan hi nhi diya tha..Ok shirt bhi pehnenge dear

[@peaceofmind3124]

Sir Substitute wala thoda kam samajh aaya

[@Innozant]

Kyu Amit .phirse dekhiye ek baar recap krke video..still issue.. contact me

[@Jitenderkumar-yp1rn]

sir file nahi mil rahi........

[@Innozant]

Common link Description dekhiye.. excel Interview cracker folder me jaiye wahah file rakha hoga Crack Jobs #9

[@sanjaypingale6201]

I want talk with you

[@hairavyadav6579]

mere lye toh 2024 aacha nahi rha