i
Bajaj Auto
Filter interviews by
Clear (1)
I applied via Naukri.com and was interviewed in Oct 2021. There were 5 interview rounds.
Excel online test
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...
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,...
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.
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...
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
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...
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
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.
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.
Do well preparation and we'll knowledge of company where you going to atten interview
Top trending discussions
I was interviewed in Jul 2017.
I was interviewed in Jun 2017.
I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.
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
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...
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
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
I applied via Walk-in and was interviewed before Sep 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed before Dec 2020. There were 3 interview rounds.
I applied via Walk-in and was interviewed before Dec 2020. There was 1 interview round.
I applied via Referral and was interviewed before Sep 2017. There were 2 interview rounds.
I applied via Campus Placement
Some of the top questions asked at the Bajaj Auto Office Assistant interview -
based on 4 reviews
Rating in categories
Line Engineer
1.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
798
salaries
| ₹0 L/yr - ₹0 L/yr |
Company Trainee
579
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
421
salaries
| ₹0 L/yr - ₹0 L/yr |
Diploma Trainee Engineer
356
salaries
| ₹0 L/yr - ₹0 L/yr |
Hero MotoCorp
TVS Motor
Mahindra & Mahindra
Maruti Suzuki