A3logics Interview Questions and Answers

Q1. What is vlookup?
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• VLOOKUP stands for 'vertical lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. What do you know about us health care?
Add your answer

Q1. What is the difference between vlookup and index match?
Ans. 
VLOOKUP searches for a value in the first column of a range and returns a value in the same row. INDEX MATCH is more flexible and can search in any column.
• VLOOKUP searches vertically in a table and returns a value from the same row.

• INDEX MATCH can search horizontally or vertically and is more versatile.

• VLOOKUP requires the lookup value to be in the first column of the table.

• INDEX MATCH can search for the lookup value i...read more
Answered by AI
Add your answer
Q2. Us health care domain specific questions?
Add your answer

Q1. Questions on commitment towards the company, general team behaviour and typical scenario based questions to test your emotional intelligence?
Add your answer
Q2. Sallery discussion
Add your answer

Q1. The recruiter called me in at noon the day after I applied for the role, my resume got shortlisted and the recruiter talked to me for about 19 minutes during which she asked my family background and after ...read more
Add your answer

This round was 25 minutes exactly the technical interviewee asked me only 2 to 3 theoretical questions and after that, he told me to share my screen and then started asking me coding problems which consisted of 5 questions purely on code, no theory.
q1- exception handling question of (10/0--> solve this using try catch)
q2-write a class that return the area and perimeter of the rectangle
q3-remove duplicate elements from list of the set (remove_duplicates[(1,2,2,3,4,4,5]))
q4-calculate the sum of the string (sum_of_digits(1234) #output will be 10)

Q1. Tell me about your experience
Ans. 
I have over 5 years of experience in customer support roles, handling various inquiries and providing solutions.
• Managed customer inquiries through phone, email, and chat

• Resolved customer complaints and issues in a timely manner

• Trained new team members on customer support processes

• Utilized CRM software to track customer interactions

• Implemented strategies to improve customer satisfaction ratings
Answered by AI
Add your answer
Q2. How do you manage if client escalated on you ?
Ans. 
Stay calm, listen actively, empathize, apologize if necessary, offer solutions, escalate if needed.
• Remain calm and composed

• Listen actively to understand the client's concerns

• Empathize with the client's situation

• Apologize if necessary, even if it's not your fault

• Offer solutions or alternatives to address the issue

• Escalate to a supervisor or higher authority if the situation requires it
Answered by AI
Add your answer

Q1. Core concepts on for the language you are giving interview
Ans. 
Core concepts of programming languages include syntax, semantics, data types, control structures, and object-oriented principles.
• Syntax: The set of rules that defines the combinations of symbols that are considered to be correctly structured programs. Example: In Python, indentation is crucial.

• Semantics: The meaning behind the syntactical elements. Example: In Java, 'int a = 5;' means 'a' is an integer variable assigne...read more
Answered by AI
Add your answer
Q2. Detailed questions from resume
Add your answer

Q1. Basic to medium complexity coding question
Add your answer
Q2. Check culture fit
Add your answer

Q1. General questions like about family, native place & salary discussion
Add your answer