Tata Tele Business Services MIS Executive Interview Questions and Answers for Experienced

The microprocessor 8085 has a total of 40 output pins.

• The microprocessor 8085 is an 8-bit microprocessor.

• It has a total of 40 pins, which are used for various purposes.

• These pins include address bus pins, data bus pins, control pins, and power supply pins.

• Some of the output pins are used for sending signals to external devices or peripherals.

• Examples of output pins in the microprocessor 8085 include the RD (Read) pin a

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.