Question $10$

$20$ pts

The following formula was entered into cell Q$12$ on an Excel worksheet:

$=F$$$\frac{12}{\text{\$}}M12$

If cell Q$12$ is copied and pasted into cell S$15,$ which of the following shows how relative referencing will change this formula?

$=1$$$\frac{15}{\text{\$}}M15$

$=H$$$\frac{15}{\text{\$}}M15$

None of the answers are correct.

$=I$$$\frac{12}{\text{\$}}M15$

$=H$$$\frac{12}{\text{\$}}O15$

$=H$$$\frac{12}{\text{\$}}M15$