How do you rearrange the data in ascending or descending order? A. Data, Sort B. Data, Form C. Data, Table D. Data Subtotals

The correct answer is A. Data, Sort.

To rearrange data in ascending or descending order, you can use the Sort command. This command is available in the Data menu. When you select Sort, a dialog box will appear that allows you to specify the sort order. You can sort the data by any column in the table. You can also specify whether to sort the data in ascending or descending order.

Here are the steps on how to rearrange data in ascending or descending order using the Sort command:

1. Select the data that you want to sort.
2. Click on the Data menu.
3. Select Sort.
4. In the Sort dialog box, select the column that you want to sort by.
5. Select the sort order (ascending or descending).
6. Click on the OK button.

The data will be sorted in the specified order.

The other options are not correct because they do not allow you to rearrange data in ascending or descending order.

Option B, Data, Form, is used to create a form from a table.

Option C, Data, Table, is used to create a table from a range of cells.

Option D, Data Subtotals, is used to add subtotals to a table.