1. TED Talk managers are preparing a presentation on the history of TED Talks. They need some help developing some important visual aids. Specifically, they want a color-coded chart that shows how certain descriptive tags seems to cluster together for the higher ranked videos. Using the provided spreadsheet of the top 10 TED Talks and their descriptive tags, use a series of conditional formatting and then manual sorting to create visual clusters to visually show how the top-ranked videos are tagged by viewers. Create a visual aid that shows the descriptive qualities that best define the top-ranked videos. \

Detailed Instructions:

1. Download the spreadsheet, TED Talk Activity.xlsx. Refer to Q2 sheet in the spreadsheet.
2. Using conditional formatting, have the descriptive tag counts that are above average display with a green background and those with below average count display with a red background.
3. Manually group rows together (using copy and paste) until you have stacked the colors together as much as possible. (Hint: insert a blank row before you move one, so you do not accidentally delete any data.) Note that although there is no right or wrong way to stack the rows, you want to stack them so that the colors tell the most compelling story.

****very important*****i need the answers of all these following question and you have to use visual Paradigm Online - Suite of Powerful Tools (visual-paradigm.com) toanswer the Questions (15 Marks):

• i. Submit your excel file including the visualized table. (6 Marks).

2. How many times was Inspiring tagged for the top ranked video (3 Marks)?
3. How many times was OK above average (3 Marks)?
4. How many times was Funny above average (3 Marks)?

G H J 6 9 F 5 212 110 184 209 7 550 289 8 377 301 285 63 20 45 1 Ranking 2 Unconvincing 3 Confusing 4 Longwinded 5 Obnoxious 6 OK 7 Ingenious 8 Jaw Dropping 9 Courageous 10 Funny 11 Beautiful 12 Persuasive 13 Fascinating 4 Informative 5 Inspiring 6 D 3 930 112 390 294 1341 3413 2659 1161 B 1 300 242 387 209 1174 6073 4439 3253 19645 4573 10704 10581 7346 24924 715 2 335 197 338 155 1129 1428 3586 6305 938 3232 6217 11111 9787 21210 E 4 233 155 283 113 500 1094 2100 8280 5225 7942 3510 345 363 519 4166 213 153 49 48 43 650 697 152 270 810 735 2678 1801 5167 4133 398 356 636 1228 10464 7842 966 9437 1704 14447 5430 16918 390 335 441 397 669 721 1102 706 2423 1350 1038 5211 K 10+ 231 124 92 77 612 101 119 2306 302 924 497 632 986 1617 60 143 1766 221 240 7731 229 91 939 401 417 100 1640 8845 7440 6600 21564 4638 4561 21444 1752 2231 154 7