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 or dates.

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

Answer:

3. is not true about sorting data in Excel

Answer 2

3. You cannot sort data by more than one column is not true about sorting data in Excel.

Microsoft Excel:

• Excel is a spreadsheet application that is used to store, analyse, and report large amounts of data.
• Accounting teams frequently use it for financial analysis, and it can be used by an expert to manage long as well as unwieldy datasets.
• Balance sheets, budgets, and editorial calendars are examples of Excel applications.

Sorting data in Excel:

1. Choose the data to sort.
2. Sorting is quick and simple.
3. Sort using the criteria you specify.