Question: Using the table below, what is the most efficient way to fill columns D and E with the ranks ( both in descending order )

Using the table below, what is the most efficient way to fill columns D and E with the ranks (both in descending order) for cost and sales price of the stationary items?
\table[[,A,B,C,D,E],[1,Item,Cost,Sales Price,Cost Rank,Sales Price Rank],[2,Notebook,$0.88,$1.76,,],[3,Binder,$1.30,$2.60,,],[4,Staple,$1.05,$2.10,,],[5,Hole Punch,$1.20,$2.40,-,],[6,Highlighter,$0.95,$1.90,,],[7,Pencil,$0.10,$0.20,,],[8,Pen,$0.50,$1.00,,],[9,Eraser,$0.20,$0.40,,],[10,Sharpener,$1,$2.00,,],[11,Whiteout,$0.80,$1.60,,],[12,Clear Tape,$0.70,$1.40,,],[13,Scissor,$1.75,$3.50,,],[14,,,,,]]
 Using the table below, what is the most efficient way 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 General Management Questions!