TASK 1: Follow the instructions and prepare the Worksheet by as follows. (Using MS- Excel Spread sheet application) [03][5 Marks] - Apply the heading to the worksheet as shown. Mark) - Apply merge \& center as shown. Mark) - Apply wrap text format in the cells as shown. Mark) - Enter the marks of Mid, Assignment and final column. Mark) - Apply data validation by as follows, and generate the appropriate Input and Error messages. Marks) Mid =0 to 25 , Assignment =0 to 25 , Final =0 to 50 TASK 2: Perform the following operations on worksheet on which you have created under task1 (Using MS-Excel spreadsheet application). [03][10 Marks] - Perform these following operations using the Functions:- 1. Calculate the Total of all subjects of the mid, Assignment and final. (1 Mark) 2. Apply the conditional function to calculate the Grade (if the total is above 60, then the Grade should print as "A" or else "B"). (1 Mark) 3. Apply conditional formatting to highlight the cell background color on Grade column (if Grade is A then its color should be Blue, and if Grade is B then its color should be Orange). (1 Mark) 4. Apply conditional formatting to highlight the cell background color on Final column (if final Marks is above 25 then its color should be green, and if final Marks is below than 25 then its color should be Red . (1 Mark) 5. Apply and show how Trace precedents and Trace dependents works on formula. (1 Mark) 6. Add some more rows into the worksheet and show how Freeze panes works on rows and columns. (1 Mark) 7. Apply Pivot table to the worksheet and display with Major and Subject columns detail using Slicer. (2 Marks) 8. Apply the column chart to all mark sheets and apply the slicer to it, to display only the details of (Name and total) from the chart. (2 Marks)