Sheet$1$ FlexPay.

b$.$ Type Flex Pay Calculator in cell A$1.$ Apply bold, $20$ pt font size, Blue, Accent $1,$ font color.

c$.$ Type Inputs in cell A$2.$ Apply Thick Outside Borders to the range A$2$:C$2.$

d$.$ Type APR and # of payments in the range A$3$:A$4,$ and adjust the column width as needed.

e$.$ Type $1\mathrm{.}75\%$ in cell B$3$ and $36$ in cell B$4.$ Type Outputs in cell A$6.$ Select the range A$6$:C$6$

and apply Thick Outside Borders.

f$.$ Type Model in cell A$7,$ Price in cell B$7,$ and Payment in cell C$7.$ Next enter the price

information listed below in the range A$8$:B$10.$ Adjust the column width as needed and apply

Currency Number Format to the range B$8$:C$10.$

g$.$ Use the PMT function in cell $C8$ to calculate the monthly flex payment for the first option. Be

sure to use the appropriate absolute$,$ relative, or mixed cell references. Next use the fill handle

to copy the function down, completing the range C$8$:C$10.$

h$.$ Type Highest payment, Average payment, and Lowest payment in the range A$12$:A$14.$

Resize column A as needed.

i$.$ Use the MAX function in cell B$12$ to calculate the highest flex payment, in cell B$13$ use the

AVERAGE function to calculate the average flex payment, and in cell B$14$ use the MIN function

to calculate the lowest flex payment.

j$.$ Insert a footer with your name on the left side, the sheet name in the center, and the file name

code on the right side of the worksheet.

k$.$ Save and close the workbook. Based on your instructor's directions, submit

e$02$m$2$SmartPhone$\_$LastFirst.