MGMT1000 INDRODUCTION TO COMPUTERS
SEMESTER 1, 2009 – 2010
This assignment looks in the dealings of X Company Ltd, a striving company in the Tourism Industry located in 434 Dwellings, La Pansee Corner Castries. The company has recently implemented some very important “greening” initiatives and wants you a newly promoted Assistant Operations Manager to process some company data and prepare a presentation to the new Board of Directors using Microsoft Office. Follow the components below to attain a greater understanding of the full requirements. Your telephone number and email address is (758) 246-8102 and firstname.lastname@example.org.
The assignment consists of three (3) gradable components using Microsoft Excel, Microsoft PowerPoint and Microsoft word applications. Each component carries with it several questions for which you are required to provide all solutions to fully maximize on mark potential. Please note that in some instances you are asked to integrate features between applications. The deadline for assignment is 16th November, 2009 at 11.59pm. Download all related files.
1. For this part of the assignment browse through all worksheets before attempting the question. Using the Microsoft excel workbook assgt_mgmt1000s1_09.xls complete the questions below to provide solutions for the directors and board members of X Company Ltd., regarding their financial reporting requirements: [80 Marks]
b. Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals. 
c. Using the auto format feature format range A3:D12. Note that values are formatted with the thousands separator but with no “$” signs and decimal places.
d. Create a 3-D clustered column chart with the relevant labels, titles and legends while changing the default colors as shown below in Figure 1. The chart is to be inserted in the same worksheet. Hint...