BISS 221 week 4 LT assignment
nette1346
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
- 9 years ago
- 5
Answer(1)
Purchase the answer to view it
NOT RATED
- sales_analysis_spreadsheet.xlsx
Bids(0)
other Questions(10)
- The Cinematic Auteur
- SIX SIGMA HELP?Gauge Verification
- Marriage and Family Essay
- philosophy
- Need a response ASAP to this statistics question
- ENGLISH 101
- Billboard Class
- PROJ 410 All Discussions Week 1 - 7.....................(PROJ 410 Contracts and Procurement - DeVry)
- help me
- PROJ 587 Week 5 Case Study - Recently Taken...............(PROJ 587 Advanced Program Management - DeVry)