Bharti Airtel MIS Executive Interview Questions and Answers

To compile a database using VBA, use arrays of strings.

• Create an array to store the data

• Use loops to populate the array with data from the database

• Use VBA functions to manipulate the data as needed

Nested if with loop in VBA

• Nested if statements are used to check multiple conditions

• Loops are used to repeat a set of instructions

• Combining both can help in complex decision-making processes

• Example: If a student's grade is above 90, check if they have completed all assignments using a loop

The question is asking for a VBA code to filter data and create a new workbook.

• Use the Autofilter method to filter data based on specific criteria.

• Create a new workbook using the Workbooks.Add method.

• Copy the filtered data to the new workbook using the Copy method.

• Save the new workbook using the SaveAs method.