RaiderGolf is looking to create a reusable order form for golf equipment. This order form must include shipping charges

[answerhappygod]

RaiderGolf is looking to create a reusable order form for golfequipment. This order form must include shipping charges and adiscount for orders according to their total amount. In addition,the form must add a handling charge because most golf equipmentmust be packed by hand. The RaiderGolf salesclerk has placedinformation about pricing, handling charges (including the maximumcharge), discounts, and shipping charges on worksheets in an Excelfile. Your task is to complete the Orders worksheet using lookupfunctions to display the product description and to calculate theorder total and shipping, handling, and discount charges. Youcannot use any IF functions for this exercise – use will cause aloss of points.
Complete the following:
Range Name
Worksheet
Cells
ItemPrice
Costs
A5:C20
HandlingFee
Handling
B2:G3
Disc
Discounts
A2:A5
TotOrderVol
Discounts
B2:B5