1. Bao asks you to identify the account reps with high, average, and low evaluation scores. In the Eval Score column (range G11:G29), create a new Icon Set conditional formatting rule using the 3 Stars icons. Edit the rule to display a shaded star in cells with a Number type value greater than or equal to 8. Display a half-shaded star in cells with a Number type greater than or equal to 6. Display an unshaded star in cells with a Number type value less than 6.

8 SC EX 12 CME-1HGL Erd Search Home Insert Page Layout Formulas Data Review View Help 8. 248 Y RC Q Connections g popet - Queries & Connections Soco From Fram B Text/CSV Web ang Sources Connection Giet & Funstorm Duta Geography * Sot DataTypes Sort & Fit G Client B D E F H Murray Medical Medical Monitoring Devices Client ID Client Name Account Rep Criteria Range Area Device SE Eval Score Tier Total Sales >100000 Rep Bonus SC Account Representatives Client IDCilent Name Account Rep Area Device Total Sales Eval Score Tier Rep Bonus 2355 Ridgeway Hospital Hiko NE Critiscope 5 220,500 9.0 Platinum 11,025 2198 Cox Family Care Gonzalez SE AnesPro S 158,500 7.5 Silver $ 2911 East Grove Pediatric Gonzalez SE Vivo S 140,500 7.0 Silver S 2855 Parkview Medical Hirko NE Vivo 1 $ 127.500 8.0 Gold $ 2275 Gulf Medical Center Siva SE Oltiscopes 120.750 8.0 Gold 5 2326 St. Johns Hospital Hayati MW 02 Monitor 5 120,100 6.5 Silver S 3068 Donovan Medical Center Kruse NW Vivo Il $ 107,500 9.5 Platinum 5,375 2340 Brevard Healthcare Flowers SE DataSigns $ 105,500 6.5 Silver $ 2701 Associated Healthcare Malick MW 02 Monitor $ 98,750 5.5 Bronze S 2612 Advanced Medical Center Silva SE Destra S 68,770 8.0 Gold $ - 2310 LaMont Medical Clinic Soto NY Vivo 11 $ 66,800 5.0 Bronce S 3014 Midwest Clinic Malick MW Destra $ 64,500 7.0 Silver 2244 Bay Healthcare $ Flowers SE Destra $ + 58,700 5.0 Bronze S 2287 Agora Hospital Kruse NW Vivo 11 $ 57,500 9.0 Platinum 2203 First Choice Medical Wilkins 2.875 SW 02 Monitors 56,300 3115 Dermatology Associates Wilkins 6.0 Silver 5 SW AnesPro S 2141 Capital Clinic 52,500 7.0 Silver S Hayati MW Destra $ 2219 Mercy West 47,750 7.0 Silver Soto S NW Vivo $ 2077 Northwest Hospital 30,650 Wruse 4.5 Bronze S NW 3 Total Vivo $ 28,500 19 3.5 Gold 5 $1,731,570 7.1 $ 19,275 2 1 Extract Range Type here to o c D