Laboratory Assignment: Microsoft Excel

Objectives

After successfully completing the laboratory assignment you should be able to:

• Create a spreadsheet in Microsoft Excel 2013.
• Use formulas and functions.
• Illustrate formatting and editing a spreadsheet.

Assignment

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. Do not submit the output from Part 1; submit only the output from Part 2 to your mentor for grading.

Part 1

• Read pages EX 1 through EX 54 in the laboratory textbook, Microsoft Office 2013: Essential.
• Complete Labs 1, 2, and 3 on pages EX 59 through EX 62. (When preparing Labs 1, 2, and 3, follow the step-by-step instructions in the textbook.)

Part 2

• As a part of the final project for this course you will be doing research for a medium-sized widget manufacturing company (approximately 200 employees) 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 that clearly displays the research you have done to determine the cost of the various components of the new information system 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 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 you have included in your final project report.