Royal Finserv Junior Data Analyst Interview Questions and Answers for Experienced

Credit note is issued to reduce the amount payable by a customer, while debit note is issued to increase the amount payable by a customer.

• Credit note is issued when a customer has been overcharged or returned goods, resulting in a reduction of the amount owed.

• Debit note is issued when a customer has been undercharged or additional goods/services have been provided, resulting in an increase of the amount owed.

• Credit not...read more

Macros are used to automate repetitive tasks in Excel, saving time and reducing errors.

• Automate repetitive tasks in Excel

• Save time by reducing manual work

• Reduce errors by eliminating human input

Index and match are used in Excel to look up values in a table based on specific criteria.

• Index and match are used together to perform a vertical lookup in Excel.

• Index returns the value of a cell in a table based on the row and column numbers provided.

• Match is used to find the position of a value in a range of cells.

• Index and match are often used instead of VLOOKUP when dealing with large datasets or when the lookup va