PROJECT STEPS

$1.$ In cell B$8,$ decrease the indent by one level. Copy the values in the range C$26$:G$26,$ and then paste only the values in the range C$8$:G$8.$ Delete row $26$ to remove the repeated data.

$2.$ Use Goal Seek to set cell C$11$ to the value of $300$ by changing cell C$7.$

$3.$ In cell H$4,$ insert a Line sparkline based on the data in the range C$4$:G$4.$ Fill the range H$5$:H$9$ without formatting based on the contents of cell H$4.$ Change the color of the sparklines in the range H$4$:H$9$ to Gold, Accent $6,$ Darker $25\%(10$th column, $5$th row of the Sparkline Theme Colors gallery$).$ Add markers for each month, and then change the marker color to Green, Accent $4,$ Darker $50\%(8$th column, $6$th row of the Sparkline Theme Colors gallery$).$

$4.$ Copy the formula in cell K$4$ and then paste the formula and number formatting in the range K$5$:K$8.$