um... how do I solve the problems using Microsoft Excel functions? I need to fill in the yellow boxes

Home + Share A Insert Page Layout Calitri (Body) Copy Formen BI U x .fr Formulas 11A S Data Review View AY - = = * A ESSE =a tap Text Mega Cetur Gerveral $ % Nom 1 Condos Format Fomarting a Table a d Bad *. * : ) Nitro Calculation Check Coll ert Dele Fermat e Cica Sort Fiter Paste G22 N O P Q R S L M Discounts applied to order 22.5% 25.0% 27.5% 10.0% 12.5% 15.0% 17.5% 20.0% 30.0% 32.5% 35.0% 37.5% 40.0% Shipping Cost $ 15.00 1 Package Purchased 2 Tier Price 3 Bronze $ 100 4 Silver $ 200 5 Gold $ 300 6 Emerald $ 400 7 Ruby $ 500 8 Diamond $ 600 Hover over this cell to see what the final table should look like. 10 We are selling different tiers of a product. 11 The price to ship is the same, but this month we are sending out discount codes of varying amounts 12 Complete the table to find the total price customers would have to pay for their item using absolute and relative references Referencing Probability + Ready PT - + 181% Formulas Data Review View + Share Home . Insert Cul Page Layout C alibri Body) A 11 A . A Bad A home Net Good Check Ce . sert . Format Paste E = HTH A Carter. $ % ) Condir.ca Format Farmecting a TALL r De ete Sors G17 x fx 2 Random playing and from a fair deck Dawa new card & You hit the button and a card is drawn, what is the pronality of receiving 10 1 The 2 of duba? 11 21 A jack? | 11 | VTC U Uls? 13 4 An act or a spade? 16 a sthan a 107 assuming card is rep aced in the deck 17 What if the card is not back in the deck Relancing Probability Ready T I + 115% Home + Share A Insert Page Layout Calitri (Body) Copy Formen BI U x .fr Formulas 11A S Data Review View AY - = = * A ESSE =a tap Text Mega Cetur Gerveral $ % Nom 1 Condos Format Fomarting a Table a d Bad *. * : ) Nitro Calculation Check Coll ert Dele Fermat e Cica Sort Fiter Paste G22 N O P Q R S L M Discounts applied to order 22.5% 25.0% 27.5% 10.0% 12.5% 15.0% 17.5% 20.0% 30.0% 32.5% 35.0% 37.5% 40.0% Shipping Cost $ 15.00 1 Package Purchased 2 Tier Price 3 Bronze $ 100 4 Silver $ 200 5 Gold $ 300 6 Emerald $ 400 7 Ruby $ 500 8 Diamond $ 600 Hover over this cell to see what the final table should look like. 10 We are selling different tiers of a product. 11 The price to ship is the same, but this month we are sending out discount codes of varying amounts 12 Complete the table to find the total price customers would have to pay for their item using absolute and relative references Referencing Probability + Ready PT - + 181% Formulas Data Review View + Share Home . Insert Cul Page Layout C alibri Body) A 11 A . A Bad A home Net Good Check Ce . sert . Format Paste E = HTH A Carter. $ % ) Condir.ca Format Farmecting a TALL r De ete Sors G17 x fx 2 Random playing and from a fair deck Dawa new card & You hit the button and a card is drawn, what is the pronality of receiving 10 1 The 2 of duba? 11 21 A jack? | 11 | VTC U Uls? 13 4 An act or a spade? 16 a sthan a 107 assuming card is rep aced in the deck 17 What if the card is not back in the deck Relancing Probability Ready T I + 115%