I have attached the spreadsheet needed to answer the following question.

3. In the worksheet named 'HLOOKUP' do the following: a. Insert the appropriate 'HLOOKUP' formula for Price per Unit and figure out the sales total for the first two transactions of September. b. Insert the appropriate 'HLOOKUP' formula for Cost per Unit and figure out the total costs for the first two transactions of September.

HINT: Before creating the formula, define the appropriate data arraysamed ranges for both the ITEM and COSTSANDPRICES tables.

i Sales for April Units Sold Price per Unit Cost per Unit Sales Total Total Costs Transaction No. Date of Sale 4/1/20 4/2/20 Item Name Tennis Racket 70 Tennis racket Baseball bat Golf dub driver) Hockey stick Name Cost per Unit Price per Unit 100