BIS 221 Week 4 Assignment 1 | University of Phoenix | Assignment Help
- University of Phoenix / BIS 221
- 22 May 2021
- Price: $15
- Computer Science Assignment Help / Programming Assignment Help
BIS 221 Week 4 Assignment 1 | University of Phoenix | Assignment Help
Sales Analysis 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
Click the Assignment Files tab to submit your assignment.
USA 
India