Using the spreadsheet provided, edit the cells to include the following controls:

Annual fee cannot exceed $8\%$ of purchase cost.

Training costs cannot exceed $$12,000$ in year $0$ and $$3,000$ thereafter.

$($Enter the annual training costs in cell B$10$ and enter initial year $0$ training costs in cell D$10).$

Annual savings due to efficiency cannot exceed $$5,000,$ but must be zero in year $0.$

Cell C$2($highlighted in yellow to the right of the word $$Answer$)$ must force entry of either $$YES$$ or $$NO$$ no other values can be accepted.

$($hint: use cells A$30$ and A$31$ as the source for a dropdown list$).$

Your name must appear in cell C$3,$ and the cell must ensure that any name entered cannot exceed $30$ characters total.

Cell B$8($annual fee$)$ must NOT permit any alphabetic text.

The reduction in risk due to the security investment $($cell B$18)$ must range between $2\%$ and $8\%,$ inclusive.

Lock the spreadsheet so that data can only be entered in these cells $($all highlighted in yellow in the spreadsheet$)$:

C$2$

C$3$

B$8$

B$10$

B$12$

B$18$

D$10$

A$30$

A$31$