One Excel File

One Excel File 

Advertising Report: Create an advertising versus sales report as given. Set the value format to show dollar signs but no cents

Sales:  1^st  Qtr : $5,214         2^nd Qtr: $6,807           3^rd Qtr : $7,546          4^th Qtr: $12, 264b  Total:

Advertising: 1^st Qtr : $450   2^nd Qtr : $500             3^rd Qtr : $600             4^th Qtr: 1,250 Total:

Advertising:  1^st  Qtr             2^nd Qtr             3^rd Qtr             4^th Qtr Total

As 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.