sdcourtneyholcro

Admissions Home $|$ Admissions

LTI Launch

Excel In Practice Capstone $7-9-x$

rsu.simnetonline.com$/$sp$/$assignments$/$projects$/$details$/8714732$

d$.$ Show the $1\mathrm{.}25\%$ scenario in the worksheet.

Go to the Forecast worksheet.

b$.$

Complete the growth rate series for the data table in cells D$20$:D$27.$ The formula references are already entered in row $17.$

Build the data table with column input cell B$12.$ The results are incorrect, because input values and the formula reference must be on the same worksheet. SAVE.

Format data table results as Currency with no decimal places.

Edit formulas to use a reference on the same sheet.

a$.$ Click cell D$5.$ The data table indirectly refers to this formula which uses the growth factor in cell F$3$ on the Factors sheet.

b$.$ Edit the formula to show $(1+$$$B$$$12)$ in place of the reference to cell $F3$ on the Factors sheet. This is the input value for the data table.

c$.$ Copy the formula to the cells E$5$:G$5$ and then to cells D$6$:G$7,$ and fill without formatting. NOTE: Q$1$ cell D$5$ results should be $$345,516.$

Select B$4$:H$7$ and create a PivotTable. Note: the PivotTable should appear on its own worksheet.

a$.$ Rename PivotTable sheet ForecastPivot.

b$.$ Put Category in Row area and Q$1$ Next Year through Q$4$ Next Year in Values area. Should be $4$ values.

$78F$

Mostly sunn

Search