Format Data 18 marks You need to format the titles and numeric data in the HenSales sheet. In addition, you want to freeze the column labels so that they do not scroll offscreen. You also want to apply conditional formatting to emphasize values above the average value. a) Create a name for this restaurant and a company logo (image file). Insert your company logo (image file) into the HenSales and PoultryLoan worksheets and place the top-right corner of the logo in cell A1. Ensure the logo does not overlap other content. Ensure the logo is the same size on both worksheets. b) On the HenSales worksheet, merge and center the main title Hen Sales Assessment, across the Menu Item table. Format the title in a larger font and fill the cell with a shade of light blue colour. c) Move the date cells (C4:D4) to K1:L1. d) Apply accounting number format to the monetary values in columns E and F. e) Format the Avg Monthly Qty Sold values with one decimal place. f) Freeze column A so it does on scroll offscreen. g) Apply conditional formatting to values in the Total Revenue column. When a cells value is greater than the average of the values in the column the cell fills with colour. h) Change the red formatting on the column headings on the HenSales worksheet to some other colour(s) that better suits your company logo and company colours. Ensure the cell contents fits the cell and is clearly seen. i) Click on the PoultryLoan worksheet. You would like to use the repayment option that keeps the monthly payment amount under $1050, has the shortest term, and the lowest interest rate. Locate the Cell that meets these conditions and add a Comment saying Best-Choice! Create Sparklines and Insert a Chart 6 marks You will create a chart comparing the total revenue for each menu item, and you will insert sparklines to display trends over a four-month period of time. a) On the RoosterSales worksheet create Sparklines (lines) in Cells F15:F20 to display four-month trends for actual sales for each menu item. Show the high point in each sparkline. Apply a Sparkline Style of your choice. b) Create a Chart comparing the Total Revenue for each of the Menu Items. Select a 3-D Cluster Column chart type. c) Position the Chart beside the Actual Sales Quantities area and ensure it does not extend past column P. Apply any Chart Style to this Chart. Change the Chart Title to Hen Sales Revenue by Menu Items. COMP126 Excel 2019 Project 2 Page 4 of 4 Sort and Filter the Data 16 marks To preserve the integrity of the original data, you copy the worksheet. You will then convert the data in the copies worksheet to a table, and apply a table style, sort and filter the data, and then display totals. a) Copy the HenSales sheet and place the copied sheet at the beginning of the workbook. b) Remove the conditional formatting rule on the HenSales (2) sheet. c) Convert the data in the Menu Item area in the HenSales (2) sheet to a table. d) Set the formula recalculation to Manual (otherwise sort does not produce correct results) e) Sort the table by % of Projection in descending order. f) Apply a filter to display the top 3 performers only. g) Display a total row. Add totals for columns B, C, and F. h) On the HenSales worksheet, create a footer with the file name on the left side, your student number in the center, and the current date on the right side. i) On the RoosterSales worksheet, apply 0.5 (1.25 cm) left and right margins. Scale to fit on one page. Select Landscape orientation. Preview to ensure all is set correctly.

Can you give me the commands please?