Start Excel. Open the file named TU$03-$ EBTM$251$ Chapter $1-$ Terra Cotta Coffee Shop.xlsx$.$ MyITLab has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files for future grading. $02$ On the "SalesData" worksheet, create the Named Range "SalesData$2022"$ for cells B$2$:M$7.13$ On the "Analysis" worksheet, in cell B$2,$ use the SUM function to calculate the total revenue from $2022,$ using the SalesData$2022$ named range. $24$ On the "Analysis" worksheet, create a Name Range "Revenue$\_$for$\_2022"$ in cell B$2$ and "Previous$\_$Year$\_$Cost" in cell B$3.25$ In cell B$4,$ estimate the $2022$ costs by multiplying the $2022$ Revenue by the Previous year's cost in B$2$ using the appropriate name ranges. $26$ Create the Name Range "Costs$\_$for$\_2022"$ in cell B$4,$ "Renovation$\_$Cost" in cell B$7$ and "Upgrade$\_$Cost" in cell B$8.37$ In cell B$5,$ calculate the $2022$ profits by subtracting the $2022$ Costs from the $2022$ Revenue. $18$ In cell D$9,$ create an in$-$cell dropdown list with the values of Yes and No $($in that order$).$ The dropdown list will be used to indicate whether or not upgraded furniture will be purchased. Select No for the value D$9.$ Hint: The Source entries in your dropdown list should not have a space after the comma. $39$ Create the Name Range "Upgrade$\_$furniture?" in cell D$9.210$ Cell B$9$ will display the renovation costs based on the renovation decision shown in D$9.$ Use an IF function to display the cost of the Renovation $($B$7)$ plus the Upgrade Cost $($B$8)$ if the D$9$ shows "Yes". Otherwise B$9$ should display just the Renovation Costs. Once your IF function equation has been completed, create the name range "Total$\_$Renovation$\_$Cost" for cell B$9.611$ In cell B$10,$ add Data Validation that will only allow investments between $120000($the minimum$)$ and $200000.($the maximum$).$ Type the value $180000$ in cell B$10.$ Now create the name range "Investment$\_$Amount" for B$10.612$ In cell B$11,$ calculate the amount needed to finance by subtracting "Investment$\_$Amount" from "Total$\_$Renovation$\_$Cost" $313$ Create the name range "Amount$\_$Needed$\_$to$\_$Finance" in cell B$11.$ In cell B$13,$ use a VLOOKUP function to retrieve the Annual Percent Rate $($e$.$g$.,$ the "APR"$)$ based on the amount needed to finance. Use the table of data in A$20$:B$25$ as required for the function. Format the results as a percentage with $2$ decimals. $1014$ Create the following name ranges: "APR$\_$for$\_$Loan" in cell B$13$ and "Term" in cell B$14.415$ In cell B$16,$ use the PMT function to calculate the monthly cost of the loan if payments are made at the end of each month. The result should be displayed as a positive number in the Currency format. Hint: The term of the loan is shown in B$14.516$ In cell B$17,$ use the PMT function to calculate the quarterly cost of the loan if payments are made at the end of each quarter. The result should be displayed as a positive number in the Currency format. $517$ Format cells B$2,$ B$4$:B$5,$ and B$7$:B$11$ in the Currency format with zero decimal places. $318$ Calculate the annual cost of the Monthly and Quarterly loans in cells D$16$ and D$17$ respectively. $219$ In cell H$3,$ type an absolute cell reference to the cell that calculates the profits for $2022.$ Copy the formula across the row to cell N$3.$ This will display results for $7$ years of stagnant profits. $($Increase the width of columns I:N if necessary.$)220$ Use the values in the list below as the estimated growth rates of annual profits in cells H$4$:N$4.$ Format the values as percentage with $2$ decimal places. Year $1$: $\mathrm{.}0925$ Year $2$: $\mathrm{.}10$ Year $3$: $\mathrm{.}0825$ Years $4-7$: $\mathrm{.}05221$ In cell H$5,$ calculate the Estimated Annual Profits in year $1$ based on the "Stagnant Annual Profit" amount in H$3$ and the "Estimated Growth Rate" in H$4.$ Format results in Currency with zero decimals. Hint: No function is necessary; simple math. Your answers in cells H$5$:N$5$ will all be greater than $$152,213.422$ In cell H$6,$ calculate the difference between the Year $1$ "Stagnant Annual Profits" and the Year $1$ "Estimated Annual Profits". AutoFill the calculation over to N$6$ and format as Currency with zero decimals. $223$ In cell H$7,$ use the SUM function to calculate the total amount of additional profits earned throughout the $7-$year period. Format cell as Currency with zero decimals. $224$ In cell I$7,$ use an IF function that will display $$Yes$$ if the Total Additional Profits $($H$7)$ would be more than the annual cost of monthly payments $($D$16).$ Otherwise, have cell I$7$ display $$No$.25$ Create a $2-$D Line chart that compares the annual Stagnant Profits to the annual Estimated Profits for each of the seven years. Have the years $($i$.$e$.,$ Year $1,$ Year $2,$ etc.$)$ displayed as categories. Place the upper left corner of the chart in G$9,$ the lower right in cell N$20.$ Update the chart as follows: $-$ Apply Style $13$ to the chart $-$ Update the Legend to read "Stagnant Profits" and "Estimated Profits". $-$ Move the Legend to the top $-$ Update the Categories to display all$-$seven years $($i$.$e$.,$ Year $1,$ Year $2,$ Year $3,$ etc.$)-$ Add a primary vert