spreadsheet help

profiledimles

Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following:

 

 

 

Monthly sales by RegionQuarter One sales by RegionMonthly sales by ProductQuarter One sales by ProductMonthly sales by Region, by Sales peopleQuarter One sales by Region, by Sales peopleCreate a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc...

 

 

 

Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:

 

 

 

Use the SUM functionThe date functionAn additional math or statistical function of your choiceFill colors to differential areas of your spreadsheetBorder lines to differential area of your spreadsheet

 

  • 9 years ago
  • 10
Answer(6)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    abc_company.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    bis221_week_4_sales_analysis_spreadsheet.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    bis_221_week_4_sales_analysis_spreadsheet.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    abc_technologies_inc.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    bis_221_week_4_sales_analysis_spreadsheet_4.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    sales_analysis_spreadsheet_1.xlsx