The Youtube video above explains how to create data validation rules in Excel.

Retrieve the spreadsheet attached to this assignment and use the Data Validation control in Excel to accomplish the following controls:

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

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

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

$4.$ 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.

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

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

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

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

a$.$ C$2$

b$.$ C$3$

c$.$ B$8$

d$.$ B$10$

e$.$ B$12$

f$.$ B$18$

g$.$ D$10$