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

Answer

Answer: D

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.

Discuss with Us on Twitter
UiPath Tutorials on YouTube
Check out this UiPath Youtube tutorial from @cameronmcnz.
#UiPath #UiPathCertified #RPACertified #RPA #RPACertification #UiPathTutorial