Crack Jobs #61 | MIS & Data Analytics Excel Interview Questions and Answers

MIS & Data Analytics Excel Interview Questions and Answers
MIS Interview Cracker Playlist Link-drive.google.c...
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...
#innozant #excelinterviewquestions #excelinterviewquestionsandanswers #innozantchannel #innozant channel

[@indermohan24]

गुरुजी आप सच में धन्य हैं। आपके द्वारा दी गई Excel Training के कारण मैं FMCG MNC में जॉब कर रहा हूं 🙏

[@Innozant]

Wow... Congratulations Inder Mohan..Party😁? aap to mere live class student rahe hain..God bless you dear.Have a wonderful career ahead

[@Altaf_Alam]

​@@Innozantsir live class free hai kya ?

[@indermohan24]

@@Innozant ❤️

[@Rajxixix0108]

Mujhe SQL seekhna hai. Please suggest kaise aur knha se sekhu

[@prishakumari2020]

@@Altaf_Alam youtube par valuable content free hai live class paid courses hai

[@Altaf_Alam]

Sir assignment answer 😊
=Countif(a1:a4,">0")-count(find(".",a1:a4)) thanks a ton sir ji 😀. Aapke hi wajah se mai itna logic apply kar pata hu..... Really you teach us in a unique way 😊👍

[@ShivChoudharysingerguitarist]

thanks buddy

[@Altaf_Alam]

@@ShivChoudharysingerguitarist it's ok buddy 🙂

[@amitmangal4332]

Agar 2 decimal values hogi to ye formula applicable nahi hoga....Use if(mode)

[@yashpal810]

thanks bhai....

[@bhupendrabhati6999]

​@@amitmangal4332bhai decimal value 1 ho ya 4 sb m work karga

[@rameshchandragoyal4494]

Dear sir
really you are great sir by all means, thanks for teaching in very nice way.
Assignment answer giving, hope, its in order
=Countif(a1:p1,">0")-Count(If(Mod(a1:p1,1)>0,1)) Cntr+Shft+Entr
GOYAL

[@virendrahardiya2797]

बहुत ही superb लगा sir, यदि जिस तरह का इंटरव्यू रियल्टी में होते हैं वैसे ट्रेनिंग देते रहेंगे तो बहुत ही बढ़िया रहेगा।

[@Innozant]

👍❤️

[@ashishsah274]

by the look of it the two columns are already highlighted that contain decimal, well =SUMPRODUCT(--(D4:S4>0))-2 its easy

[@sujaysharma6335]

Sir I did the assessment with sumproduct and used integer function
Sumproduct(--(range>0)*(range=int(range))

[@Innozant]

Good..kindly share solution with all students

[@manojkumarsingh3385]

Sir Aap ki ending note Dil me junun paida kar Deti hai🙏🙏🙏

[@Innozant]

Thanks Manoj Ji

[@Ann_2208]

Sir course buy karna badi bat nhi but job par lagne ke bad jo real time data ko analysis krna hota hai toh uss situation me ap ya apki team support kregi jise ki humari bhi job save rahe

[@RahulYadav-ut4ig]

Ye baat bhai sahi hai

[@Innozant]

Conceptual knowledge dena humara farj hai use real time implement karna aapka,Haan koi issue aaya hai usse bahar niklane me conceptual help Dena Banta hai lekin professional queries solve karna possible nhi ho sakta hai..

[@Altaf_Alam]

​@@Innozantsir would you please make a video on different types of data of different companies.... 😊

[@createyour6681]

Very greatest video sir

[@situsahoo2482]

Bahut aacha laga sir ❤

[@amandev7371]

Solution for the assignment
=COUNTIF(D4:S4,">0")-COUNT(IF(MOD(D4:S4,1)=0,"",1))

[@vanistajames346]

You always keep inspiring me with your amazing and useful videos!! Thank you so much sir 😊😊. Keep up the great work!!

[@Innozant]

Thanks Vanisha..Keep Learning..God bless you

[@Taj-12]

Getting #Value, Can you help on this why am getting #value even though formula is correct

[@shivshankarkumar7446]

Assesment 1 solution: =COUNTIFS(D4:S4,">0")-COUNT(FILTER(D4:S4, ISNUMBER(D4:S4), D4:S4 ROUND(D4:S4, 0)))

[@Innozant]

👍❤️

[@indian2030]

Thank u excel master😊

[@playwithdata_03]

Sir SQL Playlist bhi launch kijiye.

[@Innozant]

Soon

[@PixelPioneerX132]

With Sumproduct: =SUMPRODUCT((D4:S7>0)*(D4:S7=INT(D4:S7)))

[@omkarchimbalkar5912]

Excellent

[@Innozant]

Thanks

[@abhishekukm]

Sumproduct((d4:s4>0)*not(isnumber(search(".",d4:s4)))) answer of assignment 😅

[@Altaf_Alam]

One more 😊 =Countif(a1:a4,">0")-count(find(".",a1:a4))

[@vishaltamta6504]

=SUMPRODUCT(--(D4:S4>0), --(D4:S4=INT(D4:S4)))
Sir Assignment Answer

[@Innozant]

👍❤️

[@user-vf5ty5ix9o]

This is a very nice solution using sumproduct

[@subhamshaw1944]

Thank you sir ...

[@gargibharadwaj3311]

Wonderful sir❤

[@Innozant]

Thanks Gargi

[@shrikantbadge3978]

Thank you sir

[@Mu00lia]

Good presenter. Contents also rich. Enamul@Bangladesh

[@Innozant]

Thanks Murad .Keep learning ❤️

[@NILESHKUMAR-oq9kc]

Sir job nhi lgg rha...ek v company m resume shortlist horha

[@vasimshaikh5833]

Sir value added video 😍✌️💯 🎉

[@Innozant]

Thanks Vasim Ji

[@SumitSingh-pn1cu]

Sir, apki video se kaafi kuch sikh liya hai pur job nhi lag rahi hai. As a fresher koi company lene ko tayar nhi hai they need experience. Please give any solution

[@Innozant]

LinkedIn par connection banayen..ache aur genuine call mil jaate h

[@K-Starreaction]

Superb sir

[@laiquekhan10415]

Amazing

[@RahulRoy-po9ct]

🙏GURU JI🙏

[@aryanjangid4771]

Hello sir..sir just a small request..please add this in MIS interview resources drive..

[@Innozant]

Already added h dear

[@satender7625]

❤️

[@riteshkumar-qy3ly]

SIR AAPKI NEW ASHOK NAGAR DELHI MI OFFLINE CLASSES HAI KYA

[@prishakumari2020]

yes offline classes available at new ashok nagar

[@Innozant]

Yes dear 👍❤️

[@riteshkumar-qy3ly]

Sirrr bass ek baar apko live dekhna hai basss

[@dominatorgaming2980]

Liked without watching because I know what kind of videos you make

[@Innozant]

Really means a lot to me..God bless you

[@shakuntalakumari8460]

Of course it's ur trust@Mr Dominator...but also learn from the video content.. that will be more beneficial.😊

[@arjunspata1913]

👍 sir

[@MIS_PRODUCTION_AAA]

Just killer

[@Innozant]

Thanks a lot

[@situsahoo2482]

❤❤

[@prajwalshetty2047]

❤😂👍🇮🇳🙏

[@muhammadajmal6887]

Thanks ❤