Crack Jobs #20 - MIS Interview Questions and Answers | Mis Executive Interview Experience

[@muhammadwaseem70]

Jab main ny apki video dikhi to mujy laga k ab mera masla hal ho geya keun k apny jo farmuly baty hain un main sy bhot sary mery kam k neqly thanks video banany k liy

[@Innozant]

Thanks🙏🙂♥️

[@Learn_withkd]

Aap bhut acha padhate ho sir ekdam unique .... Sir aap hamare jaise ke liye aisi hi majedar video bnate rhiye aur khub pragati kriye sir ji...❤👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

[@Innozant]

Thanks.keep learning

[@VimalKumar-ih6ik]

You are really a good teacher

[@1gopalakrishnarao]

Excellent. You are explaining with examples. It would be of much help to the students/learners/addicts/users to learn a lot from you. Keep it up. Doing a great service indeed.

[@Innozant]

Thanks sir,Please find practice file (Link is there in description)

[@pramodbhavsar4488]

Sir aapna sabhi mis interview crack bina solve kare samaj nahi sakte kyuki aapki sabhi question awasame hai thank you sumproduct best function

[@Innozant]

Thanks Pramod ji,Hope aap questions ko enjoy karte hain aur regular practice karte hain🙂

[@techyfighterbyAftab]

Sir apki teaching methods amazing h Mai apse bht kuchh sikhne ko mil rha h bas
A lot of thx sir ji apko

[@Innozant]

Thanks Aftab ,Seeekhiye achese sab aur life me aage badhiye.God bless you🙏♥️

[@sandeepaswal8944]

Very useful & important questions. Thank you so much sir ji. Sharing your knowledge. You are mindblowing teacher

[@Innozant]

Thanks Sandeep🙏❤️🙂

[@abhishekjadli1566]

These questions actually show the depth of excel knowledge...
Sometimes i feel sad when I'm not able to solve Q's on my own... So many videos.. Grasping so much knowledge...
All thanks to you for providing quality data...✌️
I'll keep practicing them...
I mailed you a xl sheet today sir... Please do help me with that.

[@Innozant]

Thanks Abhishek ji for your valuable coent and appreciation. Keep rehearsing on regular basis.

[@NirajKumar-ie9xc]

Nice job sir

[@bhoopendraraghav9781]

Very nice questions sir...

[@Innozant]

Thanks Bhoopendra🙏♥️🙂

[@puransingh-sx2tk]

Kaam k question wah🙏👌

[@Innozant]

Thanks..Practice sheet se ek baar saare question rehearse jaroor kar lena

[@harivanshgautam3424]

Very important questions of interview 🙏 nice video sir 🙏

[@Innozant]

Thanks Harivansh Ji.♥️👍🙏

[@birdsanimals2562]

Excellent 👍

[@Innozant]

Thanks Kishan 🙏❤️

[@suji.net2016]

Sir jee apka video dekhne se phle hi mai like kar deti hu Q ki mai janti hu aaj aap kuch naya chatpatakdar hi leke ayenge😊

[@Innozant]

Hahaha..So sweet of you..❤️🙏Itne pyare commnent se to aur chatpatakdar(meaning pata nhi mujhe 😁 )Video laane ke liye motivate kar re hain Aap Sujata.Thanks for this much trust.

[@salmanrakim4885]

your videos amazing i have learned a lot of things from you

[@Innozant]

Thanks Salman,Please find practice file in description and rehearse it.

[@satishojha6240]

Very interesting question sir thanku very much but jaisa aap ne kaha practice is important so first practice then sleep.good night sir

[@Innozant]

I like your dedication Satish ji..M happy for you.♥️👍

[@knowledge-withfriend2686]

Fascinating.... Sir

[@Innozant]

Thanks..dear🙏👍❤️

[@kishoregosain5781]

Good sir,

[@Innozant]

Thanks Kishor🙏❤️

[@ssaap1212121121]

sir question no. 5 sum product ke elava index , choose, vlookup kisi or function se kiya jaa sakta hai. if yes please help me..

[@Innozant]

Offcourse Anuj kar sakte hain ,Yoi must try for the same

[@gauravbhatia7987]

Sumproduct good thnq sir

[@Innozant]

♥️👍

[@Saurabh-5-6]

Very good sir 😍

[@Innozant]

Thanks,Practice file uploaded.kindly rehearse

[@SaurabhKumar-vp4xm]

I like sumproduct

[@balamira297]

First ques can be done in gsheets using countif(ArrayFormula((G75:G="A")+(G75:G="B")),1). Pl ignore the cell references.

[@Innozant]

Good 👍❤️

[@minhazbin984]

Nice

[@Innozant]

Thanks Minhaz🙏❤️We welcome you to experience the taste of success with innozant -Seed of success.

[@hemantgusain1260]

Thanks you sir.

[@Innozant]

Thanks Hemant,Rehearse every single concept on regular basis.

[@hemantgusain1260]

@@Innozant ok sir

[@hemantgusain1260]

Sir agar mai 1st question ko normal way me karte hue if agar a ya b ho to 1 ho or 1 ko "1" me likhu toh answer kyu nahi aa raha. Or count se result aa raha hai toh sum lagane ke kya jarurat hai

[@Innozant]

Kaunse question me ..btana ek baar

[@hemantgusain1260]

interview cracker 1st question me. Agar mai 1 ko "1" likhu toh kya woh ushe text consider kar raha hai kya kyuki aise krne me result nahi aa

[@E_K18]

Amazingggg!!!!

[@Innozant]

Are wah Ansh..Back on track..Good to see.♥️🙏🙂

[@E_K18]

@@Innozant Yes Sir ❤️ I’ve started revising now

[@muhammadwaseem70]

sar main ny time calculate karna hai matlab (6:00am sy (7:00am) (10:00am)(11:00am)ye sab ak sath sum kary main ny ye farmula lagya hai =B1-A1+C1-A1+D1-A1 ye sum to karta hai par agr koi khali rakhun to wo time - kar deta hai plz koi farmula baty agr do kalum main time likhun to wo sum ho jay ak khali b hoto wo - na ho matlab jo time sum hota hai us main sy ak khali ka 6 hars - ho jata hai

[@akashsinha1246]

Sir I really follow your all videos i have a question that can we find All value of A without using Helpcol.

[@Innozant]

Why not..its simple ..kindly watch last video of sumproduct..btaya tha Akash ji♥️🙏

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@sadsongstatus8526]

Aaj ke sabhi questions thode tuf the

[@kapilkashyap7026]

Dear sir your channal is best . I like it. But I want your practice file .how I m get it pls revert me

[@Innozant]

Thanks...Kapil ji Video Description me dekhiye link diya gaya hai gar video me..jaise category Playlist banaya gya hai waise hi assignment Master folder diya gaya hai Playlist wise.

[@gamesworld_all]

Sir, Is this questions for freshers or experienced ?

[@Innozant]

Dear Akhil,For both fresher and experienced
Practice file uploaded.kindly rehearse

[@vasimuddinsheikh3766]

Until last video I was thinking I have become Shaktimaan of Excel but today these questions make me realize I am a big "0"

[@Innozant]

Hahahaha.Lovely..No you are Not Zero..
Alwyas rehearse and practice on regular basis.

[@aashanexcel2811]

2 nd questions we can also do by using =Filter(Salary,EmpName="A")

[@Innozant]

👍❤️

[@ankitmehra3074]

sir 2nd question mai apne -- sign use nhi kia why??

[@Innozant]

Multiply use kar skte hain .

[@vincentrodrigues1412]

I HV a data wherein I HV worker in time & out time in the following format In time. : 8.00hrs
Out time :19.30 hrs
Total hrs : ? Hw do I get this for 300 employees

[@Innozant]

Dear Vincent ,You may either change your time format first for a while using custom format then calculate the total hours time using mod formula.Still issue you may share your worksheet format
@innozantofficial telegram id.

[@RahulRoy-po9ct]

🙏

[@miteshpatel7101]

Practise file nahi he sir dusri download hoti he

[@Innozant]

Practise file uploaded,Kindly find link in description

[@paramjeet975singh3]

sir average wale question mai AVERAGEIFS(Amount,text(SalesDate,"mmm"),$M4,Name,N$3) ye formula work kyo ni kar raha hai ?

[@Innozant]

Kyu karega param aap sochna ek baar text function ko as array use kar re h yahan dear krega kaam🙂

[@paramjeet975singh3]

@@Innozant sir ye wala question average se kaise hoga.... Mere se ni ho pa raha h pls help

[@Robinkevat]

please sir dashboard ka our video baano

[@Innozant]

Monday aayega Daahboard video

[@bishtlokesh1297]

Only Sumproduct not other functions

[@Innozant]

Practice file uploaded..do rehearse

[@bishtlokesh1297]

Yes sure

[@virendersroha1754]

Sr wait mt krwa ya kro Saturday ka

[@Innozant]

Haha...Tbhi to is baar sat se 3 din pehle hi le aaye❤️😁🙏
Acha tha aajka concept

[@virendersroha1754]

@@Innozant 👍👍👍👍 gd sr vry gd

[@vocavakau]

All were easy but couldn't solve any one ...

[@Innozant]

❤️again attempt

[@vineshkumar7434]

Jitna number ham likhe itne hi serial number ho jaye

[@Innozant]

Ok..will try to add your question in upcoming videos.

[@vineshkumar7434]

@@Innozant thanks sir

[@abhishakya5263]

Thank you sir

[@Innozant]

❤️🙏

[@RahulRoy-po9ct]

🙏