Canam Consultants Business Support Executive Interview Questions and Answers

Q1. Name 5 MS Excel Formula
Ans. 
Some common MS Excel formulas include SUM, VLOOKUP, IF, CONCATENATE, and AVERAGE.
• SUM: Adds up all the numbers in a range of cells

• VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from another column

• IF: Checks whether a condition is met and returns one value if true and another if false

• CONCATENATE: Joins two or more text strings into one string

• AVERAGE: Calculates the averag
Answered by AI
Add your answer
Q2. Define STAR approach
Ans. 
STAR approach is a method used to structure responses in interviews, focusing on Situation, Task, Action, and Result.
• Situation - Describe the context or background of a specific event or challenge.

• Task - Explain the specific task or goal that needed to be accomplished.

• Action - Detail the actions you took to address the task or challenge.

• Result - Share the outcomes or results of your actions, including any lessons learn...read more
Answered by AI
Add your answer

Q1. Why is there a gap from previous Organisation
Add your answer

Q1. Tell me about yourself
Add your answer

Aptitude test with situations based questions

Q1. About past experience,Case studies
Add your answer

Psychometric test conducted before interview with HR.

Q1. With HR and then finally with the MD
Add your answer

Q1. Past exp, academic exp, alignment with what I wanted to do
Add your answer

This round was more on the conversation skills

The coding round had some let code problems on SQL and Python

Q1. Why planning to change to this industry
Ans. 
I am passionate about the industry and believe my skills and experience align well with the opportunities it offers.
• Passion for the industry and desire to make a positive impact

• Alignment of skills and experience with the industry's needs

• Excitement about the growth potential and opportunities in the industry
Answered by AI
Add your answer
Q2. Tell me about your team leading experiance
Ans. 
I have over 5 years of team leading experience in retail and hospitality industries.
• Managed a team of 15 employees in a busy restaurant, delegating tasks and ensuring smooth operations

• Provided training and support to new team members to ensure they were able to perform their roles effectively

• Implemented new procedures to improve efficiency and customer satisfaction

• Handled scheduling, performance evaluations, and confli
Answered by AI
Add your answer

Q1. Same as above q1
Add your answer
Q2. Same as above q2
Add your answer

Q1. Basic Questions based on pervious project
Add your answer

Q1. Practical questions regarding database like sp,trigger,rank
Add your answer
Q2. Difference b/w sp and function
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are blocks of code that can be called within SQL queries.
• Stored procedures are stored in the database and can be called using a specific name.

• Functions are defined using CREATE FUNCTION and can be called within SQL queries.

• Stored procedures can have input and output parameters, while functions can only return a single value.

• Stored pro...read more
Answered by AI
Add your answer

Q1. Salary negotiations
Add your answer