Question: When using an Excel Application Scope activity, which activity should be used to sort a table directly in an .xlsx file?
- Sort Data Table
- Get Table Range
- Select Range
- Sort Table
This was a tricky one. If you have loaded the spreadsheet into a table and wanted to sort that, then Option A, Sort Data Table, is the correct answer
Since we are sorting the spreadsheet within itself, Sort Table is the correct activity.
Get Table Range and Select Range do not have any sorting capabilities.