This final project is an exercise to flux solely of the Microsoft Office 2010 products covered this term. Each section is price 5 points; with the project total worth is 20 points. You ar not allowed to work on this in class. This project serves as the class final exam. One point will be deducted for each occurrence of poor grammar and misspelled words.
tone of voice 1 score the data.
1. Create a new Access table by Importing the work sheet Raw Data from the travel by Workbook, CGS1060 Final Project Data.xlsx, into Access. ( Note: you should have 97 records including tug headings)
2. Name the Access table Financial Data.
Step 2 Create the following authorships.
General Formatting for all chronicles:
A. All Report headings should be 20 pts., and Times late Roman font.
B. Type Your Name in the Report title.
C. rascal numbers should be RIGHT JUSTIFIED at the paginate bottom.
D. Ensure you have at to the lowest degree 1 place all around.
1. Create a report that Sum Sales, Costs, and lolly by Region. DO non INCLUDE DETAILS. Title the report Summary By Region.
2. Create a report that Sum Sales, Costs, and Profit by yr, by Quarter. DO NOT INCLUDE DETAILS.
Title the report Summary By Year by Quarter.
Step 3 Create outperform Charts
1. Using the CGS1060 Final Project_Data.xlsx, create the following Charts:
A. Exploded Pie three-D Pie Chart showing Profits by Region. Name the chart Acme Consumer Products Profits By Region
B. three-D line of work chart showing Chart showing Profits by Year. Name the chart Acme Consumer Products By Year
C. 3-D Clustered Column chart showing sales, Costs, Profits by product. Name the chart Acme Consumer Products by Product.
Step 4 Create the PowerPoint Presentation
1. Prepare a PowerPoint Presentation of at least 3 slides based on your analysis of the Acme pecuniary data.
2....If you want to get a full essay, order it on our website: Orderessay
If you want to get a full essay, wisit our page: write my essay .
No comments:
Post a Comment