Everest Industries Interview Questions and Answers

VLOOKUP and XLOOKUP are Excel functions used to search for a value in a table and return a corresponding value.

• VLOOKUP stands for 'Vertical Lookup' and searches for a value in the first column of a table and returns a value in the same row from a specified column.

• XLOOKUP is a newer function that can search both vertically and horizontally in a table and has more flexibility in its syntax.

• VLOOKUP requires the lookup value to be in the first column of the table, while XLOOKUP a...read more

To create a pivot table in MS Excel, go to the 'Insert' tab, click on 'PivotTable', select the data range, choose where to place the pivot table, and drag fields into the rows, columns, and values areas.

• Go to the 'Insert' tab in Excel.

• Click on 'PivotTable'.

• Select the data range you want to analyze.

• Choose where you want to place the pivot table (new worksheet or existing worksheet).

• Drag and drop fields into the rows, columns, and values areas to customize the pivot table.

• You c...read more

I am a dedicated and detail-oriented engineer with strengths in problem-solving, communication, teamwork, adaptability, and technical skills.

• Problem-solving: Successfully resolved a complex technical issue by analyzing data and implementing a creative solution.

• Communication: Effectively communicated project updates and requirements to team members and stakeholders.

• Teamwork: Collaborated with cross-functional teams to achieve project milestones and deliverables.

• Adaptability: Q...read more

A compressor is a mechanical device that increases the pressure of a gas by reducing its volume.

• Compressors are used in various applications such as air conditioning, refrigeration, and gas turbines.

• They work by drawing in low-pressure gas and then compressing it to a higher pressure.

• Compressors can be classified into positive displacement and dynamic types.

• Positive displacement compressors use a piston or a rotating mechanism to compress the gas.

• Dynamic compressors use high-...read more

General procurement process involves identifying needs, selecting suppliers, negotiating terms, and managing contracts.

• Identify the need for the material

• Research potential suppliers

• Request for quotations or proposals

• Negotiate terms and pricing

• Select the supplier

• Create a purchase order

• Receive and inspect the material

• Pay the supplier