Aspect Ratio Interview Questions, Process, and Tips

Q1. You are from mechanical tell me how refrigerator and ac works
Add your answer
Q2. Milk:water ratio ques
Add your answer
Q3. Probability of making triangle by dividing a stick into 3 parts
Add your answer
Q4. Write a python code for the same (if stick has been divided into 1000 parts)
Add your answer
Q5. Shown me a sheet and asked for top customers calculate the frequency of the customer
Add your answer

Online quantitative aptitude test and logical reasoning

Written quantitative aptitude test you have to explain the calculation

Q1. In 50 litres mixture of milk and water, the ratio of milk and water is 3 ∶ 2. How much water should be added to get the ratio of milk and water will be 2 ∶ 3?
Ans. 
To change the ratio of milk and water from 3:2 to 2:3, water needs to be added to the mixture.
• Calculate the current quantities of milk and water in the mixture based on the given ratio.

• Determine the total quantity of the mixture before adding water.

• Set up an equation to find the amount of water needed to achieve the desired ratio.

• Solve the equation to find the amount of water to be added.
Answered by AI
Add your answer
Q2. There are three cities A, B and C, not on the same straight road. Two buses P and Q start simultaneously from A and B respectively towards C. By the time Q reaches C, P is exactly halfway to C. Immediately...read more
Ans. 
Q would take 5 hours to cover the distance from C to A.
• Calculate the distance between A and B using the given information.

• Use the ratio of speeds of P and Q to find their individual speeds.

• Calculate the time taken by P to cover the distance from A to B.

• Use the time taken by P to find the time taken by Q to cover the distance from C to A.
Answered by AI
Add your answer

Q1. Business case study and DSA related questions
Add your answer

Aptitude round, be quick

Q1. Interviewer went through my resume and asked me to introduce and basic OOP question and 2 puzzles( torch and bridge puzzle) and asked a basic coding question
Add your answer

Online, easy to moderate level aptitude questions

Written aptitude, moderate level, have to give calculation

Q1. Puzzle, case study, gestimates
Add your answer
Q2. Aptitude, linear programming, series question
Add your answer

Q1. Countif sumif in excel
Ans. 
Countif and Sumif are Excel functions used to count or sum values based on specified criteria.
• Countif function counts the number of cells within a range that meet a certain condition.

• Sumif function adds up the values in a range that meet a certain condition.

• Both functions require a range of cells and a criteria to be met.

• Example: =COUNTIF(A1:A10, ">10") will count the number of cells in range A1:A10 that are greater th
Answered by AI
Add your answer
Q2. Distinct count and joins in sql
Ans. 
Distinct count is used to count unique values in a column, while joins are used to combine data from multiple tables in SQL.
• Distinct count is achieved using the COUNT(DISTINCT column_name) function.

• Joins are used to combine data from two or more tables based on a related column between them.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Answered by AI
Add your answer

Profit maximization using lpp.
Market sizing for ev 2 wheelers for next 5 years
Future cash flows