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
CherMadonna, Spears, Eminem,Springsteen,Manilow,Mellencamp,Moore and then by minutes
DO NOT APPLY AUTOFILTERS OR TABLE FILTERS.
Make sure that your sorting settings are saved they show when you reopen the file, go to P 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
