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: