To answer these questions, please use your knowledge of Excel and your materials that you have seen in class and on assignments.

A PMT function is placed in cell $A4.$ Which cell$-$A$1,$ A$2,$ A$3,$ or A$4$ will contain the amount of the loan, given the function $=PMT(A{1}_{,}A2,A3)?$

a$.$ A$1$

b$.$ A$2$

C$.A3$

D$.$ A$4$

The function $)>(A2,A1+A2,A1**A2$ returns

a$.$ The product of cells $A1$ and $A2$ if cell $A1$ is greater than $A2$

b$.$ The sum of cells $A1$ and $A2$ if cell $A1$ is less than A$2$

c$.$ Both $($a$)$ and $($b$)$

d$.$ Neither $($a$)$ nor $($b$)$

Given that cells B$6,$ C$6,$ and D$6$ contain the numbers $10,20$ and $30,$ respectively, what value will be returned by the function $)>(10,C6**2,D6**3?$

a$.90$

b$.60$

c$.40$

d$.10$

You want to copy a formula to several different cells. Which of the following cell references would be used to create a formula where the row changes, but not the column, when the formula is copied elsewhere?

a$.$ $C$4$

b$.$ C$$4$

c$.$ $$C$$$4$

d$.$ C$4$

e$.$ Each of the above are references where the column would not change during the copy process.

The annual interest rate, term in years, and principal of a loan are stored in cells $A1,A2,$ and $A3,$ respectively. Which of the following is the correct PMT function, given monthly payments?

a$.=PMT(A1,A2,-A3)$

b$.$

c$.=PMT(A1**{12}_{,}A\frac{2}{12},-A3)$

d$.=PMT(A\frac{1}{12},A_2**12,-A3)$