(1) Create the following worksheet. Enter appropriate formula in empty cells. Proportion() Rank 51 Amount Sold 2 Products Number Unit Cost Proceeds 4TV 254 560 5 PC 325 1590 6 Radio 63 78 7 Video 116 198 1 Printer 56 280 CD 540 25 10 MD 38 11 Total 12 333 Notes: All number cells (e.g. cells under "Unit Cost" must be the comma format (every three digits punctuated with a comma). The cells under "Proportion" must be the integer format with "%" sign appended. The cells under "Proceeds" must be appended with "$" sign