AmPstek Interview Questions and Answers

Array formula is used to perform calculations on multiple items in an array, while Range formula is used to perform calculations on a range of cells.

• Array formula can handle multiple values at once, while Range formula operates on a range of cells.

• Array formula is enclosed in curly braces { }, while Range formula does not require this.

• Array formula can be used to perform complex calculations across multiple cells, while Range formula is more limited in scope.

A centrifugal pump works on the principle of converting rotational kinetic energy into hydrodynamic energy to move fluid through the pump.

• Rotating impeller creates centrifugal force to push fluid outward

• Fluid enters pump through the center and is accelerated by the impeller

• Centrifugal force increases fluid velocity and pressure, forcing it out through the discharge

• Commonly used in water treatment plants, HVAC systems, and industrial applications

A filter press works on the principle of pressure filtration to separate solids from liquids.

• Filter press consists of a series of chambers containing filter plates with filter cloths.

• Slurry is pumped into the chambers and the solids are retained on the filter cloths while the liquid passes through.

• Pressure is applied to the slurry to force the liquid out, leaving behind a cake of solids.

• The cake can then be removed and disposed of, while the filtered liquid is collected for f...read more

Google Sheets is a web-based spreadsheet program offered by Google as part of its office suite.

• Web-based spreadsheet program

• Part of Google's office suite

• Allows for collaboration in real-time

• Can import/export Excel files

• Offers various functions and formulas

• Can be accessed from any device with internet connection

I plan to get organized by creating a detailed procurement plan and utilizing project management tools.

• Create a detailed procurement plan outlining all necessary steps and timelines

• Utilize project management tools such as Trello or Asana to track progress and deadlines

• Regularly communicate with stakeholders to ensure alignment and adjust plan as needed

• Establish clear procurement policies and procedures to ensure consistency and efficiency

Google Forms is a free tool provided by Google for creating online surveys and quizzes.

• Allows users to create custom forms with various question types

• Responses are automatically collected and organized in a Google Sheets spreadsheet

• Can be shared with others via a link or email invitation