Perform the following procedures in Excel and complete your worksheet (20 Marks) Create a worksheet containing monthly expenditure on purchase of household items , rent payment , mobile recharge , electricity and cable TV with proper headings. Make assumptions about expenditures. There is a provision of discount of 15 % over the purchase of Rs. 6000 of purchasing. The worksheet should contain monthly income, monthly expenditure listed and summed, total discount, , left over amount each month and the amount left over per day (assume 30 days in a month)

Imagine that you want to have an appointment with doctors for a regular check-up in a hospital . You are required to make a schedule, make a contact list of all the doctors, send an e-mail , take an on-line appointments , pay the consultation fees in advance, book a taxi. Write all the options available to fulfill the task in Outlook.

 Make a marketing presentation of any 4G mobile phone with at least 10 slides highlighting technical features of the brand. Use different customized animation effects on pictures and Clip Art on any four of the 10 slides. All slides should have slide notes. Write speaker notes for each slide .