You have created a sales report in Microsoft Excel 2010 as shown in the image below:

You need to sort the data in such a way that sales data for the year 2010 is listed in higher to lower
order. Which of the following steps will you take to accomplish the task?

Answer:

Explanation:
According to the question, you need to sort the data in such a way that sales data for
the year 2010 is listed in higher to lower order. Take the following steps in order to accomplish the
task:
1.Select a cell in the data range.
2.Click the Sort option in Data tab.
3.Select My Data Has Header check-box.
4.Select 2010 in the Sort By option.
5.Select Value in the Sort On column.
6.Select Largest to Smallest option in Order column.

Taking these steps will sort your data in the desired way.