Crack Jobs HATKE #37 - MIS Interview Questions and Answers | MIS Executive Work details

Поделиться
HTML-код
  • Опубликовано: 5 окт 2024
  • MIS Interview Questions and Answers | MIS Executive Work details
    MIS Interview Cracker Playlist Link- • MIS Interview Cracker
    Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.c...
    Music: www.bensound.com
    Learn how to clear excel interview? Excel formulas and function based real time interview question faced to clear excel job interview. MIS Job Seeker interview experience revealed.
    1.Convert tonumber
    2. Month wise total sale
    3. Count of a text in text string
    4.Value to find
    5. Find out sale amount using Vlookup and choose
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.c...
    ✅ Mastering Power BI Video Course
    www.innozant.c...
    ✅ Mastering VBA Video Course
    www.innozant.c...
    ✅ Mastering SQL Video Course
    www.innozant.c...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozanti...
    #misinterviewquestions #crackjobs#Innozant #excelinterviewquestions #misexecutiveworkdetails

Комментарии • 160

  • @shortsshorts4719
    @shortsshorts4719 3 года назад +1

    Your hidden talent come out as a जटाधारी जी।।

    • @Innozant
      @Innozant  3 года назад

      Haha..Thanks Dear Neeraj❤❤

  • @muhammadsaqlain5162
    @muhammadsaqlain5162 2 года назад +1

    Man sir ap k baaray man kya kahun bus itna kehna chahta hon k ap nay to is tarah ki video bana ker youtube man dhamaka ker diya very funny and amazing talent.

    • @Innozant
      @Innozant  2 года назад +1

      Thanks dear..God bless you .keep exploring ❤️

  • @TheSuvankarKundu
    @TheSuvankarKundu 3 года назад +1

    Yaaaaaaaaasss... Awesome.. Sir... It shows ur acting skills also... Awesome...

    • @Innozant
      @Innozant  3 года назад

      Thanks Suvankar❤❤🙏🙏

  • @The-Fronted
    @The-Fronted 3 года назад +1

    Ye tarika hat ke hai
    Thanks sir
    Share your knowledge

    • @Innozant
      @Innozant  3 года назад

      Thank Khan sahab❤💖

  • @Freeexcel
    @Freeexcel 3 года назад

    All question is solved with good approach. I hardly great thanks for given me good knowledge and experience...

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Dear..god bless you❤️🙏

  • @tejpalsain1507
    @tejpalsain1507 3 года назад

    क्या बात है सर मजा आ गया।
    जटा जी एक बार फिर आये , अपनी स्टाइल से ओर अपनी ओवर कॉन्फिडेंस वाली हरकतों से छा गये। आता तो सब हैं पर अपने ओवर कॉन्फिडेंस से सब सत्यनाश कर देते।
    सच में ये वाली सीरीज उन सब स्टूडेंट्स के लिए सबक हैं जो हवा में उड़ने लगते हैं।
    Thanks for it.

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Tejpal ji❤❤Haan bht jyada log hote h over confidence me urne wale aur kbhi mante nhi hain ki unme kami hai

    • @uniquemobiletipstricks7714
      @uniquemobiletipstricks7714 Год назад

      ​@@Innozantसही बात है जय माँ kali

  • @jayantabhattacharyya628
    @jayantabhattacharyya628 3 года назад +2

    Dear Sir
    Excellent comeback of JATADHARI JI with superb MIS interview questions. Sir, your MIS interview question level is very good yet not so tough. I am trying to solve every MIS interview cracker tutorial.
    Thanks
    Jayanta Bhattacharyya

    • @Innozant
      @Innozant  3 года назад

      Thanks Jayanta😀❤❤

  • @Sanddystar17
    @Sanddystar17 3 года назад

    woww sir kya baat hai jatadhari ji ke concept ka ..bahut achha laga sir🙏😊😊😊😊

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Sandeeep Ji..Jai Jatadhari😀

    • @Sanddystar17
      @Sanddystar17 3 года назад

      @@Innozant 😁😁😁😂😂

  • @situsahoo2482
    @situsahoo2482 3 года назад

    Sir aaj aapne khus kar diya.jata ji having positive soch leke.and giving best.❤️.This one is super .opening stock analysis.with vlook up .ek bat sir hamara ek level up ho gaya hai aur office mein.aage nikla.yeh sab aapke baje se.Thanks dilip sir ❤️🎉

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Sahoo Sahab..Hope aapne Jata ji episode enjoy kiya aaj .Wow sachme ye acha laga sunkar ki aapke life me ye Tutorial value add kar pa raha hai..M happy❤❤

  • @pragatirai9512
    @pragatirai9512 3 года назад

    Gajab jatadhari ji 😃😃 multi talented hai sir aap to... Bahut badhiya sir ji 😊😊😊

    • @Innozant
      @Innozant  3 года назад

      Hahaha Thanks Pragati ji.❤❤🙏🙏

  • @AbhishekKumar-nb4et
    @AbhishekKumar-nb4et 2 года назад

    Advance excel +Action skill =Innozant😍😍

    • @Innozant
      @Innozant  2 года назад

      Thanks dear❤️

  • @ishutiwari5567
    @ishutiwari5567 3 года назад +2

    cha gye jata ji😂
    great content as usual😊
    thank you sir for this informative video🙏

    • @Innozant
      @Innozant  3 года назад

      Thanks Ishu..Hope you like jatadhari series

  • @E_K18
    @E_K18 3 года назад +1

    Excellent acting skills and question quality ✌🏻

  • @satishojha6240
    @satishojha6240 3 года назад

    Very very special video of this channel with knowledge and entertainment thanku sir 🙏🙏🙏🙏

    • @Innozant
      @Innozant  3 года назад

      Thanks Satish Ji..Happy Learning dear.❤❤🙏🙏

  • @arjuntuteja5955
    @arjuntuteja5955 3 года назад +2

    Sir bohot mst way h 😂
    Ye hum log hi h jo ese overconfident horkhe hote h...

    • @Innozant
      @Innozant  3 года назад

      Haan Jata ji se bhut kuch seekha ja sakta hai

  • @rjraviraftarup7553
    @rjraviraftarup7553 3 года назад +1

    Kafi majedar sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Ravi Ji❤

  • @ManishVerma-gg8xl
    @ManishVerma-gg8xl Год назад

    हर एक problem का solution एक ही है हमारे जटाजी 🙂🙂
    जय भोले 🙏🙏

    • @Innozant
      @Innozant  Год назад

      Hahahaha 😂👍❤️

  • @rjraviraftarup7553
    @rjraviraftarup7553 3 года назад +1

    Bahut badhiya

  • @RohitKumar-cc7zi
    @RohitKumar-cc7zi 3 года назад +1

    Yo are superb sir, with great acting with great explanation on these questions, just keek it up, great sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Rohit Ji.Happy Learning❤❤❤

  • @golubro9517
    @golubro9517 2 года назад

    Sir Aap Great Ho ❤️😇

  • @Jitenderkumar-yp1rn
    @Jitenderkumar-yp1rn 3 года назад +1

    Well done sir jii & Jata ji..😃 very interesting or excellent questions. Thanks sir..😍😍❤❤

  • @artiverma5122
    @artiverma5122 3 года назад +1

    So sweet of you sir, I also sad about my job😔

    • @Innozant
      @Innozant  3 года назад

      Thanks Arti,But sad rahebge nhi jyada din tak 🙂

  • @balamira297
    @balamira297 2 года назад

    Second largest value can be done using large(filter(J21:J,K21:K="A"),2) in google sheets .

  • @tarunsharma714
    @tarunsharma714 3 года назад

    Multi talented ho sir excel guru bhee aaur actor bhee thanku sir for your videos my friends are shocked how can you apply these formula becausethey think simple vlookup aata hai to sabb aata hai thanku sir once again

    • @Innozant
      @Innozant  3 года назад +1

      hahaha..Thanks Tarun Ji..🙏🙏Unse kahen ek baaf Vlookup Seried Video jaroor dekhen

    • @tarunsharma714
      @tarunsharma714 3 года назад

      @@Innozant sir mera ek questions hai mera excel mey interest bahut zyada hai and mainey bcom puri ki hai to sir excel mey power bi aaur vba learn karr sakta hu jissey mera excel mey aaur growth ho

  • @learningNewIdea
    @learningNewIdea 3 года назад

    Excellent maja aagaya 😘😘😘😘😘

    • @Innozant
      @Innozant  3 года назад

      Thanks dear❤️🙏

  • @dilipshedge8503
    @dilipshedge8503 2 года назад

    We all loved your way of explanation ❤️
    Liked ✔️
    Shared ✔️
    Subscribed ✔️

  • @vocavakau
    @vocavakau 2 года назад

    Bas #JataDhari ji waala confidence hi chahiye jindgi me, thank you very much sir_

    • @Innozant
      @Innozant  2 года назад +1

      Aayega♥️😊waqt ke saath...God bless You

  • @VlogAvi
    @VlogAvi 2 года назад +1

    Sir my Favourite Jhatadhaari Character is Back again.

    • @Innozant
      @Innozant  2 года назад +1

      Yes dear..phir layenge vidoes jata series

    • @VlogAvi
      @VlogAvi 2 года назад

      @@Innozant sure sir.. I'll wait for it

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

    O Nice sir G, Kamal h

  • @VlogAvi
    @VlogAvi 2 года назад

    Aapki Acting Bohot achi hai...like a Professional Actor I swear

    • @Innozant
      @Innozant  2 года назад +1

      Acha ji.. Thanks itne pyare feedback ke liye..main jarur aur videos lane ki koshish krunga

    • @VlogAvi
      @VlogAvi 2 года назад

      @@Innozant I have learnt the whole Excel playlist of Basic to Adv.Excel..thnk u for Your Guidance

  • @RamSingh-ol5xz
    @RamSingh-ol5xz 3 года назад

    Nice sir aap bhut bhut best actor hai

  • @amitapattanaik1071
    @amitapattanaik1071 3 года назад

    Very Entertaining, with learning

    • @Innozant
      @Innozant  3 года назад

      Thanks for your love and support

  • @badalsingh2050
    @badalsingh2050 3 года назад

    Super sir!! enjoying with learning

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Singh Sahab❤❤

  • @muhammadsaqlain5162
    @muhammadsaqlain5162 2 года назад

    Man to jata g ko nahi bhool sakta👍👍👍👍👍

  • @RajThakur-rd8co
    @RajThakur-rd8co 2 года назад

    You are really great sir, 🙏🙏🙏

    • @Innozant
      @Innozant  2 года назад

      Thanks Raj❤️👍

  • @SamarSingh-df8kw
    @SamarSingh-df8kw 3 года назад

    Super 👍👍👍 sir ji

  • @haneefsalmani5165
    @haneefsalmani5165 3 года назад

    Ab ap hi mere guru ji ho

    • @Innozant
      @Innozant  3 года назад

      Thanks 🙏🙏❤️

  • @K-Starreaction
    @K-Starreaction Год назад

    Superb sir

  • @mr.psk.972
    @mr.psk.972 3 года назад

    In question 3 we can find position of "/" and accordingly use mid to extract DOB.

  • @achalrajput4173
    @achalrajput4173 Год назад

    Sir, second question m sumproduct lagane ki kya jarurat h direct large s suru kariye na answer same hi aayega . Sumproduct ko hatakr baki sb same to same likh do.

  • @sourabhsaini7010
    @sourabhsaini7010 3 года назад

    This one is more relatable
    Good Sir ji

    • @Innozant
      @Innozant  3 года назад

      Thanks Sourabh❤

  • @puransingh-sx2tk
    @puransingh-sx2tk 3 года назад +4

    Main bhi bolta hoon,
    aap bhi bolo
    inozent ne life bana de
    "Easy" 👍👌🏻😂

    • @Innozant
      @Innozant  3 года назад

      Hahahha
      Love you Puran❤❤

    • @AvinashSingh-im4oc
      @AvinashSingh-im4oc 3 года назад

      @@Innozant apka Stock wala Formula Kam nahi kar raha hai Date(2018, Month(1&E2), 1) ye formula mere execell per kam nahi kar rahahai aisa kyo

  • @RamSingh-ol5xz
    @RamSingh-ol5xz 3 года назад

    Super hit video

    • @Innozant
      @Innozant  3 года назад

      Thanks Ram 😀❤💖

  • @amansinha19891
    @amansinha19891 3 года назад

    Gazab sir....

  • @haneefsalmani5165
    @haneefsalmani5165 3 года назад

    Learning

  • @ramanmangat3320
    @ramanmangat3320 3 года назад

    Thnk u sir, jata ji to sha gye ajj😅❣️

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Raman..Hope aapne enjoy kiya aaj Jatadhari video

    • @ramanmangat3320
      @ramanmangat3320 3 года назад

      @@Innozant yessss sirr bhoot, or sikhne ko v bhoot milla

  • @nehatiwari5123
    @nehatiwari5123 3 года назад

    Very good tutorial.

    • @Innozant
      @Innozant  3 года назад

      Thanks Neha❤❤🙏🙏

  • @adarshgupta6012
    @adarshgupta6012 3 года назад

    Sir aap to teacher k sath sath ek achhe actor v h 🤪

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Adarsh Ji😜❤🙏🙏

  • @haneefsalmani5165
    @haneefsalmani5165 3 года назад

    I want to give my best

  • @gauravbhatia7987
    @gauravbhatia7987 3 года назад

    Good

    • @Innozant
      @Innozant  3 года назад

      Thanks Gaurav ji

  • @sahilsreedharan
    @sahilsreedharan 3 года назад

    wow sir
    👌🏻👌🏻👌🏻👌🏻

    • @Innozant
      @Innozant  3 года назад

      Thanks Sahil ji..❤❤

  • @sagararora8040
    @sagararora8040 3 года назад

    nice sir

  • @Crazydin11
    @Crazydin11 2 года назад

    Amazing vedio sir, bt 11:22 wli example jis mai large number in "A" Series wla...
    Agr ussi mai hmmai smallest 1 find krna ho toh yai formula nhi lg rha, why? And share the solution agr "A" Ka smallest number find krna hai toh kesai hoga

  • @hemantgusain1260
    @hemantgusain1260 3 года назад

    Awesome

    • @Innozant
      @Innozant  3 года назад

      Thanks Hemant❤💖

  • @The-Fronted
    @The-Fronted 3 года назад

    Nice

  • @The-Fronted
    @The-Fronted 3 года назад

    Jatadhari explain same feeling on interview

    • @Innozant
      @Innozant  3 года назад

      hahah 😀Thanks Arif sahab

  • @neerajtomar9018
    @neerajtomar9018 3 года назад

    Jata dhari good

  • @RahulRoy-po9ct
    @RahulRoy-po9ct Год назад

    🙏

  • @konkankid5401
    @konkankid5401 3 года назад

    Kya sir ap resume sample for this job ka playlist banake share kar sakte ho ?

    • @Innozant
      @Innozant  3 года назад +1

      Resume sample for mis executive ,data analyst already share kiya hai maine playlist career guide dekhen

  • @Zain-fg6ru
    @Zain-fg6ru 2 года назад

    14:44 sir itna lamba choda kyun kiya aap ne use to ham simple text mid or find se bhi kar skte hain example ke liya
    =TEXT(MID(A4,FIND(0,A4),10),"dd/mm/yyyy")
    Isme pehle hamne date nikala mid ka formula lga ke strating no. Maangta hai to do hamne find se nikal liya, or end no. To Coman si baat usme Jo date hai vo 10 no. Ki hai to hamne 10 likh diya, ye sara cheez hamne de diya text ko or usko bol diya ke bhai ise dd/mm/yyyy ke format me nakal ke Dede,
    Ans ajaega

  • @haneefsalmani5165
    @haneefsalmani5165 3 года назад

    Sir man gai ap ko

  • @PankajAashu
    @PankajAashu 2 года назад

    👌👌👌👌👌👌👌

  • @opchhonker990
    @opchhonker990 2 года назад

    Sir a piovet table and vlookup all intervew question a to z

    • @Innozant
      @Innozant  2 года назад

      Watch mis interview cracker series

  • @nishachauhan9103
    @nishachauhan9103 3 года назад

    Vedio tume 9:01 me Sir, आपने "second max of A" question me 2 solution bataye hai pehle wala aapne if se kiya hai aur doosra sumproduct se kiya hai aur aapne dono tarike ko sahi bataya hai. Me ye poochna chahti hu kee pehle wale tarike ka answer 321 aa raha hai aur doosre tarike ka answer 124 aa raha hai . Sir pehle wale ka answer ctrl shift enter press na krne kee vajah se galat aa raha hai kya???????

    • @Innozant
      @Innozant  3 года назад +1

      haan...array hoga to ctrl shift enter press krenge nhi to wo single cell ka value le rha higa Nisha

  • @narendernath4995
    @narendernath4995 3 года назад

    जय जटाधारी

  • @sarojkakitchen
    @sarojkakitchen 3 года назад

    Sabse aage kon ........jataji

  • @abirsarkar7075
    @abirsarkar7075 3 года назад

    Sir ap questions kaha se late ho.
    Thank you

    • @Innozant
      @Innozant  3 года назад

      🙏🙏🙏❤💖💖

  • @Ashutosh-dl7cg
    @Ashutosh-dl7cg 2 года назад

    Learn with fun

    • @Innozant
      @Innozant  2 года назад

      Thanks ❤️👍

  • @mohitchauhan7808
    @mohitchauhan7808 3 года назад

    👍👍👍👍

    • @Innozant
      @Innozant  3 года назад

      Thanks Mohit Ji❤

  • @CR_7717
    @CR_7717 3 года назад

    Sir apna into kyo lagaya hai please reply

    • @Innozant
      @Innozant  3 года назад

      kaunse ques me .Shiva ?

    • @CR_7717
      @CR_7717 3 года назад

      Sir 2 wale main

  • @AdityaSingh-xj2hy
    @AdityaSingh-xj2hy 3 года назад

    Sir data analyst me carrier ke liye excel kitna aana jaruri hai?

    • @Innozant
      @Innozant  3 года назад

      Aditya Jitna excel ache se aaega kaa. karna aur aasan hoga

    • @AdityaSingh-xj2hy
      @AdityaSingh-xj2hy 3 года назад

      Thank you sir

  • @AshishKumar-hc3km
    @AshishKumar-hc3km 3 года назад

    Sir ye jatadhari kaun hai
    Hahahah nice name

    • @Innozant
      @Innozant  3 года назад +1

      Hum sab me kahin na kahin jatadhari chupa hota hai😀

  • @The-Fronted
    @The-Fronted 3 года назад

    Week me 1 baar jatadhari jarur aana chahiye

    • @Innozant
      @Innozant  3 года назад

      Acha ji..pasand aaga aapko

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

    Extract Dob wala smj nhi aaya

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

      Why?repeat video again

  • @sitaramkohli9549
    @sitaramkohli9549 3 года назад

    👍👍👍🙏🙏🙏

  • @gajudesai
    @gajudesai 3 года назад

    Sach m sabse aage Jataji 😀😁😅😂🤣🤣

    • @Innozant
      @Innozant  3 года назад

      haha..Thanks Gajanan Sahab..Hope aapkp Jataji ka interview pasand aaya aur unka confidence bhi.❤❤🙏🙏

  • @mohammadaijaz4901
    @mohammadaijaz4901 3 года назад

    hahah sir jetha lal g ko mat chorna plz in se bohat maza aata hay....

  • @abhilashkumar5697
    @abhilashkumar5697 2 года назад

    Sir ye kis line main aa gaye aap😂😂

    • @Innozant
      @Innozant  2 года назад

      Hahahaha.. Thanks Abhilash Ji

  • @shrikantbadge3978
    @shrikantbadge3978 3 года назад

    Active mode + acting mode hahahahah

    • @Innozant
      @Innozant  3 года назад

      Thanks Shrikant..😀❤🙏🙏

  • @RamSingh-ol5xz
    @RamSingh-ol5xz 3 года назад

    Hot video hai

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

    Worst actor.pls I request you pls concentrate on teaching other than acting pls it is really irritating

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

      Kindly focus on context only and said content.Happy Learning👍