Creating Excel Spreadsheet
kyla22Using 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
- 20
Answer(4)
Purchase the answer to view it
NOT RATED
- abc_technologies_inc.xls
Purchase the answer to view it
NOT RATED
- abc_technologies_inc.xls
Purchase the answer to view it
NOT RATED
- order_16557_41146.xls
Purchase the answer to view it
NOT RATED
- sales_analysis_spreadsheet_1.xlsx
Bids(1)
other Questions(10)
- standard 5 paragraph summary response essay(500 word)
- PROJ586_W3_Homework_AIB
- Finance
- Installation of Oracle Database Oracle10g and Oracle9i
- (Germania 98 c.e) how is Germany society organized?
- For your first assignment, you will select a healthcare-based organization for review and compose a report. In a 4-6 page...
- ETH 316 Week 3 DQ#1 #2 and #3
- Multi Task 3
- . What would your world be like if you were unable to experience external sensory stimulation? Be sure to include vision,...
- HCA 501 -Health Care in America Set-1 Exam