Question

An absolute reference to row 5 in the reference to cell c5

Answer 1

Copy the formula `=$C$5` from C7, paste it to C8:C10. Then, copy C7:H10 and paste it to D7:H10 to complete the projections based on the provided growth rates and initial values.

Absolute Reference to Row 5 in Cell C5

An absolute reference to row 5 in cell C5 would mean fixing the row number when the formula is copied to other cells but allowing the column to change. In Excel, this is denoted using the dollar sign symbol `$`.

So, an absolute reference to row 5 in cell C5 would be: `=$C$5`

Copying Formulas to Complete the Table of Projections

Given the table structure provided, let's follow the instructions:

1. Copy the formula from cell C7 to the range C8:C10:

- Select cell C7, copy the formula.

- Highlight the range C8:C10.

- Paste the formula into this range.

2. Copy the formulas from the range C7:C10 to the range D7:H10:

- Highlight the range C7:H10.

- Copy the formulas.

- Paste the formulas into the range D7:H10.

This process will populate the table with the projected values based on the given growth rates (4%, 8%, 12%, 16%, 20%, 24%, 28%) and the initial value of 10,000 for each year from 2021 to 2025.

Question:

b. Use an absolute reference to row 5 in the reference to cell C5.

C. Copy the formula from cell C7 to the range C8:C10, and then copy the formulas from the range C7:C10 to the range D7:110 to complete the table of projections.

Answer 2

To make absolute references excel provides the $ operator.

Assume cell C1 uses the formula =A1+B1 to calculate the sum of cells A1 and B1.

Now, suppose the user used a fill handle to duplicate this formula till cell C10; in this scenario, Excel will automatically update this formula so that the formula in cell C2 becomes =A2+B2, and the formula in cell C3 becomes =A3+B3, and so on...

This is a relative reference, and the formula was changed as a result of the reference to cells A1 and B1.

Absolute reference - To make absolute references excel provides the $ operator,

Taking the same example as before, use absolute reference in cell C1 to calculate the sum of cells A1 and B1 using the new formula =$A$1+$B$1, now even after using the fill handle the copied formula in cells C2, C3, C4... remains the same and they will all display sum of cell A1 and B1.