Step Instructions Point Value

$1$ Start Excel. Download and open the file named Exp$19\_$Excel$\_$Ch$02\_$Assessment$\_$SmartPhone.xlsx$.$ Grader has automatically added your last name to the beginning of the filename. $0$

$2$ Rename Sheet $1$ FlexPay. Hint: Double$-$click the sheet name tab to rename the worksheet. $4$

$3$ Type Flex Pay Calculator in cell A$1,$ and then merge and center the title on the first row in the range A$1$:C$1.$ Apply bold, $20$ pt font size, Blue, Accent $1,$ font color. $8$

$4$ Merge and center the range A$2$:C$2,$ type Inputs, and apply Thick Outside Borders. Note, Mac users, apply Thick Box Border. $10$

$5$ Type APR and # of payments in the range A$3$:A$4.6$

$6$ Type $1\mathrm{.}75\%$ in cell B$3$ and $36$ in cell B$4.$ Merge and center the range A$6$:C$6,$ type Outputs, and apply Thick Outside Borders. $12$

$7$ Type Model in cell A$7,$ Price in cell B$7,$ and Payment in cell C$7.9$

$8$ Type iphone x in cell A$8,$ Samsung Galaxy in cell A$9,$ and LG V$30$ in cell A$10.$ Enter the corresponding prices $949,799,$ and $650$ in the range B$8$:B$10$ and apply Currency Number Format. Resize column A as needed to display all text. $15$

$9$ In cell C$8,$ enter a PMT function to calculate the monthly flex payment for the first option. Be sure to use the appropriate absolute$,$ relative, or mixed cell references. Use the fill handle to copy the function down through cell C$10.$ Make sure each of the monthly flex payments is a positive value. $13$

$10$ Type Highest payment, Average payment, and Lowest payment in the range A$12$:A$14.5$

$11$ In cell B$12,$ use the MAX function 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. $12$

$12$ 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. $6$

$13$ Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. $0$