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