Classify and then sort the following inventory items first as either A, B, or C category items and then by reverse dollar value % Inventory Classification Rules Inventory Type A B Min Cutoff Dollar Value % 15.0% 5.0% 0.0% Tip: Use a nested if() and the Data Sort Range menu Inventory Item Item 01 Item 02 Item 03 Item 04 Item 05 www.ccm Item 06 EPOS Item 07 F Item 08 CO Item 09 Item 10 Total Quantity In Stock 100 1,200 1,000 1,000 250 350 500 600 600 1,550 2,000 ? Unit Cost $8.50 $0.42 $90.00 $12.50 $0.60 $42.86 **** $154.00 $14.17 $17.00 $0.60 % Unit Count ? ? ? ? ? ? ? ? ? ? ? sanity check Dollar Value ? ? ? ? ? = ? = ? ? 2 ? ? ? Dollar Value% ? ? ? ? ? ? ? ? ? Points: ? ? sanity check 0 nested if()! ABC Inventory Type ? ? ? ? ? ? ? ? ? ? /50 Sort range from D7 Data has header row Sort by Column J then by Column 1 - Add another sort colum