Figure $4-67$

Perform the following tasks:

Type Impact of Varying Annual Return and Employee Percent Invested in

cell I$1.$ Type Annual Return in Left Column and Employee Percent Invested

in Top Row in cell I$3.$

Save the workbook using the file name, SC$\_$EX$\_4\_$Planning.

Change the width of column $H$ to $0\mathrm{.}92(11$ pixels$).($Depending on your display settings, you may

need to use the Column Width dialog box.$)$ Merge and center the titles in cells I$1$ and I$3$ over

columns I through Q$.$ Format the titles using the Title cell style for both the title and subtitle, a font

size of $18$ for the title, and a font size of $16$ for the subtitle. Change the column widths of columns

I through Q to $13\mathrm{.}14(97$ pixels$).$ Format cells I$1$ and I$3$ to match the fill and font color in cell B$1.$

For a two$-$input data table, the formula you are analyzing must be assigned to the upper$-$left

cell in the range of the data table. Because cell C$14$ contains the future value formula to be

analyzed, enter $=$ c$14$ in cell I$4.$

Use the fill handle to create two lists of percentages: $($a$)4\mathrm{.}00\%$ through $13\mathrm{.}00\%$ in increments

of $0\mathrm{.}50\%$ in the range $15$:$I23$ and $($b$)4\mathrm{.}00\%$ through $11\mathrm{.}00\%$ in increments of $1\mathrm{.}00\%$ in the

range J$4$:Q$4.$

Use the Data Table button in the What$-$If Analysis gallery $($Data tab I Forecast group$)$ to define

the range I$4$:Q$23$ as a two$-$input data table. Enter C$8$ in the 'Row input cell' box and C$5$ in

the 'Column input cell' box $($Data Table dialog box$).$ Click OK to populate the table.

Format the two$-$input data table using a White, Background $1$ font color and the fill color used

in cells B$3$:G$12.$ Bold ranges I$4$:Q$4$ and I$5$:I$23.$ Format cells J$5$:Q$23$ to match the number format

used in cells F$5$:G$12.$ Place a light style border around the range $I3$:$Q23,$ light style borders

between columns in that same range, and a light style bottom border on the range I$4$:Q$4.$

Protect the worksheet so that the user can select only unlocked cells $($C$3$:C$6$ and C$8$:C$9).$

If necessary, change the print orientation to landscape. Print the worksheet using the Fit to

option. Print the formulas version of the worksheet.

If requested by your instructor, change the name in cell $C3$ to your name.

Save the file with the same filename and submit the revised workbook in the format specified by

your instructor.

How could you improve the design of the worksheet to make the impact of various

combinations of Employee Investment and Expected Annual Return more easilyidentified?Use the fill handle to create two lists of percentages: $($a$)4\mathrm{.}00\%$ through $13\mathrm{.}00\%$ in increments

of $0\mathrm{.}50\%$ in the range $15$:$I23$ and $($b$)4\mathrm{.}00\%$ through $11\mathrm{.}00\%$ in increments of $1\mathrm{.}00\%$ in the

range J$4$:Q$4.$

Use the Data Table button in the What$-$If Analysis gallery $($Data tab I Forecast group$)$ to define

the range I$4$:Q$23$ as a two$-$input data table. Enter $C8$ in the 'Row input cell' box and $C5$ in

the 'Column input cell' box $($Data Table dialog box$).$ Click OK to populate the table.

Format the two$-$input data table using a White, Background $1$ font color and the fill color used

in cells B$3$:G$12.$ Bold ranges I$4$:Q$4$ and I$5$:I$23.$ Format cells J$5$:Q$23$ to match the number format

used in cells F$5$:G$12.$ Place a light style border around the range I$3$:Q$23,$ light style borders

between columns in that same range, and a light style bottom border on the range I$4$:Q$4.$

Protect the worksheet so that theUse the fill handle to create two lists of percentages: $($a$)4\mathrm{.}00\%$ through $13\mathrm{.}00\%$ in increments

of $0\mathrm{.}50\%$ in the range $15$:$I23$ and $($b$)4\mathrm{.}00\%$ through $11\mathrm{.}00\%$ in increments of $1\mathrm{.}00\%$ in the

range J$4$:Q$4.$

Use the Data Table button in the What$-$If Analysis gallery $($Data tab I Forecast group$)$ to define

the range I$4$:Q$23$ as a two$-$input data table. Enter $C8$ in the 'Row input cell' box and $C5$ in

the 'Column input cell' box $($Data Table dialog box$).$ Click OK to populate the table.

Format the two$-$input data table using a White, Background $1$ font color and the fill color used

in cells B$3$:G$12.$ Bold ranges I$4$:Q$4$ and I$5$:I$23.$ Format cells J$5$:Q$23$ to match the number format

used in cells F$5$:G$12.$ Place a light style border around the range I$3$:Q$23,$ light style borders

between columns in that same range, and a light style bottom border