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?
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.