Final answer:
In order to reverse the sort order of rows in Query Editor, such as in Microsoft Power Query Editor, you can use the Transform > Table > Reverse Rows option. This flips the order of the rows in the dataset without sorting them. The 'Sort Descending' option sorts data from highest to lowest, which is different from reversing rows. So, the correct answer is 2) Transform > Table > Reverse Rows.
Step-by-step explanation:
The option to reverse the sort order of rows in Query Editor depends on the specific software or platform being used. In general, if you are using software like Microsoft Power Query Editor for Excel, you can reverse the order of rows with the following steps:
Navigate to the Transform tab.
Under the Table dropdown menu, select Reverse Rows.
This will reverse the current sort order of the rows in the dataset.
It does not sort the rows in descending order; rather, it flips the order of the rows entirely.
The sort descending option, typically available as 'Sort Descending' or a similar term, will rearrange the data so that it is sorted from the highest value to the lowest, but this is a different operation than reversing the rows.
Autofilter in contrast, is often used to filter data based on specific criteria, and while it may include sorting functionality, it is not specifically designed to reverse rows.
So, the correct answer is 2) Transform > Table > Reverse Rows.