In the Summary sheet, create a new column to the right of “%Total Sales to Dealers Annual”. Name it “Top Model?”. Format this column to have borders that match the rest of the table. Use a function to display “TOP” for each model that has a % of total sales greater than the average of the % total sales for all models.(Using Excel) 

Transcribed Image Text:

%Total %Total %Total Top Model Sales to Sales to Sales to July-December Sales to Dealer Annual Jan-June Sales Total Sales to Dealers Dealers Dealers Volume 260 Jan-June July-Dec 0.21 Model to Dealer Dealers Annual 5.473,683.28 5,821,218.73 11,294,902.01 6,816,608.57 VX207 0.24 0.23 0.27 0.14 VX212 VX208 VX217 159 6,816,608.57 883 35.272,858.04 35,272,858.04 60,712,724.58 1.46 0.71 30,587,502.11 56.003.840.64 94,514,075.28 100,581,879.93 191,578, 127.63 22,835,451.32 152,479,783.53 156,593.107.66 1576 30,125,222.48 1.19 1.24 1.22 VX220 2870 52,232,538.24 94,655,246.42 108,236,378.88 189, 169,321.70 201,554,576.06 380,456,046.15 23,176,788.41 306,667,449.93 258,443,835.00 524,824.32 315,246, 184.67 2.18 2.16 2.17 5360 VX219 VX201 3.68 3.91 3.79 5673 100,972,696.13 3.91 4.17 4.04 7.46 7.62 0.46 VX209 11131 188,877.918.52 341,337.09 154,187,666.41 101,850,727.34 524,824.32 158,217,784.25 156,368,569.90 7.79 VX204 679 0.89 0.01 5.93 6.09 6.36 VX215 VX210 8978 6.14 4.20 0.02 8125 5.18 VX211 16 0.01 VX216 VX214 10602 6.11 157,028.400.42 157,093,841.56 6.53 6.31 10805 313,462,411.45 6.11 6.45 6.28 6.58 5.13 164,559,987.24 128,176,406.06 182,420,189.91 127,815,757.09 VX224 11448 163,756,975.80 127,850,864.90 245,727,863.64 328,316,963.04 256,027,270.97 428,148,053.55 256,910,071.30 250,354,419.65 338,108,335.49 228,932,028.00 251,884,312.82 222,212,558.34 221,179,543.20 6.37 6.79 VX218 11797 4.98 5.29 7.53 5.27 VX223 9.56 8.57 5.15 5.01 21114 VX213 12860 129,094,314.21 5.02 4.84 VX206 VX202 VX205 12866 124,398,865.60 168,836,501.43 125,955,554.05 169,271,834.05 98,616,873.60 125.495, 164.22 5.20 6.98 4.07 18640 6.57 6.77 130,315,154.40 126,389,148.59 111,017,084.94 12610 5.07 4.58 VX222 14933 4.92 5.18 5.04 VX221 14948 111,195,473.40 110,532,322.37 4.32 4.59 4.45 VX203 15400 110,647,220.83 4.31 4.56 4.43 Total 213733 $2,569,620,296.27 $2,423,488,169.86| S4,993, 108,466.13| 100 100 100.00 %Total %Total %Total Top Model Sales to Sales to Sales to July-December Sales to Dealer Annual Jan-June Sales Total Sales to Dealers Dealers Dealers Volume 260 Jan-June July-Dec 0.21 Model to Dealer Dealers Annual 5.473,683.28 5,821,218.73 11,294,902.01 6,816,608.57 VX207 0.24 0.23 0.27 0.14 VX212 VX208 VX217 159 6,816,608.57 883 35.272,858.04 35,272,858.04 60,712,724.58 1.46 0.71 30,587,502.11 56.003.840.64 94,514,075.28 100,581,879.93 191,578, 127.63 22,835,451.32 152,479,783.53 156,593.107.66 1576 30,125,222.48 1.19 1.24 1.22 VX220 2870 52,232,538.24 94,655,246.42 108,236,378.88 189, 169,321.70 201,554,576.06 380,456,046.15 23,176,788.41 306,667,449.93 258,443,835.00 524,824.32 315,246, 184.67 2.18 2.16 2.17 5360 VX219 VX201 3.68 3.91 3.79 5673 100,972,696.13 3.91 4.17 4.04 7.46 7.62 0.46 VX209 11131 188,877.918.52 341,337.09 154,187,666.41 101,850,727.34 524,824.32 158,217,784.25 156,368,569.90 7.79 VX204 679 0.89 0.01 5.93 6.09 6.36 VX215 VX210 8978 6.14 4.20 0.02 8125 5.18 VX211 16 0.01 VX216 VX214 10602 6.11 157,028.400.42 157,093,841.56 6.53 6.31 10805 313,462,411.45 6.11 6.45 6.28 6.58 5.13 164,559,987.24 128,176,406.06 182,420,189.91 127,815,757.09 VX224 11448 163,756,975.80 127,850,864.90 245,727,863.64 328,316,963.04 256,027,270.97 428,148,053.55 256,910,071.30 250,354,419.65 338,108,335.49 228,932,028.00 251,884,312.82 222,212,558.34 221,179,543.20 6.37 6.79 VX218 11797 4.98 5.29 7.53 5.27 VX223 9.56 8.57 5.15 5.01 21114 VX213 12860 129,094,314.21 5.02 4.84 VX206 VX202 VX205 12866 124,398,865.60 168,836,501.43 125,955,554.05 169,271,834.05 98,616,873.60 125.495, 164.22 5.20 6.98 4.07 18640 6.57 6.77 130,315,154.40 126,389,148.59 111,017,084.94 12610 5.07 4.58 VX222 14933 4.92 5.18 5.04 VX221 14948 111,195,473.40 110,532,322.37 4.32 4.59 4.45 VX203 15400 110,647,220.83 4.31 4.56 4.43 Total 213733 $2,569,620,296.27 $2,423,488,169.86| S4,993, 108,466.13| 100 100 100.00

Answer rating: 100% (QA)

Please note that the cell address used by me eg I2 and H2 are abou... View the full answer