Which options are available in Automation Anywhere to activate a sheet in Excel?

In Automation Anywhere, both the options to activate a sheet in Excel by Index and by Name are indeed available, which makes the first choice the correct one.

Activating a sheet by Index allows users to reference the position of the sheet within the workbook, which is useful when the specific name of a sheet is not known or when the order of the sheets is relevant. For example, if the desired sheet is the third one in a workbook, you can simply use the index number 3.

On the other hand, activating a sheet by Name provides a more explicit and descriptive way to reference a sheet, ensuring you get the exact sheet you need, regardless of its position in the workbook. This method is often more user-friendly, as it directly correlates with the sheet's label, which is particularly helpful in workbooks with many sheets.

The other options do not fully encompass the capabilities available in Automation Anywhere for Excel sheet activation, as they limit the ways to reference sheets to only one method. Thus, the correct answer demonstrates the flexibility offered by Automation Anywhere when integrating with Microsoft Excel.