One Excel FileAdvertising Report: Create an advertising versus sales report as g

One Excel FileAdvertising Report: Create an advertising versus sales report as given. Set the value format to show dollar signs but no centsSales: 1stQtr : $5214 2nd Qtr: $6807 3rd Qtr : $7546 4th Qtr: $12 264b Total:Advertising: 1st Qtr : $450 2nd Qtr : $500 3rd Qtr : $600 4th Qtr: 1250 Total:Advertising: 1stQtr 2nd Qtr 3rd Qtr 4th Qtr TotalAs A % of:Sales:In cells marked (a) through (d) create formulas that will calculate the percentage of sales represented by advertising and present the results with two decimals. In cells (e) and (f) create formulas to total sales and advertising.