Question 1 (4 points) Create a formula in cell H3 that fills down to cell H12, showing the Recommendation Given based on the Percentage Rating, Range, and Recommendation Type categories. The table you are to reference is below: Name Rating (/10 Percentage Rating Recommendation Given Liam Emma Noah Olivia Recommendation T Range 80% or more Less than 80% but greater than or Leaa than 30% 9/10 10/10 5/10 8/10 William3/10 9.5/10 Yes l to 30 % 100% 50% 80% 30% 95% 10% 20% 60% 100% No Ava James Isabella es1/10 10 an 6/10 ophia10/10 10 12