Question: Use Excel data sorting tool ( and leave the sorting settings ) to sort the list in the following custom order: first by [ Cher

Use Excel data sorting tool (and leave the sorting settings) to sort the list in the following custom order: first by
[Cher,Madonna, Spears, Eminem,Springsteen,Manilow,Mellencamp,Moore] and then by minutes 3,2,5,4,6
DO NOT APPLY AUTOFILTERS OR TABLE FILTERS.
Make sure that your sorting settings are saved (they show when you reopen the file, go to P2 and click on "Sort").
However, do not use Excel options to save your custom lists - they willsave automatically with the spreadsheet.
Assume that no transactions will be added to or deleted from the list .
DO NOT DELETE OR CHANGE INPUT DATA FOR THIS PROBLEM - JUST LEAVE THE SORTED DATA IN ORANGE CELLS.
FORMULAS: Some formulas need to be copi
Use the cell addresses not names if you neeApply conditional formatting to the "Dollars" column in such a manner
 Use Excel data sorting tool (and leave the sorting settings) to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!