2. Use this partial data to complete each of the steps below: a. In D5, calculate Expenses as Cost of an item multiplied by the quantity Manufactured. b. Copy the formula in D5 down through D8. c. In G5, calculate Revenue as items Sold multiplied by Price. d. Copy the formula in G5 down through G8. e. In H5, calculate Profit/Loss for Purple Leather Pants as that product's Revenue minus Expenses. f. Copy the formula in H5 down through H8 g. Total the units Manufactured in C9 h. Total the Expenses in D9 i. Total the number of items Sold in F9 j. Total the Revenue in G9 k. Total the Profit/Loss in H9 I. Add the label 'AVERAGE' in cell A10 m. In B10, use a function to calculate Average Cost in B5 through B8. n. In E10, use a function to calculate Average Price of E5 through E8. o. In F10, use a function to calculate the Average number of units Sold in F5 through F8. p. Format Cost, Expenses, Price, Revenue, and Profit/Loss values as Currency, US Dollars, with two decimals, and negative values shown in red and surrounded by parentheses. q. Format Manufactured and Sold with comma separators but no decimals