11 Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. 10.000 12 Copy the format from cell B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is closest to $4,200 per month. 3.000 Display the Advertising Costs by Quarter worksheet, and then apply appropriate 13 Currency [0] cell style to the range B6:E6 and to the range B18:E18. Apply the 2.000 range B18:E18. Comma [0] cell style to the range B7:E17, and then apply the Total cell style to the Name the following ranges: B6:E9 Newspaper_Costs; B10:E14 Digital_Costs; 14 B15:E16 Magazine_Costs; B17:E17 Billboard_Costs. 6.000 15 Insert a new row 15. In cell A15, type Designer Podcasts In cell B15, type 1250 In cell C15, type 1525 In cell D15, type 1266 In cell E15, type 1604. 3.000 16 Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Signage_Costs. 5.000 Display the Annual Advertising Costs sheet. Starting in cell B5, use the named 17 ranges to sum the values for each of the costs and then sum all the costs in cell 10.000 B9. Apply Currency [0], Comma [0], and Total cell styles to the appropriate cells. In the sheet tab row, right-click any sheet tab, and the click Select All Sheets. Display the Page Setup dialog box, click the Margins tab, and then under Center on 18 page, click Horizontally. Ungroup the sheets, display the Hothouse Purchase sheet, and then set its Orientation to Landscape. Document properties should include the 3.000 tags payment table, advertising costs. Ensure that the worksheets are correctly named and placed in the following order 19 in the workbook: Hothouse Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit 0.000 Excel. Submit the workbook as directed