PART B: C lick on the Transaction sheet Use the data in the Transaction sheet to answer the following questions : 1 . Use the data in the Transaction sheet and calculate the profits each record column M and create formula using SUMPRODUCT to get the total revenue in cell 012 . Take returns consideration for both calculations and into keep in mind whether Unit Costs should included in your calculation or not . ( 1 points 2 . During the ordering process of the Ergobeds some customers have entered in their addresses with minor typos Their most common errors are duplicate spaces and incorrect capitalization . Use the appropriate Text function ( s ) in column to revise the addresses ( . 5 point Given the negative goodwill caused by the problem with production quality Karake Inc . has decided to offer customers quantity discount on the ErgoBeds Line Discount is based on the quantity ordered as based on the " Discount_ able " in range Q 2 : R 8 on the Transaction Sheet. What the " Discount_T a b le " indicates is that if the order is less than 35 beds (X