Question $4(7$ points$)$

Select cell J$10.$

Enter a formula into column $J10$ to calculate the change in employees from prior year. The formula for this is: $\frac{\text{C}\text{u}\text{r}\text{r}\text{r}\text{e}\text{n}\text{t}\text{Y}\text{r}\text{E}\text{m}\text{p}\text{l}\text{o}\text{y}\text{e}\text{e}\text{s}-\text{P}\text{r}\text{i}\text{o}\text{r}\text{Y}\text{r}\text{E}\text{m}\text{p}\text{l}\text{o}\text{y}\text{e}\text{e}\text{s}}{\text{P}\text{r}\text{i}\text{o}\text{r}\text{Y}\text{r}\text{E}\text{m}\text{p}\text{l}\text{o}\text{y}}$

Bulk copy $($using the fill handle$)$ this formula down all rows of the data table.

What is the change in number of employees for the year $1990($Cell J$16)?$

$66\mathrm{.}7\%$

$22\mathrm{.}9\%$

$34\mathrm{.}6\%$

$3\mathrm{.}8\%$

$35\mathrm{.}0\%$

$6\mathrm{.}7\%$

Hide hint for Question $4$

Dont forget about PEMDAS.

The value displayed in cell $J10$ should be $66\mathrm{.}7\%$