Aspect Ratio Associate Consultant Interview Questions and Answers

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