Sopra Steria Interview Questions and Answers

Formulas in MS Excel are used to perform calculations and manipulate data.

• Formulas in Excel start with an equal sign (=)

• Common formulas include SUM, AVERAGE, IF, VLOOKUP, and CONCATENATE

• Formulas can be used to perform mathematical operations, logical comparisons, and text manipulation

• Excel also supports custom formulas created using functions and operators

2 stock and 4 stock are types of engines used in motorcycles.

• 2 stock engines have a power stroke every two strokes of the piston, while 4 stock engines have a power stroke every four strokes.

• 2 stock engines are simpler and lighter, but less fuel efficient and produce more emissions compared to 4 stock engines.

• Examples of motorcycles with 2 stock engines include older models like Yamaha RD350, while examples of motorcycles with 4 stock engines include modern bikes like Honda C...read more

Least count of an instrument refers to the smallest measurement that can be made with the instrument.

• Least count is determined by the smallest division on the scale of the instrument.

• It is important to consider the least count when taking measurements to ensure accuracy.

• For example, a ruler with millimeter divisions has a least count of 1 mm.

• Another example is a digital caliper with a least count of 0.01 mm.

TMT stands for Thermo-Mechanical Treatment, a process used to improve the mechanical properties of materials.

• TMT involves subjecting a material to both thermal and mechanical processes to enhance its strength and toughness.

• This process is commonly used in the manufacturing of steel bars for construction purposes.

• TMT helps in reducing the carbon content in steel while increasing its strength and ductility.

NPK in fertilizer stands for Nitrogen, Phosphorus, and Potassium - essential nutrients for plant growth.

• N - Nitrogen: Promotes leafy growth and overall plant health

• P - Phosphorus: Supports root development and flower/fruit production

• K - Potassium: Aids in disease resistance and overall plant vigor

• Example: A fertilizer with an NPK ratio of 10-10-10 contains equal parts of Nitrogen, Phosphorus, and Potassium.