AU Small Finance Bank Operations Executive Interview Questions and Answers

Use VLOOKUP function to lookup data from one sheet to another within a file.

• Use VLOOKUP function in the cell where you want the data to appear

• Specify the lookup value, table array, column index number, and range lookup in the VLOOKUP function

• For example, =VLOOKUP(A2, Sheet2!A1:B10, 2, FALSE) will lookup the value in cell A2 in Sheet2 and return the corresponding value from the second column

• Ensure that the lookup value ...read more

To draw a pivot in Excel, use the shortcut key Alt + D + P.

• Press Alt + D to open the Data tab in Excel.

• Then press P to open the PivotTable dialog box.

• Select the range of data you want to use for the pivot table and choose where you want the pivot table to be placed.

• Click OK to create the pivot table.

To remove text from a given case no., use string manipulation techniques.

• Use string functions like substring or replace to remove text from the case no.

• Identify the specific text to be removed and use the appropriate function to eliminate it.

• Ensure that the remaining case no. is still valid and accurate after removing the text.