please complete only #10-#15

10 9 Create a Data table in the range B: 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. 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 dosest to $4,200 per month. Click cell A1. Grader-Instructions Excel 2022 Project Step Instructions Bisplay the Advertising Costs by Quarter sheet Name the following tanges B6: E9 Newspaper_Costs B10:E14 Digital_Costs B15.E16 Magazine_Costs B17:E17 Billboard_Costs Inserta 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 11 Display the Name Manager, click Digital Costs and then in the Refers to box edit as. Option \#I Reduce the Loan \begin{tabular}{c|lr} \hline 8 & Amount of Loan & $391,456 \\ \hline 9 & Period (years) & 10 \\ \hline 10 & Interest Rate (per year) & 5.25% \\ \hline 11 & Payment (per month) & $4,200.00 \\ \hline 12 & & \\ \hline \end{tabular} Option \#2 Increase Years \begin{tabular}{llr} 14 & Amount of Loan & \\ \hline 15 & Period (years) & $425,000 \\ \hline 16 & Interest Rate (per year) & 11.16 \\ \hline 17 & Payment (per month) & 5.25% \\ \hline 18 & $4,200.00 \\ \hline 19 & \end{tabular} \begin{tabular}{l|l|l|l|l} A & B & C & D \end{tabular} Joan's Flowers Advertising Costs \begin{tabular}{l|l|l|} \hline 3 & Annual Costs for Springfield Stores \\ \hline 4 & & \\ \hline 5 & Newspaper_Costs & $ \\ 6 & Digital Costs \\ 7 & Magazine_Costs & \\ \hline \end{tabular} 8 Signage_Costs 9 Total \begin{tabular}{l} 1110 \\ 1312 \\ \hline1514 \\ 1716 \\ 1918 \\ 2019 \\ 2322 \\ 2524 \\ \hline2726 \\ \hline 28 \end{tabular} Ready Pothouse Purchase Payment Table Advertising Costs by Quarter 10 9 Create a Data table in the range B: 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. 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 dosest to $4,200 per month. Click cell A1. Grader-Instructions Excel 2022 Project Step Instructions Bisplay the Advertising Costs by Quarter sheet Name the following tanges B6: E9 Newspaper_Costs B10:E14 Digital_Costs B15.E16 Magazine_Costs B17:E17 Billboard_Costs Inserta 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 11 Display the Name Manager, click Digital Costs and then in the Refers to box edit as. Option \#I Reduce the Loan \begin{tabular}{c|lr} \hline 8 & Amount of Loan & $391,456 \\ \hline 9 & Period (years) & 10 \\ \hline 10 & Interest Rate (per year) & 5.25% \\ \hline 11 & Payment (per month) & $4,200.00 \\ \hline 12 & & \\ \hline \end{tabular} Option \#2 Increase Years \begin{tabular}{llr} 14 & Amount of Loan & \\ \hline 15 & Period (years) & $425,000 \\ \hline 16 & Interest Rate (per year) & 11.16 \\ \hline 17 & Payment (per month) & 5.25% \\ \hline 18 & $4,200.00 \\ \hline 19 & \end{tabular} \begin{tabular}{l|l|l|l|l} A & B & C & D \end{tabular} Joan's Flowers Advertising Costs \begin{tabular}{l|l|l|} \hline 3 & Annual Costs for Springfield Stores \\ \hline 4 & & \\ \hline 5 & Newspaper_Costs & $ \\ 6 & Digital Costs \\ 7 & Magazine_Costs & \\ \hline \end{tabular} 8 Signage_Costs 9 Total \begin{tabular}{l} 1110 \\ 1312 \\ \hline1514 \\ 1716 \\ 1918 \\ 2019 \\ 2322 \\ 2524 \\ \hline2726 \\ \hline 28 \end{tabular} Ready Pothouse Purchase Payment Table Advertising Costs by Quarter