Question

Which of the following statements is not true about sorting data in Excel? 1.You can sort data in rows on the basis of text, numbers. 2. You can sort data in ascending or descending order.

3.You cannot sort data by more than one column.
4.You can exclude header rows from sorting.

Answer 1

In Excel, you can sort data in rows based on text or numbers, in ascending or descending order. You can also exclude header rows from sorting, but you cannot sort data by more than one column.

Step-by-step explanation:

Out of the given statements, the one that is not true about sorting data in Excel is: You cannot sort data by more than one column. In Excel, you can sort data in rows based on text or numbers, in ascending or descending order.

You can also exclude header rows from sorting, which is useful when you have a header row that you want to keep at the top of the sorted data. However, Excel does not allow sorting data by more than one column at a time.