In cell E18, add a formula using a lookup function that will look up the grand total in cell D18 in the table of sales and assessments in A22: B25, and display the corresponding assessment.( For example, if the grand total of $ 505 is displayed in cell D18, " Good " should be displayed in cell E18.) In cell E19 add the label Highest Sales. In F19 add the function formula for Maximum based on the Total Sales column. In cell E20 add the label Lowest Sales. In F20 add the function formula for Minimum based on the Total Sales column. In cell E21 add the label Average Sales. In F21 add the function formula for Average based on the Total Sales column. Place a border around the statistics data and widen columns as needed for readability. Save your work( CTRL + s). Lists, sorting, charts, and conditional formatting( Excel; TCOs 4 and 6; 40 points) Using the ‗ Quest 1 & 2‘ Worksheet: Convert the list of products, unit prices, quantities, and total sales in A3: D17 into a table on the Quest 3 – Lists & Sorting sheet starting in cell A1. Using the ‗ Quest 3 – Lists & Sorting‘ worksheet: Sort the table into descending order( highest to lowest) by Total Sales. Apply conditional formatting to the Total Sales column so that sales greater than $ 1,000 are highlighted in green. Create a pivot table using the table data from Quest 1 & 2 on a new sheet and name it MoD-3b. Then move it after ‗ Quest 3 Lists & Sorting‘. Create a pivot showing the list of products in alphabetical order, showing total sales by product with appropriate currency formatting. Create, on this same sheet, a line graph using the sales data from the pivot table. Add chart title and labels as appropriate. Save your work( CTRL + s). Functions and Financials( TCO‘ s 2, 6, and 7; 30 points) Using the Quest 4-Financials worksheet: Complete the Profit and Loss Statement provided by adding formulas( referenced shaded cell locations) and using the product and Total Sales data already included in Quest 1 & 2. Note: Do not just re-key