Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Ascent Business Solutions MIS Executive Interview Questions and Answers

Updated 5 Aug 2021

Ascent Business Solutions MIS Executive Interview Experiences

2 interviews found

I applied via Company Website and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Asking for basic Excel Question, Advanced Excel Question(V lookup, H lookup, etc.)

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident during interview, If You have knowledge other technologies add in your CV

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 13 May 2021

Interview Questionnaire 

2 Questions

  • Q1. Why did we prefer you?
  • Q2. How much time you get to resolve the problem about task?
  • Ans. 

    The time I get to resolve a task problem depends on the severity of the issue and the resources available.

    • The severity of the issue determines the priority level and the time frame for resolution.

    • The resources available, such as technology and personnel, also impact the time frame.

    • Communication with stakeholders and team members is crucial to ensure timely resolution.

    • Regular progress updates and status reports help man...

  • Answered by AI

MIS Executive Interview Questions Asked at Other Companies

Q1. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU W ... read more
Q2. Excel function explain Pivot table. Vlookup.hole look-up.xlook-up ... read more
asked in HCLTech
Q3. What is the advantages of Data validation and why we use it?
Q4. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

Interview questions from similar companies

I appeared for an interview in Jun 2017.

Interview Questionnaire 

6 Questions

  • Q1. Tell me what about your self
  • Ans. 

    I am a dedicated and detail-oriented MIS Executive with strong analytical skills and a passion for problem-solving.

    • Experienced in data analysis and reporting using various MIS tools

    • Proficient in Excel, SQL, and other data management software

    • Strong communication skills for presenting findings and recommendations

    • Ability to work under pressure and meet deadlines

    • Proven track record of improving operational efficiency throu

  • Answered by AI
  • Q2. How many years you have experienced this role
  • Ans. 

    I have 5 years of experience in the MIS Executive role.

    • I have worked as an MIS Executive for 5 years.

    • During my tenure, I have successfully managed data analysis and reporting tasks.

    • I have expertise in using various MIS tools and software.

    • I have implemented efficient data management systems to streamline processes.

    • I have collaborated with cross-functional teams to gather and analyze data for decision-making.

    • I have provi...

  • Answered by AI
  • Q3. What's is end of your studying
  • Q4. Why are you break your study after latest completed
  • Ans. 

    I took a break from my studies after completing my latest degree to gain practical experience and explore career opportunities.

    • To gain practical experience and apply the knowledge acquired during my studies

    • To explore career opportunities and find the right path for my professional growth

    • To develop additional skills and broaden my knowledge beyond academics

    • To take a break and recharge before pursuing further education o...

  • Answered by AI
  • Q5. Testing in Microsoft Excel
  • Ans. 

    Testing in Microsoft Excel involves verifying the functionality, accuracy, and reliability of formulas, macros, data validation, and other features.

    • Test formulas by inputting different values and checking the calculated results.

    • Verify the accuracy of macros by running them and comparing the expected outcomes.

    • Test data validation rules by entering valid and invalid data to ensure proper validation.

    • Check the reliability ...

  • Answered by AI
  • Q6. Write to any vba programmes
  • Ans. 

    I have experience in writing VBA programs.

    • I have written VBA programs for automating tasks in Excel.

    • I am proficient in using VBA to manipulate data and create macros.

    • I have used VBA to develop custom functions and user forms.

    • I have experience in debugging and troubleshooting VBA code.

    • I am familiar with VBA programming best practices and coding standards.

  • Answered by AI

Interview Preparation Tips

Round: Manager Round
Experience: Overall is OK, but you don't have a lot of experience in VBA. We want to atleast maximum 2 years experience in VBA with Microsoft Advance Excel.
So the management was rejected my interview.

Skills: VBA, Microsoft Excel Skills

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. What is Pivot table and how its work
  • Ans. 

    A Pivot table is a data summarization tool used in spreadsheet programs. It allows you to quickly summarize and analyze large amounts of data.

    • Pivot tables are used to summarize and analyze large amounts of data

    • They allow you to quickly create reports and analyze data in different ways

    • You can use them to group data by different categories and calculate totals and averages

    • Pivot tables are easy to use and can save you a l

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - without using formula we can get the summarize record

I applied via Recruitment Consultant and was interviewed in May 2020. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. How to create reports by pivot table?
  • Ans. 

    Pivot tables are used to create reports by summarizing and analyzing data.

    • Select the data range that you want to analyze

    • Go to the 'Insert' tab and click on 'PivotTable'

    • Choose the location where you want to place the pivot table

    • Drag and drop the fields you want to analyze into the 'Rows' and 'Columns' areas

    • Add any additional fields to the 'Values' area to calculate summaries

    • Customize the pivot table by applying filters,...

  • Answered by AI
  • Q2. What is the advantages of Data validation and why we use it?
  • Ans. 

    Data validation ensures accuracy and completeness of data. It helps in preventing errors and improving data quality.

    • Data validation ensures that the data entered is accurate and complete.

    • It helps in preventing errors and improving data quality.

    • It ensures that the data is consistent and conforms to predefined standards.

    • It helps in identifying and correcting errors before they cause problems.

    • Examples of data validation i...

  • Answered by AI
  • Q3. How advance filter works?
  • Ans. 

    Advance filter is a feature that allows users to apply complex criteria to filter data in a more precise way.

    • Advance filter allows users to filter data based on multiple criteria.

    • It provides options to filter data using logical operators such as AND, OR, and NOT.

    • Users can filter data based on specific values, text, dates, or even formulas.

    • Advance filter can be used in various applications like spreadsheets, databases, ...

  • Answered by AI
  • Q4. Some Formulas like Vlookup Index Match and others
  • Q5. Conditional Formatting

Interview Preparation Tips

Interview preparation tips for other job seekers - MIS profile is based on reporting profile job in this profile you do data analysis and create reports based on management requirements. Every company have their own requirements so for best candidate for this profile you must have good knowledge of Excel and you must have some skill of data analysis. So keep work hard and learn many things of Excel as much you can and do hard work untill you get a offer letter in your hand
...

I applied via Naukri.com and was interviewed in May 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Assignment 

Excel test

Interview Preparation Tips

Interview preparation tips for other job seekers - Formulas and preparing templets and interact with client

I applied via Naukri.com and was interviewed in Mar 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Assignment 

Ms excel

Interview Preparation Tips

Interview preparation tips for other job seekers - Vlookup,hlookup,povit table, formal,conditional formating sum sumif sumifs countif
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Good , not n== bad

Round 2 - HR 

(5 Questions)

  • Q1. About salary , college life , projects , family
  • Q2. Self and college
  • Q3. About college , life , food ,
  • Q4. Company , life ,project
  • Q5. About night sift
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Prev ofz experience
  • Ans. 

    I have 3 years of experience as a MIS Executive in a multinational company.

    • Managed databases to ensure accurate and timely reporting

    • Developed automated reports using Excel and SQL

    • Collaborated with cross-functional teams to analyze data and improve processes

  • Answered by AI

I applied via Company Website and was interviewed in Jan 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

18/2/2022

Round 2 - Technical 

(2 Questions)

  • Q1. Accounts side questions
  • Q2. Degree base questions

Interview Preparation Tips

Interview preparation tips for other job seekers - I have knowledge in execl and computer
Contribute & help others!
anonymous
You can choose to be anonymous

Ascent Business Solutions Interview FAQs

What are the top questions asked in Ascent Business Solutions MIS Executive interview?

Some of the top questions asked at the Ascent Business Solutions MIS Executive interview -

  1. How much time you get to resolve the problem about ta...read more
  2. Asking for basic Excel Question, Advanced Excel Question(V lookup, H lookup, et...read more

Recently Viewed

JOBS

TCS

No Jobs

INTERVIEWS

Ascent Business Solutions

5.6k top interview questions

SALARIES

Ascent Business Solutions

SALARIES

TCS

SALARIES

Aerial Telecom Solutions

SALARIES

Ascent Business Solutions

SALARIES

Ascent Business Solutions

INTERVIEWS

TCS

5.6k top interview questions

SALARIES

Ascent Business Solutions

SALARIES

TCS

Tell us how to improve this page.

MIS Executive Interview Questions from Similar Companies

View all
Ascent Business Solutions MIS Executive Salary
based on 17 salaries
₹1.4 L/yr - ₹3.1 L/yr
28% less than the average MIS Executive Salary in India
View more details

Ascent Business Solutions MIS Executive Reviews and Ratings

based on 2 reviews

4.2/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

3.0

Salary

4.8

Job security

4.2

Company culture

4.2

Promotions

4.2

Work satisfaction

Explore 2 Reviews and Ratings
Senior Executive
209 salaries
unlock blur

₹1.7 L/yr - ₹6 L/yr

Executive
124 salaries
unlock blur

₹1 L/yr - ₹4.5 L/yr

Executive Assistant
104 salaries
unlock blur

₹1 L/yr - ₹3.6 L/yr

Team Lead
82 salaries
unlock blur

₹4.4 L/yr - ₹9.6 L/yr

Senior Associate
70 salaries
unlock blur

₹2.8 L/yr - ₹5.8 L/yr

Explore more salaries
Compare Ascent Business Solutions with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview