insert a function in cell g5 to calculate the first students monthly payment using appropriate relative and absolute cell references

het Page Layout Formulas Data Review View Help A = Gener Calibri BIU 11 - Fant A A Paste Wrap Text Merge & Center - E $ - Clipboard 5 Alignment G5 A A F G H B C D E Inland Jewelers 2/15/2020 2 Date Name Ring Type Cost Personalized Total Years Monthly Payment 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals Silver Gold Titanium Platinum Platinum Gold Titanium $400.00 Yes $550.00 Yes $ 700.00 No $ 750.00 No $ 750.00 Yes S 550.00 No $ 700.00 Yes $ 420.00 $ 577.50 $ 700.00 $ 750.00 $ 787.50 $ 550.00 $ 735.00 NN- 15 Ring Type 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Cost S 400.00 $ 550.00 $ 700.00 $ 750.00 Class Ring E O Type here to search A livestock company reports that the mean weight of a group of young steers is 1084 pounds with a standard deviation of 100 pounds. N(1084,100) for the weights of steers, what percent of steers weigh a) over 1000 pounds? b) under 1100 pounds? c) between 1150 and 1250 pounds? a) % of steers have weights above 1000 pounds. (Round to one decimal place as needed.)