Open the Testz Partz Vit Start File.xlsx workbook located in your drop box and save the workbook as VourCondoriD$-$Test Z$-$Partz

In the Documentation worksheet, enter your name and the date $(1$ mark$)$

In the Income Statement worksheet, in the range DG:G$6,$ enter formulas that reference lce Skates Sold value in cell $B6$ and the Revenue, Expenses, and Net Income values in the range $826$:$B28.(4$ marks$)$

Enter Ice Slcates Sold values that start at $21000$ in D$7$ and increase by $1000$ to $29000.$ Create a one$-$variable data table in the range D$7$:G$16.[3$ marks$]$

Create a cost$-$volume$-$profit $($break even$)$ chart of the revenue and expenses values in the one$-$variable data table. Resize the chart to cover D$17$:H$32.$ Remove decimal places. Make the $x-$Axis start at $20,000$ and the $Y-$Axis start at $1,150,000.$ Format the chart with propertitles. $(3$ marks$)$

In the range I$7$:N$16,$ create a two$-$variable data table in which ice skates sold values are like $D7$:$D16.$ Place the average blade price in the range $16$:$N6$ with values from $$50$ to $$70$ in $$5$ increments. Have the data table display the net income for each combination of scooters sold and average price. Format the formula in cell $16$ to display the text "Skates Sold". $(5$ marks$)$

Create a scatter chart of the net income values from the two$-$variable data table, displaying each average sales price as a different line in the chart. Remove decimal places. Format the chart appropriately; make sure that the chart legend identifies each line by the average sales price value listed in row $6.$ Make the X$-$Axis start at $20,000.$ Resize the chart to cover I$17$:N$32.(4$ marks$)$

Use the Scenario Manager to display the different scenarios listed below. Use namec ranges for input and result cells. $(6$ marks$)$

Pag