Sales Analysis Spreadsheet

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

Answer Detail

Get This Answer

Invite Tutor