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