Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Bajaj Auto Team. If you also belong to the team, you can get access from here

Bajaj Auto Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Bajaj Auto Office Assistant Interview Questions, Process, and Tips

Updated 28 Apr 2022

Bajaj Auto Office Assistant Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Oct 2021. There were 5 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 - Aptitude Test 

Excel online test

Round 3 - One-on-one 

(9 Questions)

  • Q1. Market share of motorcycle in North Zone viz Delhi, Haryana, Rajasthan, Punjab, Chandigarh, Jammu and Kashmir
  • Ans. 

    The market share of motorcycles in the North Zone, including Delhi, Haryana, Rajasthan, Punjab, Chandigarh, Jammu and Kashmir, is influenced by various factors such as brand popularity, pricing, and customer preferences.

    • Market share can vary based on the popularity of different motorcycle brands in the region.

    • Pricing plays a crucial role in determining market share, as affordability is a key factor for customers.

    • Custom...

  • Answered by AI
  • Q2. VLOOKUP and HLOOKUP formula in excel
  • Ans. 

    VLOOKUP and HLOOKUP are Excel formulas used to search for specific data in a table and retrieve corresponding values.

    • VLOOKUP searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.

    • HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a specified row.

    • Both formulas are useful for data analysis, organizing information,...

  • Answered by AI
  • Q3. Pivoy table use in excel and objects
  • Ans. 

    Pivot tables are used in Excel to summarize and analyze large amounts of data.

    • Pivot tables allow you to group and summarize data based on different criteria.

    • They can be used to create charts and graphs to visualize data.

    • Pivot table objects can be customized with different formatting options.

    • Examples of pivot table use include analyzing sales data, tracking expenses, and summarizing survey results.

  • Answered by AI
  • Q4. Demonstration of Pivot table use process and what is significant to use pivot table.
  • Ans. 

    Pivot tables are used to summarize and analyze large data sets. They allow for easy filtering and sorting of data.

    • Select the data range to be analyzed

    • Insert a pivot table and choose the desired fields to be included

    • Use filters and sorting to analyze the data

    • Pivot tables are significant because they allow for quick and easy analysis of large data sets

    • They can be used to identify trends and patterns in the data

    • For exampl...

  • Answered by AI
  • Q5. Data validation use in excel
  • Ans. 

    Data validation in Excel ensures accuracy and consistency of data entered into cells.

    • Data validation restricts input to a specific range or list of values.

    • It can also be used to ensure data is entered in a specific format, such as a date or phone number.

    • Error alerts can be set up to notify users when invalid data is entered.

    • Examples include setting up a drop-down list for selecting options or limiting the number of cha

  • Answered by AI
  • Q6. Data validation use process demonstration in excel and explain how can we use data validation.
  • Ans. 

    Data validation in Excel ensures accuracy and consistency of data. It can be used to restrict input and prevent errors.

    • Data validation is used to set rules for data entry in Excel.

    • It can be used to restrict input to a certain range of values or a specific list.

    • Data validation can also be used to prevent duplicate entries or invalid data.

    • For example, you can use data validation to ensure that a date entered in a cell is...

  • Answered by AI
  • Q7. How can see double entry in excel
  • Ans. 

    Double entry in Excel can be seen by using formulas and functions to ensure that all data is accurately recorded in two or more places.

    • Use formulas to calculate and record data in multiple cells

    • Use functions like SUM, AVERAGE, and COUNT to ensure accuracy

    • Check for consistency between different sheets or workbooks

    • Use conditional formatting to highlight discrepancies

    • Double check all entries to ensure accuracy

  • Answered by AI
  • Q8. Use conditional formatting to find duplicate values.
  • Ans. 

    Conditional formatting can be used to find duplicate values in a range of cells.

    • Select the range of cells where you want to find duplicates.

    • Click on 'Conditional Formatting' in the 'Home' tab.

    • Choose 'Highlight Cells Rules' and then 'Duplicate Values'.

    • Select the formatting style you want to apply to the duplicates.

    • Click 'OK' to apply the formatting and find the duplicates.

  • Answered by AI
  • Q9. Count how many entey in excel sheet.
  • Ans. 

    Count the number of entries in an Excel sheet.

    • Open the Excel sheet and navigate to the desired column or range of cells.

    • Use the COUNT or COUNTA function to count the number of non-empty cells.

    • Alternatively, use the COUNTIF function to count cells that meet specific criteria.

    • Ensure that you include all relevant rows and columns in the count.

    • The result will be the total number of entries in the Excel sheet.

  • Answered by AI
Round 4 - Case Study 

Do well preparation and we'll knowledge of company where you going to atten interview

Round 5 - One-on-one 

(1 Question)

  • Q1. Why you want to leave your company
  • Ans. Everyone want to find good opportunity
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Do interview with full confidence

Skills evaluated in this interview

Interview questions from similar companies

I was interviewed in Jul 2017.

Interview Questionnaire 

1 Question

  • Q1. My skills

Interview Preparation Tips

Round: Resume Shortlist
Experience: My qualification experience and knowledge
Tips: Qc knowledge heavy whical maintenance experience

Round: Test
Experience: Technical questions
Tips: Technically
Duration: 1 hour
Total Questions: 30

Round: HR Interview
Experience: Check my skills
Tips: Skills test

Skills: Industrial Quality Control

I was interviewed in Jun 2017.

Interview Preparation Tips

Round: Resume Shortlist
Experience: it was very optimistic.
Tips: always be positive


I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Ready to work in team and learn new skills
  • Ans. Yes I for sure I would love to work in this environment and learn new skills
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Good they were very polite and help me to interact.

Interview Questionnaire 

4 Questions

  • Q1. Tell us something about your self, summer inetrnship, family etc. ?
  • Ans. 

    I am a hardworking individual with a passion for learning and growth. I completed a summer internship in marketing and come from a supportive family.

    • I am a hardworking individual

    • Passionate about learning and growth

    • Completed a summer internship in marketing

    • Come from a supportive family

  • Answered by AI
  • Q2. Demonstrate how will you retain an employee at your dealer's?
  • Ans. 

    To retain an employee, I will focus on creating a positive work environment and offering opportunities for growth and development.

    • Offer competitive salaries and benefits

    • Provide opportunities for training and development

    • Create a positive work culture with open communication and recognition

    • Offer flexible work arrangements

    • Provide opportunities for career advancement within the company

    • Regularly check in with employees to a...

  • Answered by AI
  • Q3. Are you comfortable with working in different city and travelling?
  • Ans. 

    Yes, I am comfortable with working in different cities and travelling.

    • I have previous experience working in different cities and travelling for work.

    • I am adaptable and can quickly adjust to new environments.

    • I enjoy exploring new places and meeting new people.

    • I understand the importance of being flexible and available for work-related travel.

    • I am willing to make necessary arrangements to ensure smooth travel and work ex

  • Answered by AI
  • Q4. Why did you enter the GD late?
  • Ans. 

    I apologize for being late. I had an emergency that I had to attend to.

    • I had an unexpected emergency that required my immediate attention

    • I made sure to inform the organizers as soon as I could

    • I understand the importance of punctuality and will ensure it in the future

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Its a simple test to check your people skills, your personality and whether you are capable to handle difficult situations
Tips: Its very simple, no need to worry abt it. Everyone clears this one.

Round: Group Discussion
Experience: The GD took place on 12th feb and so the topic was very recent. Everybody had  abundant data and thus plenty of points to make. It was a well structured GD, 10 minutes to discuss and 5 minutes to individually conclude the topic. I made my first point pretty late which was a wrong thing to do as I was asked about this in my interview. Later on I was successful to put 3-4 distinct points and as I was 8th amongst 10 ppl I could structure my conclusion well.
Tips: 1. Please read about the recent topics in newspaper.2.Numbers aren't important they don't make much difference. 3. If you are  applying for marketing/sales job be presentable, improve your diction and grammar. 4.Make distinct points.
Duration: 15 minutes

Round: HR Interview
Experience: The HRs were very calm and poised, they gave me enough time to frame my answers. Overall it was a pleasant experience.
Tips: Be yourself and show that you need this job. Show that you come from a family which is supportive and that you are flexible when it comes to location.

College Name: KJ SOMAIYA INSTITUTE OF MANAGEMENT STUDIES AND RESEARCH

I applied via Walk-in and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What did you know about gst ? Have you ever work in excel and tally ? What is gst what is the difference between cgst and sgst ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident to ur interviewer in ur comfortable language. And don't hesitate to share ur past experiences. Be loyal by sharing ur knowledge, talent and experiences. And don't disappoint infront of them if u get rejection or any nagative comments.

I applied via Recruitment Consultant and was interviewed before Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What improvements you did in your last company ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Wear formal dress, shaving should be done.

I applied via Walk-in and was interviewed before Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About my career my highest qualification about my skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Over all good experience with interveiw

I applied via Referral and was interviewed before Sep 2017. There were 2 interview rounds.

Interview Preparation Tips

Round: Offer letter
Experience: I got confirmation from HR at December, but they gave letter in march month, day by day I have to call them and follow for the offer letter, They gave offer letter after 3 months, but ask me to join within one month.

General Tips: Please dont prefer to work in Mahindra and dont spoil your carrier.
Duration: 1-3 Months

I applied via Campus Placement

Interview Preparation Tips

Round: Group Discussion
Experience: Almost the entire group went off topic confusing commercialisation with privatisation. Inspite of HR manager's intervention regarding misinterpretation , group continued with privatisation.
Tips: Technical firms are not expecting high level of GD & communication skills (except when the profile demands so) . You are expected to atleast be able to keep your view point with some logical support.
If you are able to raise 2-3 points in a polite way , you are highly likely to be selected.
If the GD you are appearing is for a profile like marketing , sales or where end to end interaction matters much , u need to be highly skillfull at your communication.

Skill Tips: You must be able to relate your text book knowledge with the practical world. Focus on the applications of whatever you study.
Skills: Design Engineering, Team Leader, Team Player
College Name: NIT Jalandhar
Contribute & help others!
anonymous
You can choose to be anonymous

Bajaj Auto Interview FAQs

How many rounds are there in Bajaj Auto Office Assistant interview?
Bajaj Auto interview process usually has 5 rounds. The most common rounds in the Bajaj Auto interview process are One-on-one Round, Resume Shortlist and Aptitude Test.
What are the top questions asked in Bajaj Auto Office Assistant interview?

Some of the top questions asked at the Bajaj Auto Office Assistant interview -

  1. Market share of motorcycle in North Zone viz Delhi, Haryana, Rajasthan, Punjab,...read more
  2. Demonstration of Pivot table use process and what is significant to use pivot ...read more
  3. Data validation use process demonstration in excel and explain how can we use d...read more

Recently Viewed

INTERVIEWS

Bajaj Auto

100 top interview questions

REVIEWS

Nexa

No Reviews

REVIEWS

Bajaj Auto

No Reviews

INTERVIEWS

Nexa

No Interviews

INTERVIEWS

Nexa

No Interviews

INTERVIEWS

Nexa

No Interviews

REVIEWS

Nexa

No Reviews

REVIEWS

Ford Motor

No Reviews

SALARIES

Nexa

INTERVIEWS

Nexa

10 top interview questions

Tell us how to improve this page.

Interview Questions from Similar Companies

Tata Motors Interview Questions
4.2
 • 999 Interviews
Maruti Suzuki Interview Questions
4.2
 • 586 Interviews
Hero MotoCorp Interview Questions
4.1
 • 334 Interviews
TVS Motor Interview Questions
4.0
 • 313 Interviews
Ashok Leyland Interview Questions
4.1
 • 239 Interviews
Royal Enfield Interview Questions
4.2
 • 152 Interviews
Ford Motor Interview Questions
4.4
 • 145 Interviews
View all
Bajaj Auto Office Assistant Salary
based on 11 salaries
₹1 L/yr - ₹3 L/yr
17% less than the average Office Assistant Salary in India
View more details

Bajaj Auto Office Assistant Reviews and Ratings

based on 4 reviews

4.8/5

Rating in categories

4.8

Skill development

4.7

Work-life balance

4.8

Salary

4.6

Job security

4.9

Company culture

4.6

Promotions

4.8

Work satisfaction

Explore 4 Reviews and Ratings
Line Engineer
1.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
798 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Company Trainee
579 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
421 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Diploma Trainee Engineer
356 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Bajaj Auto with

Hero MotoCorp

4.1
Compare

TVS Motor

4.0
Compare

Mahindra & Mahindra

4.1
Compare

Maruti Suzuki

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