UOP BIS 221 Week 4 Sales Analysis Spreadsheet .pdf
Original filename: UOP BIS 221 Week 4 Sales Analysis Spreadsheet.pdf
This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on pdf-archive.com on 02/03/2017 at 12:14, from IP address 43.224.x.x.
The current document download page has been viewed 96 times.
File size: 199 KB (3 pages).
Privacy: public file
Download original PDF file
UOP BIS 221 Week 4 Sales Analysis
Check this A+ tutorial guideline at
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
• 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
• Use the SUM function
• The date function
• An additional math or statistical function
of your choice
• Fill colors to differential areas of your
• Border lines to differential area of your
Click the Assignment Files tab to submit your
For more classes visit