In this week's Excel assignment you will be calculating the job costs for 3 jobs performed during the year of a high-end custom furniture manufacturer and comparing the profitability with historical jobs of the company. On the "2021 Jobs" tab, calculate and sum the total job costs for each job with the information provided. Once the cost of each job is calculated, populate the job costs on the "Historical Jobs" tab for the respective Jobs. In separate columns, calculate the profit for each job and the profit margin % (profit divided by revenue). Once the profit and profit margin % columns are populated for each job complete the following steps in this order: 1) Highlight all jobs that produced a loss in red 2) Highlight the job with the highest profit margin % in green 3) Apply FILTER to the data and sort the Profit column by Largest to Smallest. Submit Excel workbook with highlights and FILTER applied as instructed. Please follow rubric and naming conventions outlined in Week 1 and in the rubric. Please let me know if you have any questions. Thank you!

x AutoSave Off Excel 2 - FILTER E File Home Insert Draw Page Lay 4 \ 2021 Jobs Historical Jobs Ready {P Accessibility: Good to go 76F Mostly sunny