Payment Calculator sheet

$1.$ In cell D$7,$ use the function which will calculate the payment the customer will owe each month.

$2.$ Complete the two variable data table in cells F$5-$K$20$ which shows the payment based upon the number

of months by interest rate $($Note$,$ you must use the Data Table tool in Excel $$ there will be no

duplicated values in the Data Table. If there are then your data table is incorrect. You can highlight

cells G$6$ K$20$ and press the Delete key to try it again. If it isn$$t responding, press the Esc key once or

twice, then try it again$).$

$3.$ In cell D$7,$ perform $$Goal Seeking$$ to keep the monthly payment at $$550$ by changing the Sales Price.

Accept the goal seeking changes. Copy and paste the new Sales Price in cell B$5$ to cell B$12($to store for

later$).$

$4.$ Change the Sales Price $($B$5)$ back to $$32,000.($Note$,$ when you do this, cell B$12$ should not change to

$$32,000)$Copy$+$of$+$Excel$\_$Exam$\_$Workbook$\_$Exam$\_$Fall$\_18$

Read Only $-$ Adding data to this location is not allowed. You can save changes to a location allowed by your organization.

$\backslash$table$[[,$A$,$B$,$C$,D,$E$,$F$,$G$,H,$I,J$,$K$,$L$,$M$,N,O,P$