Cresce Technology Private Limited Interview Questions, Process, and Tips

Q1. What is filter formula
Ans. 
A filter formula is a formula used to specify criteria for filtering data in a spreadsheet or database.
• Filter formulas are used to extract specific data from a larger dataset based on certain conditions.

• They can be used in various applications such as Excel, Google Sheets, and SQL databases.

• Filter formulas typically involve logical operators (e.g., equals, greater than, less than) and functions (e.g., COUNTIF, SUMIF) t...read more
Answered by AI
Add your answer
Q2. What is use sumif formula
Ans. 
SUMIF is a formula in Excel used to calculate the sum of values in a range based on specified criteria.
• SUMIF formula is used to add up values in a range that meet a given condition.

• It takes three arguments: range, criteria, and sum_range.

• The range is the set of cells to be evaluated, criteria defines the condition, and sum_range is the range to be summed.

• For example, =SUMIF(A1:A10, ">5", B1:B10) will sum the values in ...read more
Answered by AI
Add your answer
Q3. What is xlookup formula
Ans. 
XLOOKUP is a formula in Excel that allows you to search for a value in a range and return a corresponding value from another range.
• XLOOKUP is a powerful alternative to VLOOKUP and HLOOKUP formulas.

• It can perform both vertical and horizontal lookups.

• XLOOKUP can search for values in multiple columns or rows.

• It can handle both exact and approximate matches.

• XLOOKUP supports wildcard characters and can handle errors more ef...read more
Answered by AI
Add your answer
Q4. What is if function
Ans. 
The IF function is a logical function in Excel that allows you to perform different actions based on a specified condition.
• The IF function checks if a condition is true or false and returns different values or performs different actions accordingly.

• It has three arguments: the condition to be tested, the value to be returned if the condition is true, and the value to be returned if the condition is false.

• Example: =IF(A1...read more
Answered by AI
Add your answer

Overall 12 question

Q1. Department head discussion
Add your answer

Analytics team discussion

Q1. Explain your achievements
Ans. 
I have achieved significant growth in revenue, implemented successful cost-saving initiatives, and led successful mergers and acquisitions.
• Increased revenue by 30% through strategic marketing campaigns

• Implemented cost-saving measures that resulted in a 15% reduction in expenses

• Successfully led the acquisition of a competitor, expanding market share
Answered by AI
Add your answer
Q2. How do you see yourself contributing to this org
Ans. 
I see myself contributing by leveraging my experience in strategic planning, team leadership, and fostering a culture of innovation.
• Developing and implementing strategic plans to drive growth and profitability

• Leading and motivating teams to achieve organizational goals

• Promoting a culture of innovation and continuous improvement

• Building strong relationships with stakeholders and fostering collaboration

• Identifying and ca...read more
Answered by AI
Add your answer

Nonsense aptitude. No valid questions

Q1. Interview will be taken by non departmental employees. Like sales interview will be done by admin person
Add your answer
Q2. Non sales. They think if you are smart you can not accomodate in culture
Add your answer

Q1. Again done by some random guy
Add your answer
Q2. Irrelevant questions
Add your answer
Q3. Rapid fire without resume
Add your answer

Q1. General Questions
Add your answer
Q2. Detail about my work
Add your answer
Q3. Details about sales
Add your answer
Q4. Details about resume
Add your answer

Q1. General Questions
Add your answer