AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Bajaj Capital
Compare
Filter interviews by
Bajaj Capital MIS Executive Interview Questions and Answers
Bajaj Capital MIS Executive Interview Experiences
1 interview found
(2 Questions)
- Q1. Tell me about your self
- Q2. Tell me about your experience
(2 Questions)
- Q1. How to apply Vlookup
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Open Excel and select the cell where you want the result to appear
Type =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value is the value to search for
table_array is the range of cells containing the data
col_index_num is the column number in the table_array from which to ret...
- Q2. How to apply pivot
- Ans.
Pivot can be applied in Excel to summarize and reorganize data.
Select the data you want to pivot
Go to the 'Insert' tab and click on 'PivotTable'
Choose where you want the PivotTable to be placed
Drag and drop fields into the 'Rows', 'Columns', and 'Values' areas to organize the data
Apply filters and formatting as needed
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
MIS Executive Interview Questions & Answers
Radiant Cash Management Services
Anonymous
posted on 24 Apr 2023
Selected
I applied via Walk-in and was interviewed in Mar 2023. There were 4 interview rounds.
General maths, gk and English test and essay writing on any one topic of our choice to check English grammar.
(3 Questions)
- Q1. Excel test using formulas vlookup pivot table sumif and count if then conditional formatting
- Ans.
The question is about testing Excel skills using various formulas and tools.
VLOOKUP formula is used to search for a specific value in a table and return a corresponding value from another column.
Pivot tables are used to summarize and analyze large amounts of data.
SUMIF formula is used to add up values in a range that meet a certain criteria.
COUNTIF formula is used to count the number of cells in a range that meet a cer...
- Q2. Why did you leave your previous job?
- Q3. What was your in previous job in detail
(1 Question)
- Q1. Explain about yourself. Salary expectations. Are you able to commute to office location
Interview Preparation Tips
Practice some excel functions like vlookup and pivot
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed in Jun 2024. There were 3 interview rounds.
Logical thinking and mathematics MCQ
(3 Questions)
- Q1. What is SEBI and its use
- Ans.
SEBI stands for Securities and Exchange Board of India. It is the regulatory body for the securities market in India.
Regulates the securities market in India
Protects the interests of investors
Promotes fair and transparent dealings in the securities market
Regulates stock exchanges, brokers, and other intermediaries
Enforces rules and regulations to prevent fraudulent activities
Issues guidelines and regulations for compan
- Q2. Excel Shortcuts
- Q3. What do you think about mutual funds
- Ans.
Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of securities.
Mutual funds offer diversification by investing in a variety of securities such as stocks, bonds, and commodities.
They are managed by professional fund managers who make investment decisions on behalf of the investors.
Investors can choose from different types of mutual funds based on their ris...
(1 Question)
- Q1. Using Excel Shortcuts and give output
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. What is your name
- Q2. What is your profile
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.
(3 Questions)
- Q1. Experience total
- Q2. Expect from this job
- Q3. Capable for business?
- Ans.
Yes, I am capable for business with a strong background in finance and leadership skills.
Extensive experience in finance and business management
Proven track record of successful leadership and decision-making
Strong communication and negotiation skills
Ability to adapt to changing market conditions and drive growth
Examples: Successfully led a team to increase revenue by 20% in the last fiscal year
I applied via Company Website and was interviewed in Feb 2024. There was 1 interview round.
(2 Questions)
- Q1. What is your current CTC
- Q2. What is work experience
Ravi
(2 Questions)
- Q1. How can u make sell on daily basis
- Ans.
By identifying potential leads, building relationships, understanding customer needs, and offering solutions.
Identify potential leads through networking, cold calling, and referrals.
Build relationships with customers by providing excellent customer service and follow-up.
Understand customer needs by asking probing questions and actively listening.
Offer solutions that meet the customer's needs and provide value.
Follow up...
- Q2. How would you sell a pen to a person who is handicapped
- Ans.
I would highlight the ease of use and comfort of the pen for someone with limited mobility.
Emphasize the ergonomic design of the pen for comfortable grip
Highlight the smooth writing experience for effortless use
Demonstrate how the pen can be easily operated with one hand
(1 Question)
- Q1. Technincal role, other knowledge and subject expert
(1 Question)
- Q1. Technical role, other knowledge and subject expert
Interview Preparation Tips
Senior Executive Interview Questions & Answers
Motilal Oswal Financial Services
Anonymous
posted on 27 Jul 2022
I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.
(1 Question)
- Q1. Financial knowledge / stock market basics
(1 Question)
- Q1. Your goals and your way of thinking
Interview Preparation Tips
Executive Accountant Interview Questions & Answers
Northern Trust Operating Services
Anonymous
posted on 10 Jun 2021
I applied via Company Website and was interviewed in May 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Accounting related
- Q2. Taxation related
Interview Preparation Tips
Bajaj Capital Interview FAQs
Tell us how to improve this page.
Bajaj Capital Interviews By Designations
- Bajaj Capital Relationship Manager Interview Questions
- Bajaj Capital Wealth Manager Interview Questions
- Bajaj Capital Client Relationship Officer Interview Questions
- Bajaj Capital Intern Interview Questions
- Bajaj Capital Relationship Executive Interview Questions
- Bajaj Capital Senior Client Relationship Officer Interview Questions
- Bajaj Capital Insurance Adviser Interview Questions
- Bajaj Capital Marketing Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior MIS Executive Interview Questions
- MIS Executive and Analyst Interview Questions
- MIS Executive and Coordinator Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- MIS and Back Office Executive Interview Questions
- Executive Accountant Interview Questions
- Show more
Bajaj Capital MIS Executive Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Bajaj Capital MIS Executive Reviews and Ratings
based on 4 reviews
Rating in categories
|
Relationship Manager
370
salaries
|  ₹2.4 L/yr - ₹6.2 L/yr |
|
Sales Executive
124
salaries
| ₹1.1 L/yr - ₹3.6 L/yr |
|
Senior Relationship Manager
123
salaries
| ₹4 L/yr - ₹8.5 L/yr |
|
Assistant Manager
98
salaries
| ₹2 L/yr - ₹8 L/yr |
|
Wealth Manager
90
salaries
| ₹3 L/yr - ₹9 L/yr |
HDFC Securities
Kotak Securities
ICICI Securities
Sharekhan
- Home >
- Interviews >
- Bajaj Capital Interview Questions >
- Bajaj Capital MIS Executive Interview Questions
