Top 5 MIS Executive Interview Questions & Answers in Hindi | MIS Interview Cracker | Excel Tips

Подписаться 153 тыс.

Просмотров 62 тыс.

50% 1

Top 5 MIS Executive Interview Questions & Answers in Hindi | MIS Interview Cracker | Excel Tips
About Video
Namaskar Dosto is video mai aapko bataya gaya hai ki mis interview mai poochne jane wale questions and answers utne hard nahi hote but aapko apne dimag ka use karna hai aur aap kisi bhi mis executive interview ko easily crack kar sakte hai agar aap mis post ke liye freshers hai to bhi ye top 5 mis interview questions and answers ki video aapki help karegi interview ko crack karne mai aur sathi hi sath ye excel ki tips aapko jaroor pasend aayegi
Top 5 MIS Interview Questions & Answers Practice File
docs.google.co...
Follow me
👇
Instagram id:- / abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Video Related link
👇
Top 5 Logical Formula
• Top 5 Most Powerful Fo...
Top 5 Mouse and excel tricks
• 99% लोग नहीं जानते इस ...
Create Dynamic Border
• How To Add Automatic B...
Pivot Table Lesson 1
• Excel Pivot Table In H...
Top 5 Value
• Large Formula तीन Form...
Mis Interview Series 1
• MIS Interview Question...
Data Validation
• Part 2 | अब Excel खुद ...
If Formula
• Top 5 Most Powerful Fo...
Vlookup Formula
• अक्सर (MIS पोस्ट के लि...
How to create Custom Formatting For your table
• Excel Table Tutorial 2...
Top 26 Excel Shortcut keys with Alt Key
• Top 26 Excel Shortcut ...
Top 5 Amazing Secrets In excel
• Top 5 Amazing Excel Se...
Mind Blowing Excel Tricks Part 1
• #Shorts | How To Creat...
Excel A to Z Shortcuts Key with Ctrl Key
• #Shorts | A TO Z EXCEL...
Full Print Setting Tutorial
• Excel Page Setup and P...
Excel Lesson For Beginners
👇
Excel Formatting
• Learn Fast Formatting ...
Excel Lesson for Beginners
• Microsoft Excel Tutori...
Excel lesson 1
• Video
Excel Lesson 2
• Video
Top 5 typing tips
👇
• Top 5 Typing Technique...
All the images & back ground music use in this video only for education purpose and all credit goes to owner
Disclaimer:--
Note: Copyright Disclaimer Under Section 107 of the Copyright Act 1976 allowance is made for "fair use" for purposes such as criticism comment news reporting teaching scholar ship and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use....
Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai
#top5misexecutiveinterview
#misinterviewquestionsandanswers
#abhijeetjitechnical4m

Опубликовано:

15 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 86

@pradeepdubey1592 2 года назад

Really great dear abhijeet, liking your every such short tricks videos. Keep doing so, not missing any of your video.

@AbhijeetjiTechnical4M 2 года назад

Thnks

@abhirupsen765 8 дней назад

Your videos are very helpful

@driptachatterjee3167 Год назад

Need more videos like this. Very easy way of explaining.

@AbhijeetjiTechnical4M Год назад

Go to mis interview playlist lots of video available

@suryapratapSingh-fs7rl Год назад

F9 Daab dia..jee baat mere sher..Thank you for this video bro...

@gouravsaini9857 Год назад

Thanks for the information, Sir. Just one concern on problem number 2, If there are any tens number before three adjacent Zeros in any row, this formula will consider that tens number's Zero as a seperate Zero number. And in that case our results will be inaccurate. For example, If cell G9 has value as 40 or 60 in it, the formula into cell O9 will return the Id number from cell E9 and that would not be correct. So, anyone can avoid this error by replacing formula into cell O9 with the below: =IFERROR(IF(SEARCH("_0_0_0_0",CONCATENATE("_",TEXTJOIN("_",TRUE,F9:N9))),E9,""),"") Please correct me if I'm wrong. Thanks!

@AbhijeetjiTechnical4M Год назад

Yes you are right dear but always we create formula as per our requirement but here not any single value available like what are you saying above if available then need to right formula as per given =if(isnumber(search(“1111”,textjoin(,true,if(d3:j3=0,1,d3:j3)))),c3,””) I solved this query with array mastery this is our powerful concept not any single video available upon it using array concept you can fix any query if you are intrested to learn let me inform

@manjit.sarania Год назад

Very good trick and tips sir ji

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

great video ...lekin practice set ka link nehinkhul raha hain ...chack kariye ekbar

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

Practice sheet not available by mistake deleted

@pankulbaijal7542 Год назад

Good questions elaboration very nice .. I have a question for you related to your last question is that suppose 1st name has 11 Len count and if every alphabet has a random number from 1 to 26 like A to Z and we want take out the output in the manner of all the character sum like example -- R(7), A(2), M(18) and if we write RAM in a cell then we want the output 7+2+18=27 .... Same as like for any name we write in a cell then automatically it sums up number according to the character and give the output..

@AbhijeetjiTechnical4M Год назад

Yes it can be done using vlookup function with mid function,row & indirect function I have written R in cell “h7”,A in “H8” & M in h9 cell and also mentioned value against each cell in next column i.e i7,i8 & i9 (7,2,18) I have type ram f12 and now I am going to put formula in g12 like that =sum(vlookup(mid(f12,row(indirect(“1:”&len(f12))),1),h7:i9,2,0) Press enter now your result is which you are expecting

@pankulbaijal7542 Год назад

@@AbhijeetjiTechnical4M thanks abhijeet ji for answering my question really appreciate it but i dont know am I using or putting something wrong that answer is coming 7.. One more important thing that RAM name is written in one cell like A-1 B-2 C-3 D-4 Like this every alphabet has its own number till Z and if I wrote a name in cell then according to their number name has its sums up in the cell as you already understand very well RAM name in a one cell SHYAM name in a different cell and any other name etc.. By putting your method I am getting 7 as output which is not what I want, I need 7+2+18=27 .. In case of any clarification please write.. Thanks once again and waiting for your reply. 🙏

@AbhijeetjiTechnical4M Год назад

@@pankulbaijal7542go to our instagram account and you will get my number and connect me

@naimkhan7309 2 года назад

Ab samjhate to bahot accha hai but thoda zoom karke bataya kare to hame clear dikhai bhi dega

@AbhijeetjiTechnical4M 2 года назад

Ok don't forget to share

@KhanKhan-iu3we 2 года назад

Excellent sir ,sir please mis ke important topics pe videos bhi baniaye

@rishavupadhyay420 3 месяца назад

Grt video

@nayaklive6834 Год назад

Bahat khub ji....

@Hafiz_Ibrahim Год назад

Really helpful 👍 Thanks

@mohdumarkhan7361 2 года назад

Very helpful video

@harshitgehalot4682 Год назад

Bhaiji itna bda formula lgane se accha countif() function ka use Karo

@AbhijeetjiTechnical4M Год назад

Mere bhai nahi Aayega result try kar lena

@harshitgehalot4682 Год назад

Mera agya

@harshitgehalot4682 Год назад

Result

@AbhijeetjiTechnical4M Год назад

@@harshitgehalot4682 koi dusre question ka aaya hoga mein question ke bare mein socha tha Tumne question no mentioned nahi kiya tha

@vishaltanwar8318 2 года назад

Nice explanation Sir 👌

@AbhijeetjiTechnical4M 2 года назад

Thnks

@vikramchauhan5823 2 года назад

Amazing ✌👌👌👍👍👍

@simranrawat4413 3 месяца назад

Sir please send the practice file. In my pc that link is not working

@AbhijeetjiTechnical4M 3 месяца назад

Practice sheet has been deleted sorry for inconvenience

@rajeshgupta2218 2 года назад

Sir Koi Aisa Tarika Batao Ki Jub Me Kisi Column Me Number Enter Karoon To Number Bada Hone Par Column Automatically Width Bada Na Kare Aur Maine Us Column Ko Text Me Bhi Nahi Badalna Hai

@djduxmodinagar293 Год назад

Bhai sheet pr ja kr autofit kar do ho jayega

@arunkumars928 Год назад

Can anyone share the practice file In discription box that link it's showing file was deleted

@radheyshyamindia 3 месяца назад

Sir freez keliye keya daba na hey

@AbhijeetjiTechnical4M 3 месяца назад

F4 key

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

Hlookup bhi to lag sakta hai bhai answer please

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

Yes

@vikas261196 4 месяца назад

So as I understood you intentionally deleted the practice sheet because you want to force people to purchase your course, but you didn't delete the video because you are earning revenue from youtube. There's nothing wrong in earning by selling your course but this practice of luring viewers is very unethical. Otherwise this tutorial is good

@animalsworld-mb5xd 4 месяца назад

Practice file is not able to open could you fixed it

@AbhijeetjiTechnical4M 4 месяца назад

Practice file has been lost sorry for inconvenience

@Contentking- 5 месяцев назад

Practice file is not working kindly look into the matter...

@AbhijeetjiTechnical4M 5 месяцев назад

By mistake it has been lost Sorry for inconvenience

@Agent-f3g 3 месяца назад

❤

@brahmakumaris999 Год назад

very good video , thank you for making these :) .

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

Practice file is not available

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

The practical file is not there. it has been deleted.

@simranparveen4102 2 года назад

Last cell lock ku ni kiya ni kya first question m

@irfanfulari2122 Год назад

Sheet deleted ? it shows page not fund, file deleted. please provide sheet.

@AbhijeetjiTechnical4M Год назад

Message me on insta I will provide there

@samadhanchavan3586 Год назад

The sheet is not open ,please resend link of sheet

@pratapkeshavpawar9689 8 месяцев назад

🕉️🙏🇮🇳Bro images are unable to read understand like black ants please 🙏 do needful

@sumitkumar89909 2 года назад

Please share excel sheet for practice

@AbhijeetjiTechnical4M 2 года назад

Link In description box If not given let me inform I will share at morning

@sumitkumar89909 2 года назад

@@AbhijeetjiTechnical4M yes there is sheet tnx

@arunkumars928 Год назад

Can you share the practice file In discription box that link showing data not found

@bazzelrahman5879 7 месяцев назад

Sumproduct ka formula work kese kar Raha hai? Yeh samjh nhi aa rha.

@AbhijeetjiTechnical4M 7 месяцев назад

Watch again and keep practice Otherwise you can join our course where you will get personal support and everything you will learn in depth

@darshanapawar399 5 месяцев назад

file is not found can you reupload it..

@AbhijeetjiTechnical4M 5 месяцев назад

File misplaced sry we can’t

@tanmayhero 2 месяца назад

Difference between "AND" and "&"

@AbhijeetjiTechnical4M 2 месяца назад

And is logical formula This & used to joined two text

@kapilrajput4193 Год назад

sir , wahase practice file delete ho gayi hai....

@AbhijeetjiTechnical4M Год назад

Ok I will upload

@darshanpatel4625 Год назад

ha nhi dikh rahi

@anamaypatil8804 8 месяцев назад

spreadsheet isn't available

@AbhijeetjiTechnical4M 8 месяцев назад

Change the setting of video quality

@amarjeet_A_Dreamer 5 месяцев назад

Text join function is missing in this

@AbhijeetjiTechnical4M 5 месяцев назад

Excel has lots of tricks to get output

@harshitgehalot4682 Год назад

Attendence sheet may ek individual present aur absent nikalne ka liye 😂😂

@kingoflucknow3481 Год назад

thanks

@mukeshwaliya4444 Год назад

bro please sheet upload ka do

@CHANDRAPALsingh-tl1yq Год назад

Reverse wala jo ap ne bataya hai wo sucess nhi ho rha hai

@AbhijeetjiTechnical4M Год назад

Kya Samasya aa Rahi message me on instagram if you want to boost your carrier then join our basic to advance excel with array mastery ,not any single video available on excel array mastery if you learn array mastery you can fix your query by itself and crack any interview all the thing you will learn in just rs 699 if Intrsted let me know

@PragatiGola-e7n 4 месяца назад

file is deleted from drive please share it.

@AbhijeetjiTechnical4M 4 месяца назад

File has been lost sorry for inconvenience

@AshrafKhan-kv9ey Год назад

File is deleted.. please share the file link

@AbhijeetjiTechnical4M Год назад

Ok I will upload again

@roshanchavan-e5g 10 месяцев назад

bro lpractical ink is expired

@AbhijeetjiTechnical4M 10 месяцев назад

Message me on Instagram

@susmitabhattacharjee2832 2 года назад

Sumproduct formula not working

@AbhijeetjiTechnical4M 2 года назад

It will work watch carefully then apply still u r facing problem message me on instagram

@siddharthgehlot 10 месяцев назад

Itna to coaching mey sikhaya hi nahi 🙄🙂Fresher se itna pochagey Vo

@AbhijeetjiTechnical4M 10 месяцев назад

Yes pochega company apne work ke according poochega Aur depend karta hai Aapka kaha interview de rahe hain ache company mein Jaroor poochega Agar company based work per course sikhna hai then join our course download app and join App name - abhijeetji technical 4m