Please make the following modifications to the spreadsheet,

1. Enter ="The interest rate is " in cell B34.

Use the "&" function and the offset function to output the following in cell D34.

The interest rate is 10%. (or whatever the value of the interest rate is).

The output in cell B34 should update based on the current value in cell C31.

You will need to use the OFFSET function to reference the interest rate. The row entry will be constant but the OFFSET function will need to use the output from C31.

2. Enter ="The number of years is " in cell B35.

Use the "&" function and the offset function to output the following in cell D35.

The number of years is 3. (or whatever the number of years is).

The output in cell B35 should update based on the current value in cell C32.

You will need to use the OFFSET function to reference the interest rate. The column entry will be constant but the OFFSET function will need to use the output from C32.

File Home Insert Page Layout Formulas Data Review View Power Pivot Te l me what you wan 19 20 OFFSET 21 Table of PVIF's 0% 2% 5% 10% 24 26 27 28 29 30 31 32 1 0.9804 0.9524 0.9091 1 0.9612 0.9070 0.8264 1 0.9423 0.8638 0.7513 1 0.9238 0.8227 0.6830 1 0.9057 0.7835 0.6209 Row Column Output The interest rate is 0.9804 34 35 Sheetl File Home Insert Page Layout Formulas Data Review View Power Pivot Te l me what you wan 19 20 OFFSET 21 Table of PVIF's 0% 2% 5% 10% 24 26 27 28 29 30 31 32 1 0.9804 0.9524 0.9091 1 0.9612 0.9070 0.8264 1 0.9423 0.8638 0.7513 1 0.9238 0.8227 0.6830 1 0.9057 0.7835 0.6209 Row Column Output The interest rate is 0.9804 34 35 Sheetl