CIS 107 Week 6 Lab Assignment 4: Microsoft Excel XYZ Widget Manufacturing Company
Thomas Edison State College
After successfully completing the laboratory assignment you should be able to:
- Create a spreadsheet in Microsoft Excel 2010
- Use formulas and functions
- Illustrate formatting and editing a spreadsheet
NOTE: It is very important that you work through all of Part 1 of this assignment before you complete Part 2 so that you understand all of the features that are available to you. You do not need to submit the output from Part 1 - submit only the output from Part 2 to your mentor for grading.
Read pages EX 1 – EX 64 in the laboratory textbook, Microsoft Office 2010: Essential Complete Labs 1, 2, and 3 on pages EX 58 – EX 63
As a part of the final project for this course you will be doing research for a medium size (approximately 200 employees) widget manufacturing company to do a complete evaluation of their computer needs and make recommendations to them about an information system to support their business. Currently several of their support departments are using manual processes and they wish to automate their accounting and human resources business processes. They also want to harness the power of the Internet in their business.
For this laboratory assignment you will create an Excel spreadsheet which clearly displays the research that you have done to determine the cost of the various components of the new information system that you are recommending to the company executives. Your spreadsheet should calculate a total cost of the information system and display the individual components costs in a graph. This spreadsheet will be presented as a part of your final project. You will need to expand the spreadsheet that you submit as a part of the final project to include any comments from your mentor on this lab assignment as well as any additional information that you have included in your final project report.
Purchase the answer to view it