PERSOLKELLY Interview Questions, Process, and Tips

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 is index+match
Ans. 
Index+match is a combination of Excel functions used to lookup a value in a table based on row and column criteria.
• Index function returns the value of a cell in a table based on the row and column number provided

• Match function returns the position of a value in a range

• Index+match is commonly used instead of Vlookup for more flexibility and accuracy

• Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the value ...read more
Answered by AI
Add your answer

Q1. Asking about previous experiences
Add your answer
Q2. How handle the situation
Add your answer

Q1. Asking About Salary discussion
Add your answer

Q1. How do you paginate responses in SQL?
Ans. 
Use OFFSET and FETCH clauses in SQL to paginate responses.
• Use OFFSET to skip a specified number of rows before returning the remaining rows.

• Use FETCH to limit the number of rows returned after the OFFSET clause.

• Example: SELECT * FROM table_name ORDER BY column_name OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
Answered by AI
Add your answer

Q1. Work experience related questions
Add your answer
Q2. Just to check communication
Add your answer

I agree to community guidelines nalland terms to used.....

Q1. What is the difference between azure and AWS?
Ans. 
Azure and AWS are cloud computing platforms with similar services, but differ in pricing, scalability, and integration.
• Azure is more tightly integrated with Microsoft products, while AWS has a wider range of third-party integrations.

• AWS has a larger market share and more mature services, while Azure is catching up quickly.

• Azure offers more flexible pricing options, while AWS has a more complex pricing structure.

• Azure h...read more
Answered by AI
Add your answer
Q2. What is the uses of aws and azure?
Ans. 
AWS and Azure are cloud computing platforms used for hosting, managing and deploying applications and services.
• AWS provides a wide range of services including compute, storage, database, analytics, machine learning, and more.

• Azure offers similar services as AWS but also has a strong focus on integration with Microsoft technologies.

• Both platforms offer scalability, flexibility, and cost-effectiveness for businesses of a...read more
Answered by AI
Add your answer

Q1. About Your experience
Add your answer

Q1. Eligibility criteria for job role
Add your answer

Q1. Laptop Familiar or not
Add your answer

Basic excel test was done

Q1. More about personality and morals , chance of job shift, future planning etc
Add your answer