Introduction Top 10N, Below Average, High/Medium/Low, etc. The "formatting" indeates ways in which you can perform actions such as changing the color of the cell and/ar tont, use color tarh, or icans. The retilt is that viewers can gain insights into the cata verr quichily without having to examice cach individual data value. Online. From there, you wal fond all the diflerent conditions and formats you can sopy to the data you stiected. "Celour (Colop) blindness (Colour vision deficency, or CVD) affect approwimutely 1 in 12 men (aW) and 1 is 200 women is the world. In britain this means that there are approwimately 3 millon colour blind people (about 4.5% of the entire population), mott of whom are main. Werideide, there are approximately 300 milion people mith colour Bindness, aimon the same number of seople as Therefore, it is not recommended to use red and greth together to meve comparisons, which unfortunstely, Excel does quite often by default. The cata has been coliected in the Microsen Excel Online fie below. Open the spreadsheet and perform the required anulysis to answer the questions below Apply conditional formationg to the data in Column H that is between 1,650 and 2,300. How many values ace between 1,850 and 2,300? Duplicates volue? Top 10% answer the questions below. Hew many values are formatted? What is the larger of the values? What is the smalier of the values? : Grodient rill (maximurn) send imallest (minimum) value? Mavimum: Minmim: Color seale Apply Celer Seales to the dota in Column Q. Do NOT sort the ela. Af what postion (1 being the top and 20 being the bottom) does the minimum data value occiar? CONDTTIONAL FORMATT VG IN MICROSCAT FXCSF