Part

$1$

: Creating a One Variable Data Table in the Part

$1$

$$Sheet tab.

$1$

$)$

$$Apply a theme of your choice.

$2$

$)$

$$Change the column width to the following: A and F

$=$

$6$

$.$

$5$

$7$

$($

$5$

$1$

$$pixels

$)$

; B

$,$

$$E and I

$=$

$.$

$7$

$5$

$($

$9$

$$pixels

$)$

; C

$=$

$2$

$2$

$.$

$1$

$4$

$($

$1$

$6$

$0$

$$pixels

$)$

; D

$,$

$$G and H

$=$

$1$

$2$

$.$

$7$

$1$

$($

$9$

$4$

$$pixels

$)$

$.$

$$

$3$

$)$

$$Change the height of rows

$2$

$,$

$4$

$$and

$2$

$5$

$$to

$8$

$.$

$2$

$5$

$($

$1$

$1$

$$pixels

$)$

$$

$4$

$)$

$$In cell C

$3$

$,$

$$enter Education Savings Calculator as a worksheet title. Merge and center cell C

$3$

$$across columns C through H

$.$

$$ Pick a font color of your choice. Change the font and font size.

$5$

$)$

$$Enter Employee Name in cell C

$5$

$,$

$$Annual Salary in cell C

$6$

$,$

$$Percent Invested

$($

up to

$)$

$$in cell C

$7$

$,$

$$Annual Returns in cell C

$8$

$,$

$$Years in cell C

$9$

$,$

$$Monthly Contributions in cell C

$1$

$0$

$,$

$$and Future Value in cell C

$1$

$1$

$.$

$$

$6$

$)$

$$Add the data in Table A to column D

$.$

$$Use the currency and percent style formats to format the number in the range D

$6$

:D

$8$

Table A

Row Title Data

Employee Name Josh Velez

Annual Salary $

$9$

$4$

$,$

$2$

$5$

$0$

Percent Invested

$6$

$.$

$0$

$0$

$\%$

Annual Return

$5$

$\%$

Years

$1$

$8$

$7$

$)$

$$Use the Create from Selection button to assign the row title in column C

$($

range C

$6$

:C

$1$

$1$

$)$

$$as cell names for the adjacent cells in column D

$.$

$$Use theme newly created names to assign formulas to cell in the range D

$1$

$0$

:D

$1$

$1$

$.$