Business Environment

    Busin" rel="nofollow">iness Environment       Task 1 (5 Marks)Insert the followin" rel="nofollow">ing table in" rel="nofollow">into a new word document, Calculate the average marks for each student usin" rel="nofollow">ing function feature of MS Word. Name Science Maths English AverageTom Hopkin" rel="nofollow">ins 50 30 50 Fred Mandel 30 12 59 Theo Savalas 30 17 39 Colin" rel="nofollow">in Jeffries 40 9 59 Mike Anderson 70 23 84 Task 2 (5 Marks)Create a Fax Form Template, in" rel="nofollow">in which user must be able to customise the letter as per letter requirement. A sample is given below: 20 Fox St, Sydney Phone: 33333333 Fax: 4444444 To: (“Who is this fax from?”)Company: (“Company Name?”)Fax No: (“Fax Number?”) From: (“Who is this fax from?”)Date: (Automatic Date)           (Note: Contain" rel="nofollow">ins today’s date and current time)Subject: (“Subject of fax”)No of Pages:   (“No of pages”)Message: (“Sender’s Message”) Note: The words in" rel="nofollow">in italics refer to the in" rel="nofollow">input fields. Task 3 (12 Marks)Type the followin" rel="nofollow">ing letter To,<<FIRSTNAME>><<LASTNAME>><<ADDRESS>><<SUBURB>> <<POSTCODE>> Dear <<FIRSTNAME>>, Thank you for your letter dated 5th of May concernin" rel="nofollow">ing payment of your account.You will appreciate that, under the terms of the contract, arrears in" rel="nofollow">in excess of 30 days are due and payable forthwith.Accordin" rel="nofollow">ingly, while we appreciate your current disposition, we must ask that you remit the full amount of arrears $<<AMOUNT>> within" rel="nofollow">in seven days or legal proceedin" rel="nofollow">ings will be in" rel="nofollow">instigated. You have purchased the followin" rel="nofollow">ing items: -? Photocopier? Scanner? Keyboard? Mouse? Mouse pad Yours sin" rel="nofollow">incerely,Allen JamesCredit Manager Your tasks are as follows: 1. Create a table as given below in" rel="nofollow">in your spreadsheet software, Name the worksheet as "List.xlsx" Title First Name Last Name Address Suburb State Postcode AmountMr Kin" rel="nofollow">ing Jones 23 James Ruse Rd Sydney NSW 2000 $3000Miss Daisy Smith 78 smart street Smithfield NSW 2164 $2500Miss Georgin" rel="nofollow">ina Dunn 23 Main" rel="nofollow">in Street Armidale NSW 2350 $1500Mr Peter Trigg 90 High Street Mackay QLD 4157 $ 2000Mr Rob Jung 2 Min" rel="nofollow">inton Street Wagga Wagga NSW 2650 $ 3500Mr Kerry Sergeant 4 River Street Geelong VIC 3175 $ 1200 2. Mail merge the letter with the table from worksheet " List.xlsx"3. Submit the Letter_template.docx, Merge_Letter.docx, and List.xlsx along with the screenshots for all the steps in" rel="nofollow">in a folder:” Assessment 1_Task 3”. Task 4 (6 Marks)Record the followin" rel="nofollow">ing macro called letter usin" rel="nofollow">ing the followin" rel="nofollow">ing letter:Dear Jeff, Congratulations on a fin" rel="nofollow">ine effort of sales and for exceedin" rel="nofollow">ing your target for the 1st January 2005.Please fin" rel="nofollow">ind enclosed a cheque for $ 200.50 bein" rel="nofollow">ing commission for this month Yours sin" rel="nofollow">incerely,THE BOSS When you fin" rel="nofollow">inish create a new button and assign it to the macro that you have created name it createLetter, choose default style and select the followin" rel="nofollow">ing          button. Add this button to the Quick Access Toolbar. • Take screen shots of the process you followed to create the above macro button and how you added it to the QuickAccess toolbar. • Save the letter as Assessment 1_Task 4.docx.   You must submit: • Discuss and request feedback from other student or your train" rel="nofollow">iner about your solutions. (2 Mark) • Save Task 1 and task 2 solution in" rel="nofollow">in a new document: Assessment 1_Task 1_Task 2.docx • Submit the followin" rel="nofollow">ing files: 1. Assessment 1_Task 1.docx2. Assessment 1_Task 2.dotx3. A folder : Assessment 1_Task 3 4. Assessment 1_Task 4.docx. • Prin" rel="nofollow">int the documents portrait orientation double sided.