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.

Get Professional Help with Your Research Essay Paper Today From Our Student Essay Service!