Question

1. Which of the following feature in MS Excel lets you arrange data in ascending or descending order?​

Answer 1

Answer:

To arrange data in ascending and descending order in MS Excel, we use the Sorting option.

The sorting option is available under the sort and filter option.

Step 1: Select the data which you want to sort.

Step 2: Click on the Data tab on the Ribbon and then click the Sort command. The Sort dialog box will appear on the screen.

Step 3: Select the sorting order either the ascending or descending.

Step 4: After selection, click on the OK option. The cell range will be sorted by the selected column.

Explanation:

Answer 2

Answer:

Sorting and Filtering

Excel spreadsheets help us make sense of large amounts of data. To make it easier to find what you need, you can reorder the data or pick out just the data you need, based on parameters you set within Excel. Sorting and filtering your data will save you time and make your spreadsheet more effective.

Suppose you have a list of hundreds of records including dates, ages, names, cities, and more. You can quickly organize the data to best suit your needs using Excel’s sort and filter features.

When you sort information in a worksheet, you can quickly organize the data and find values quickly. You can sort an entire worksheet or a range or table of data. Sorting can be done by one or more columns.

If this answer is helpful, please mark it as the brainliest:)

Explanation: