1.A table named “Daily Sales” in a Microsoft Access database has the following fields:
Each record on the table represents a day of total sales for each product and the data covers the last five years. Your boss asks you to create a visual report of the sales performance of each product during the last 12 months.
Prepare a step-by-step description of how you would use Microsoft Excel to prepare the report and email it to your boss following these steps:
Step 1 - Import data from Access to Excel
Step 2 - Summarize Monthly Data for each product during the last 12 months
Step 3 - Create a visual representation of monthly data
Step 4 - Email the spreadsheet with your comments to your boss
2.You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.