RBL Bank MIS Executive Interview Questions and Answers

Yes, vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• 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) - searches for the val...read more

Yes, pivot tables are used in Excel to summarize and analyze data.

• Pivot tables are used to summarize large amounts of data in Excel.

• They allow users to reorganize and summarize selected columns and rows of data.

• Users can easily create different views of the data by dragging and dropping fields.

• Pivot tables can also perform calculations and display results in a clear and organized manner.

• For example, you can use a pivot...read more

The famous place near my city is the historic Old Town Square.

• Old Town Square is located in the heart of the city and is known for its stunning architecture.

• It is home to the famous Astronomical Clock, which attracts tourists from all over the world.

• The square is surrounded by beautiful buildings, including the Church of Our Lady before Týn and the Old Town Hall.

• There are also many cafes, restaurants, and shops in the ...read more