BISS 221 week 4 LT assignment

profilenette1346

 

I will lll send the spreadsheet 

 

 

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

  • Monthly sales by Region
  • Quarter One sales by Region
  • Monthly sales by Product
  • Quarter One sales by Product
  • Monthly sales by Region, by Sales people
  • Quarter One sales by Region, by Sales people
  • Create 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 function
  • The date function
  • An additional math or statistical function of your choice
  • Fill colors to differential areas of your spreadsheet
  • Border lines to differential area of your spreadsheet

 

    • Posted: 5 years ago
    • Due: 
    • Budget: $5
    Answers 1

    Purchase the answer to view it

    blurred-text
    • Usingthe ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following:

      • Monthly sales by Region
      • Quarter One sales by Region
      • Monthly sales by …

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

      • Monthly sales by Region
      • Quarter One sales by Region
      • Monthly sales by …

    • Not rated

      Spread sheet

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


      •Monthly sales by Region
      •Quarter One sales by Region
      •Monthly sales by …

    • Not rated

      Spreadsheet?

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

      • Monthly sales by Region
      • Quarter One sales by Region
      • Monthly sales by …

    • BIS 221 Week 4 Sales Analysis Spreadsheet

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

      • Monthly …