Colgate Global Business Services Senior Analyst Interview Questions and Answers

The aptitude round was easy consisting of three sections

The second aptitude test was conducted by the HR of the company.

Q1. Behaviour based questions
Add your answer
Q2. Situation based questions
Add your answer
Q3. Aptitude based questions
Add your answer

Q1. Highlight the odd cells in excel
Ans. 
Use conditional formatting to highlight odd cells in Excel
• Select the range of cells you want to highlight

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose 'New Rule' and select 'Use a formula to determine which cells to format'

• Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

• Choose the formatting style you want for the odd cells
Answered by AI
Add your answer
Q2. What are Joins in SQL, explain different joins and their outputs
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q3. Query to give running sum of salary
Ans. 
Use window function to calculate running sum of salary in SQL
• Use window function like SUM() with OVER() clause

• Partition the data by employee ID if needed

• Order the data by date or any other relevant column
Answered by AI
Add your answer

Its a sectional round. It has 4 sections. Quants, Logical, pseudo code, Reasoning, Gaming

Q1. Aptitude question solving
Add your answer
Q2. Resume related questions
Add your answer

Q1. Oops concept explain in short
Ans. 
Oops concept is a programming paradigm that uses objects and classes to design applications.
• Oops stands for Object-Oriented Programming

• It focuses on creating objects that interact with each other to accomplish tasks

• Encapsulation, inheritance, and polymorphism are key principles of Oops

• Example: Creating a class 'Car' with properties like 'color' and methods like 'drive'
Answered by AI
Add your answer

Q1. Ctc current ? And expect ctc to join
Ans. 
Current CTC is $80,000 and expecting $90,000 to join.
• Current CTC: $80,000

• Expected CTC to join: $90,000
Answered by AI
Add your answer

Q1. Joining date and notice period if
Add your answer

Easy qstns with java and sql

Coding qstn based on your perferred language