Insert Page Layout Formulas Data Review View Home General Wrap Text Conditional FormatCell Formatting as Table Styles Copy Paste Foma Fermat Insert Del Interest Rates Complete the formulas for celumns and D Column C-Us.function to get the interest rate from table below . display in % format Colume D- Compate Interest Amsunt, use Currency farmat 3 Loan AmountLean Tve ntrest eInterest Amount ( 1,000.00 10,000.00 12,000.00 15,000 00 20,000.00 13 Loan Typ btenst .te" (n Produit Doorn , Grade.(1@ MacBook Air Insort Page Layout Formulas Data Review Viow Cut Copy Format BIU Home Calon (Boon General Paste Conditional Format Formatting as Table Product Discount Price per temQutity Discount Percent SubbotalDicount Amount Total 12 Complete the formalas for columns C,D, E and F .Column C . Use tunction to get the discount percent frem the table to the Celumno Subtotal Pre per item Quentity, displa based on the quantity, dsplay . % fermat (2) ey in currency format a) display in currency format 4 ColumnF Total uttet. dMeront, display in currency format