Sarate be i_num). 201 specify and more /572500 and over jy has updated the Golf workbook and renamed it Golf2. He consolidated the order ormation on a worksheet named Orders, and added worksheets for pricing information, landing charges (including a maximum fee), discounts, and shipping charges. Figure 5.25 shows the Orders worksheet with some order-related data already entered. Figure 5.25+ Orders worksheet in the Golf2 workbook Handling charge 0.7% of the total order amount 0.6% of the total order amount 0.5% of the total order amount 0.4% of the total order amount 0.3% of the total order amount 0.2% of the total order amount A maximum handling charge of $30 is applied to all orders , , Order Amount rober $2.500 $2,500-35,000 5,000-$7.500 157500-$10,000 510,500-$12,500 calculate Ows the 5 Al orders 2014 Cangage learning Level 2 E B D 1 Golf Products Order Form 2 Shipping weight 175 3 Region number 1 4 Shipping method 3 5 Customer type 2 6 7 ltema Quantity DescriptionTotal 8 1 10 9 7 2 10 4 8 11 15 2 2 12 5 20 13 14 15 Tatal Order 16 Shipping 17 Handling 18 Discount 19 20 Grand Total 21 on ed. as ng by Te In thesc steps, you need to complete the Orders worksheet using lookup functions to display the product description, and to calculate the order total and shipping, handling, and discount charges. Complete the following: 1. Open the workbook named Golf2.xlsx located in the Chapter 5 folder, and then save the file as Golf Orders 2.xlsx. 2. Examine the contents of each worksheet, and name the ranges listed in Table 5.10. Use these range names as appropriate in Questions 3 through 9. 315 Sarate be i_num). 201 specify and more /572500 and over jy has updated the Golf workbook and renamed it Golf2. He consolidated the order ormation on a worksheet named Orders, and added worksheets for pricing information, landing charges (including a maximum fee), discounts, and shipping charges. Figure 5.25 shows the Orders worksheet with some order-related data already entered. Figure 5.25+ Orders worksheet in the Golf2 workbook Handling charge 0.7% of the total order amount 0.6% of the total order amount 0.5% of the total order amount 0.4% of the total order amount 0.3% of the total order amount 0.2% of the total order amount A maximum handling charge of $30 is applied to all orders , , Order Amount rober $2.500 $2,500-35,000 5,000-$7.500 157500-$10,000 510,500-$12,500 calculate Ows the 5 Al orders 2014 Cangage learning Level 2 E B D 1 Golf Products Order Form 2 Shipping weight 175 3 Region number 1 4 Shipping method 3 5 Customer type 2 6 7 ltema Quantity DescriptionTotal 8 1 10 9 7 2 10 4 8 11 15 2 2 12 5 20 13 14 15 Tatal Order 16 Shipping 17 Handling 18 Discount 19 20 Grand Total 21 on ed. as ng by Te In thesc steps, you need to complete the Orders worksheet using lookup functions to display the product description, and to calculate the order total and shipping, handling, and discount charges. Complete the following: 1. Open the workbook named Golf2.xlsx located in the Chapter 5 folder, and then save the file as Golf Orders 2.xlsx. 2. Examine the contents of each worksheet, and name the ranges listed in Table 5.10. Use these range names as appropriate in Questions 3 through 9. 315
