Crack Jobs #26 - MIS Interview Questions and Answers | Mis Executive Work details Excel Interview
HTML-код
- Опубликовано: 11 сен 2024
- MIS Interview Questions and Answers | Mis Executive Interview Technical Round | Mis Executive Work details Excel Interview
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. Reverse the data order
2. Extract the Employee name based on given employee id and data table(Data1,Data2,Data3) using VLOOKUP formula only(not index,choose ,indirect etc)
3. Vlookup with Helper column unique vale example
4. Vlookup Formula Limitation question
5. Highlight the special point data value using conditional formatting
MIS Interview Cracker Playlist Link - • MIS Interview Cracker
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========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
Sir sach mai aap great ho. 20min ka video pata hi nahi chala kaab khatam hua pata hi nahi chala lagra tha bus shikta jaau mai aur kya hai aagai esh video mai. Practice karkai maja aagya muje abhi. 3baar practice bhi kar li mainai. Aapkai har video muje ek nayi disha daitai hai muje. God bless u. Aapka sath hamesa uhi bana rahai.
Practice file uploaded.🙏❤️ Thanks Sandeep Ji
Needful..sir..
Thank you for intersting video
Sir ji, I have seen your more than 100 videos, but today's video is superb, awesome and fantastic.
Aaj ki video me sare function ese the jo office me maximum used hote hai 🙏❤️.
Mujhe sirf nestedif ke bare me hi pata tha par aaj nested vlookup ke bare me bhi seekha😀.
🙏🙏🙏
Thanks dear... Practice file uploaded..Kindly do the Practice for the same.Hope you enjoy the questions 🙏👍❤️
Thank you sir for Example question with logical and correct solution & along with this making available Excel sheet for practice really its mean a lot in ton.
Thanks Once Again for your great initive for us.
Thanks Shivkesh ji for wonderful and valuable feedback.❤️🙏🙂Your words really mean a lot to me.👍❤️
you are great sir..................👈👈👈
Sir apka to fan ho gya mai . Bs wait hai VBA ka
❤️🙏
Super sir ji thank you.
I learn from this vedio vlookup limitations.
Thanks
Thanks Ghanshyam ji
@@Innozant most welcome sir. Thank for reaching us Sir
Sir bahut kamal ke questions and series aati hai apki 👍👍
Thanks Human Sahab❤️🙏👍
Amazing series sir good night
Practice jaroor karna Satish .❤️🙏👍
Great Guruji..Thanks
Great sir
Bahut hi badhiya jii... interesting question h saare..😍❤❤
Thanks Jitender ..Practice jaroor karna ..👍❤️🙏
@@Innozant jii sir.... File download kar li h....
Sir ji question itne interesting hote hai ki dil karta hai ki video khatam hi na ho or sir ager machine round clear ho jaye to kitne percent chance hote hai job lagne ke
Love you Akash...❤️🙏Machine round clear Kar Diya phir to apna kaam done .Uske baad to formality round and select sure.👍🙏
Youre amazing sir.
Ist question Mai normal series 1 to 13 bana skte fir data sort kr dete z to a then may it is also a good trick but with formula ur method is osm 💯💯💯👌👌😊😊🤗🤗
Haan mayank..bilkul kar sakte hain..But wo jugar ho gya usse better formula ydi use karen wo jyada effective
@@Innozant yes u r right and thank you
🙏🙏🙏🙏...sir Aap Bhujpuri language use kiye h Output me chahathen..
❤️
Kaash week main 2 Saturday hote interview series ka wait nahi karna hota😁👌🏻😂😁shandar
Thanks Puran..Itna pyar dene ke liye....God bless your dear...❤️🙏👍
Sir.. agar vlookup me value error aaye to isko solve kese krenge wo nhi btaya. please btaiye.
or MIS me job opportunity kis level tk ki h. wo b btaye.
Thnq sir
Perfect and best.
Thanks Tejpal... Practice kijiye ..ques Ka .saare 👍❤️🙏
Another solution of first question
1. Copy entire data and paste at destination place
2. Write series no. Starting from 1 till end in helper column
3. Select pasted data with helper column and apply sorting by number largest to smallest.
Good Mohit... Formula based solution kariye Kuch☺️❤️👍
Really knowledgeable
👍🙏❤️
Sir mujhe ye jan na hai ki MIS ke job ke liye mostly kya jruri hota h like formulae mai please agr possible ho to ap bata dijiye apki videos bhut helpful h mre liye thank u uske liye♥️
Advanced Excel strong kijiye apna saath hi SQL ki knowledge bhi jaruri hai
@@Innozant ok sir thank u so much♥️
🙏
Sir apne btaya nai mene pocha tha k agar cell me value (2+2) kuch is trah se likhi ho to uska sum kaise kare gy ??
Cell me 2+2 likha hai matlab..phir to as a text likha hoga ye..use no. Convert kriye then apply calculation
Itne ache ache video hone ke baad bhi aapke views itne kam kaise ho skte hein jabki baaki sabhi ke views lakhs me hote hein...it's not good
Thanks aapke valuable appreciation ke liye dear..ye to sahi keh rhe hain aap..Jadoo excel wale video hi audience ko jyada pasand aaye hain na ki in depth detail course..kaun itna dimag lagaye 😊😊😅
👍🏻👍🏻👍🏻
Thanks Ansh🙏❤️🙂
Dear sir.....
Mujhe last wala question me thoda doubt hai, because countif to criteria according count karta hai.. to isme kaise work karta hai.....??
Dear yahan bhi to criteria hi hai ki color usi value ko Karo Jo niche diye range me mil Jaye..hai na🙂❤️❤️🙏
@@Innozant okk sir.. Thank you 😍😍😘
Question no.3 Bina helper column ke karke batao sir😉
Puch rahe hain ya test le re hain wo bhi Mera..🙂Aayiye phir online live aur jitna query ho puchte jaiye🙏❤️
@@Innozant Are mai bas bolraha ho sir nazar mat hoiye aap...😊Aap ke videos dekh kar bhi bohot kuch shikhta ho sir mai. Thank you so much for your video.😊
@@razamoulvi8801 Raza Moulvi Sahab ..Mujhe to saalon me kabhi gussa aata hai,Narajgi kis baat ki wo bhi aapse,Mujhe acha lagta hai ap kai alag methid try karte hain..Checked your answer..Nice attempt with Indiex and small.Ye Question already interview cracker series me maine index se bataya hua ahi but yahan jo topic chal raha hai usko cover karna hota hai na dear..Thanks for watching and suporting.
Sir mis course krne ke bd highest kitna earn kr skte hai
It depends .. Skills and Organisation is the key factor to get highest salary
sir me mis report ki interview dene gyi thi unhonhe mere se question puche ki excel ki koi limitation hai and filter or vlookup me difference h sir inka answer batadijiye mera doobara se interview h 2 tarik ho plz
Offcourse limitation hai...Excel me jab hum large amount of data.par work karte hain to issue aate hain bht isiliye ETL tool power query ki jaroroorat hoti hai.
Aap btana ki sir excel me maximum rows 10 lac ke approx hai man lo mere paas 40 lac line item hai ti excel ke through process Krna possible nhi hoga na.
Rahi baat filter ki to uska kaam data extract karke lekenaana hai kisi bhi data set me se..aur vlookup ka perspective alag hai..aap google krke ek baar diffence based answer dekh lo
Best of luck Asha
thankyou so much sirrr 2 june ko mere phir se interview hai once again thankyou i wish me select ho jao bas
@@AshaKumari-lt7my Interview kaisa rha?
Maja a jata hain
Thanks Dear Salil
First question alag answer
=Index ($A$1:$A$13,rows(A1:$A$13)
Dont freeze rows first reference number A1
Very good attemt..Keep learning ❤️
@@Innozant Thank you so much sir.... I am learning more than my coaching centre from you ... ❤️❤️
1st Question answer without any Helper Coloum :-
=INDIRECT("A"&SUM(COUNTA($A$1:$A$14),COUNTBLANK($A$1:$A$14))-ROW(A1))
or
=INDIRECT("A"&SUM(COUNTA($A$1:$A$13),1)-ROW(A1))
How to freeze in firt question
Kaunse query me Priyanka..Freeze using F4 krenge dear
=INDIRECT("a"&ROW($A$14)-ROW(A1)) reverse order ........................
Good effort
Bhai Apna Email do , I will send a data set to you.
@innozantofficial telegram id
🙏