Hankook tire Interview Questions and Answers

Q1. Which function is used to calculate weighted product
Ans. 
The function used to calculate weighted product is the SUMPRODUCT function.
• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.
Answered by AI
Add your answer
Q2. What can we use to summarize the data
Ans. 
Data can be summarized using various methods such as charts, graphs, tables, and statistical measures.
• Charts: Visual representation of data like bar charts, pie charts, line graphs.

• Graphs: Representing data points and relationships between them.

• Tables: Organizing data in rows and columns for easy comparison.

• Statistical measures: Calculating averages, medians, standard deviations, etc.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated MIS executive with a strong background in data analysis and reporting.
• Experienced in managing databases and generating reports for decision-making

• Proficient in data visualization tools such as Tableau and Power BI

• Skilled in identifying trends and patterns in data to improve business processes
Answered by AI
Add your answer
Q2. Questions related to Hobbies
Add your answer

Q1. Countif, countifs, sumif, sumifs
Add your answer
Q2. Question related to vlookup
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why should we recruit you
Add your answer
Q3. What is your strength
Add your answer
Q4. What is your weakness
Add your answer
Q5. Tell about your previous experience
Add your answer

Given 20 question and 1 hr time

Q1. Do you know about SAP
Ans. 
Yes, SAP is a widely used enterprise resource planning software.
• SAP is an ERP software used by companies to manage business operations.

• It helps in streamlining processes such as accounting, sales, HR, and inventory management.

• Knowledge of SAP can be beneficial for customer service representatives to assist customers with inquiries related to orders, invoices, and product availability.
Answered by AI
Add your answer
Q2. How would you rate yourself for excel
Add your answer
Q3. What is indexing in excel
Ans. 
Indexing in Excel refers to the process of organizing data in a spreadsheet to make it easier to search and retrieve information.
• Indexing allows users to quickly locate specific data within a large dataset.

• It involves creating a reference point for each row or column in the spreadsheet.

• Users can use the index to navigate to a specific location in the spreadsheet without scrolling through all the data.

• Indexing can impro...read more
Answered by AI
Add your answer

Q1. Tell me about yourself, portfolio walk through
Ans. 
I am a passionate graphic designer with a strong eye for detail and a love for creating visually appealing designs.
• I have a Bachelor's degree in Graphic Design from XYZ University.

• I have 5 years of experience working as a graphic designer at ABC Company.

• I specialize in branding, logo design, and digital illustrations.

• I will walk you through my portfolio showcasing a variety of projects I have worked on, including brand...read more
Answered by AI
Add your answer

Q1. Find the Employee who has made most number of sales
Add your answer

Q1. What is the work of lifo and fifo
Ans. 
LIFO (Last In, First Out) and FIFO (First In, First Out) are inventory management methods used to track the flow of goods in a store.
• LIFO method assumes that the last items added to inventory are the first ones sold or used.

• FIFO method assumes that the first items added to inventory are the first ones sold or used.

• LIFO is often used in situations where prices are rising, as it can result in lower taxable income.

• FIFO is...read more
Answered by AI
Add your answer

Q1. Geographical knowledge specially for North America region
Add your answer
Q2. 1. US City Airport codes. 2. International route from US or to US. 3. Ticketing Commands. 4. Itinerary Commands.
Ans. 
The candidate is asked about US City Airport codes, international routes to/from the US, ticketing commands, and itinerary commands.
• US City Airport codes include JFK (New York), LAX (Los Angeles), ORD (Chicago), ATL (Atlanta), etc.

• International routes from the US include JFK to LHR (London Heathrow), LAX to NRT (Tokyo Narita), ORD to CDG (Paris Charles de Gaulle), etc.

• Ticketing commands may include issuing tickets, cha...read more
Answered by AI
Add your answer

Q1. Active Directory Configuration and it’s uses
Ans. 
Active Directory is a directory service used by Windows networks to store information about users, computers, and resources.
• Centralized management of network resources

• Authentication and authorization of users and computers

• Group policy management for security and configuration settings

• Single sign-on for users to access multiple resources

• Integration with other Microsoft services like Exchange Server and SharePoint
Answered by AI
Add your answer
Q2. What is domain controller
Ans. 
A domain controller is a server that manages network security, authentication, and access control for a domain.
• Manages user authentication and authorization within a domain

• Stores user account information and security policies

• Controls access to network resources

• Replicates data and changes to other domain controllers in the network

• Examples: Active Directory Domain Services (AD DS) in Windows Server
Answered by AI
Add your answer
Q3. User cases and how would you solve it
Add your answer

Q1. Details about Statistics knowledge
Add your answer

Q1. Asked about previous job experience
Add your answer

Q1. Salary discussion and reasons for leaving previous company
Add your answer

Q1. Tell me about your self nd what was your 1st job salary, why was u leaving and many more..
Add your answer
Q2. Many more questions about your self, your carrier,your family,and last one is is your ambition
Add your answer

Q1. Why we hire you,what is your ambition what's your Last package,what are u expecting here,
Add your answer