Assessment Task Task 1 (Microsoft Excel): (80 marks) City Cinema-Muscat A well renowned Cinema in Oman named as "Cty Cinema-Muscat wants to introduce the automation process in order to facilitate the customers. The Manager of the Cinema has decided to assign a task to you as a developer to maintain the billing system for the customers. In this regard, you are requested by him to prepare and submit a report in Excel worksheet to keep the complete record of customers along with the calculation of their bill amount for tickets, snacks, soft drinks and other facilities (if any) provided by the Cinema management. The task should contain the following: Task 1 (a): Create a COMPLETE worksheet with appropriate labels for this scenario. The following should be induded in your worksheet: Title of the worksheet Name of the file: Your Name - Student) . Complete contents and headings of the table I. Page orientation to Landscape along with the professional look of document. Une filter by category Task 1 (b): Calculate the Total bill of each visitor that includes the real price of tickets, snacks, sot rinks etc. before applying the discount/promotion by using appropriate formula in the respected cells 3. Calculate the 10% Discount on Total bill against each viskor by using appropriate formula in the respected cels - Calculate the Grand total after subtracting the discount amount (1084) from the total sit against each visitor by using appropriate formula in the respected cells c. Display the Remarks of each victor by using statement Condition for Remarks Grand total of each stor is less than or equal to 25. remarks would be Affordable Grand total of each witor is more than 15, remarks would be "Not afford Count the number of visitors pren in the table by using the appropriate form the respective . Calculate the Maimun al from cand total column by using the appropriate formule in the i. Calculate the Minimum bel from the Grand total column by using the propriate formula in the respective cell with Count the number of remarks "Affordable from Remarks column by using the propriate formula in the respective cell in Count the number of remarks Hot affordable from Remarks column by using the appropriate formula in the respective cell respective cell Task 1 (0: Create a Colume graph beled that will show the Grand total of each to Create a Pie Chart labeled that will show the Discount amount of each istor Task 2 (Microsoft Word): (20 marks) In a separate word fie, write the functions that you used in all tasks mentioned in the above city In header.footer.formular, etc) in the purpose of each function appropriately (word count: 250 worde Assessment Task Task 1 (Microsoft Excel): (80 marks) City Cinema-Muscat A well renowned Cinema in Oman named as "Cty Cinema-Muscat wants to introduce the automation process in order to facilitate the customers. The Manager of the Cinema has decided to assign a task to you as a developer to maintain the billing system for the customers. In this regard, you are requested by him to prepare and submit a report in Excel worksheet to keep the complete record of customers along with the calculation of their bill amount for tickets, snacks, soft drinks and other facilities (if any) provided by the Cinema management. The task should contain the following: Task 1 (a): Create a COMPLETE worksheet with appropriate labels for this scenario. The following should be induded in your worksheet: Title of the worksheet Name of the file: Your Name - Student) . Complete contents and headings of the table I. Page orientation to Landscape along with the professional look of document. Une filter by category Task 1 (b): Calculate the Total bill of each visitor that includes the real price of tickets, snacks, sot rinks etc. before applying the discount/promotion by using appropriate formula in the respected cells 3. Calculate the 10% Discount on Total bill against each viskor by using appropriate formula in the respected cels - Calculate the Grand total after subtracting the discount amount (1084) from the total sit against each visitor by using appropriate formula in the respected cells c. Display the Remarks of each victor by using statement Condition for Remarks Grand total of each stor is less than or equal to 25. remarks would be Affordable Grand total of each witor is more than 15, remarks would be "Not afford Count the number of visitors pren in the table by using the appropriate form the respective . Calculate the Maimun al from cand total column by using the appropriate formule in the i. Calculate the Minimum bel from the Grand total column by using the propriate formula in the respective cell with Count the number of remarks "Affordable from Remarks column by using the propriate formula in the respective cell in Count the number of remarks Hot affordable from Remarks column by using the appropriate formula in the respective cell respective cell Task 1 (0: Create a Colume graph beled that will show the Grand total of each to Create a Pie Chart labeled that will show the Discount amount of each istor Task 2 (Microsoft Word): (20 marks) In a separate word fie, write the functions that you used in all tasks mentioned in the above city In header.footer.formular, etc) in the purpose of each function appropriately (word count: 250 worde