Edit the Report_Title macro to display the Visual Basic Editor. Select and copy all of the code, close the 11 Visual Basic Editor window, and then paste the code in cell A32. Display the worksheet in Page Break 4.000 Preview. Move the page break to position it between rows 30 and 31 so that the VBA code displays on Page 2. Return to Normal View and save the file as a macro-free workbook. 12 On the Product Information worksheet, select the range A4:C11, and then sort the data by Style Code in 2.000 ascending order. Select the range A5:C11 and then name the selection Lookup_Table. On the Phone Order worksheet, in cell A9, type P-SR and then press TAB. In cell B9, use a VLOOKUP 13 function to lookup the Item in cell A9 and insert the description from the Product Information worksheet 6.000 using the Lookup_Table range as the table array. The description is in column 2 of the table array. Fill the formula down through B18. In cell C9, type 10 and in cell D9, type Black and then press TAB. In cell E9, use the VLOOKUP function to insert the unit price of the item in cell A9 using the 14 Lookup_Table range as the table array. The unit price is in column 3 of the table array. Fill the formula 6.000 down through E18. 15 In cell A10, type C-BK and in C10 type 12. In cell D10 type Red and then delete rows 11:18. Sum the 2.000 Order Amount and apply the Total cell style. 16 On the Phone Order sheet, insert the eCap_Draft.png picture on the Sheet Background. 2.000 On the Skier Attendance worksheet, in the range G4:G10, insert Line Sparklines to show the attendance trend for each location over the five-year period. Show the High Point and Low Point and apply 17 Sparkline Style Dark #3. 5.000 Note, the style name may be Red, Sparkline Style Dark #3, depending on the version of Office used