Question

2. Excel can sort data in other fields using the
Sort dialog box.​

Answer 1

Answer:

Explanation:

Types of sorting

When sorting data, it's important to first decide if you want the sort to apply to the entire worksheet or just a cell range.

Sort sheet organizes all of the data in your worksheet by one column. Related information across each row is kept together when the sort is applied. In the example below, the Contact Name column (column A) has been sorted to display the names in alphabetical order.

A sorted worksheet

Sort range sorts the data in a range of cells, which can be helpful when working with a sheet that contains several tables. Sorting a range will not affect other content on the worksheet.

Sorting a range

To sort a sheet:

In our example, we'll sort a T-shirt order form alphabetically by Last Name (column C).

Select a cell in the column you want to sort by. In our example, we'll select cell C2.

Select the Data tab on the Ribbon, then click the A-Z command to sort A to Z, or the Z-A command to sort Z to A. In our example, we'll sort A to Z.

The worksheet will be sorted by the selected column. In our example, the worksheet is now sorted by last name.

Hope it's helpful for u

Thanks

Answer 2

add level

Explanation:

Excel can sort data in more than one field using the add level option of the Sort dialogue box.